This usually means the amount of space allocated for the database is full and the dump command can't write the checkpoint record. Have the user run the ALTERDATABASE command to expand the size allocated for the database. The syntax for the ALTERDATABASE command is in the TRANSACT SQL Reference Guide supplied by Microsoft or through the on-line help.
The ESPE transaction replaced the DFHPEP exit. It obtains the CICS 3270 screen image and takes all of the diagnostics gathered at abend time, then formats and writes a WRK record containing those diagnostics.
If you select any “Active connection” on the right hand side pane, you will be able to see “Last running SQL Query” 5. If you see this stored procedure name "PermanentDeleteAssets" the purge is still running and you should just let it go until it finishes. The purge process itself does run as a transaction so if it doesn't finish or Collage is restarted etc. then the purge isn't committed and just roles back to before it was started.
Rollback Segments store transactions that are in progress. They are used to back out transactions which were applied to the database due to lack of space in the database buffer cache in memory but are not committed . They are also extremely sensitive to storage space problems in instances that process large transactions
Trigger Applications on the same object. When a validate-event or pre-event is fired on an object, then that object becomes locked until the transaction has been committed to the database. If you try to spawn another Dimensions command, then you run the following risks.
You must run a BACKUP LOG statement to free up space by removing the inactive portion of the log. You must run DBCC SHRINKFILE again with the desired target size until the log file shrinks to the target size. The following example demonstrates this with the pubs database and attempts to shrink the pubs_log file to 2 MB:
An online redo log is a set of two or more online log files that record all committed changes made to the database. Whenever a transaction is committed , the corresponding redo entries temporarily stored in redo log buffers of the system global area are written to an online redo log file by the background process LGWR.
