![]() ![]() Then we need to change the UNIT parameter. UTILITY BATCH MEMORY EXECUTION ABENDED, REASON=X'0B37'Ĭheck the spool for which dataset it is abending with SB37. Thus we can check the operation last performed.Ĭommon errors encountered while loading a table If we check the output, check for UTILITY values SELECT DSNAME SPACE, ICTYPE AS UTILITY, TIMESTAMP So, i Can query the SYSIBM.SYSCOPY Table like below If we run a query against this table, the ULITY values can help us in determining the desired operation.Įxample: I want to check what last operation was performed by my id or any id. Yes,We can know this from SYSIBM.SYSCOPY Table. Is There any way to check which operation has put the table on pending status? To remove the Copypending condition we need to execute the following commands on tablespace for all the affected table space. If NOCOPYPEND parameter is not specified in syspunch dataset If load is performed without taking an image copy To remove the Checkpending condition we need to execute the following commands on tablespaceĪny table space will be in copy pending status after load is performed on the DB2 table, None of this is directly related to the design of the application.If CHECK PENDING is set you can run the CHECK utility to instruct DB2 to verify that the data is consistent and switch off the pending status. Recovering and RI tablespace to a previous point in time can also set it. Usually happens as a result of running LOAD on a tablespace containing a table that has Referential Integrity constraints, but that was not enforced during the LOAD OPERATION (ENFORCE NO). When DB2 has reason to believe that an object might be in an inconsistent state. NOTE:We Get the table structure in the dataset with DD name SYSPUNCH while we unload the data in previous stepĬheck pending is a tablespace/index status set
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |