INCORROUT modifier keyword
Use this modifier keyword if the type-of-failure keyword is INCORROUT.
Procedure
What to do next
| Primary keyword | Secondary keywords | Problem occurrence |
|---|---|---|
| CLIST | While you use a CLIST | |
| INSTALL | While you use DSNTINST installation CLIST | |
| PREP | While you use DSNH program preparation CLIST | |
| UTILITIES | While you use DSNU utilities CLIST | |
| DB2I | During DB2I processing | |
| BIND | After you run BIND panel request | |
| DB2 COMMAND | After you run the DB2 COMMANDS panel request | |
| DCLGEN | After you run DCLGEN panel request | |
| FREE | After you run FREE panel request | |
| PREP | After you run Db2 PROGRAM PREPARATION panel request | |
| REBIND | After you run REBIND panel request | |
| SPUFI | After you run SPUFI panel request | |
| UTILITY | After you run UTILITY panel request | |
| IMSATTACH | With IMS attachment facility | |
| APPLICATION | While an IMS application was processing an SQL statement | |
| DB2 COMMAND | While you process a Db2 command by using the IMS attachment facility | |
| DISC | During IMS attachment facility disconnect connect processing | |
| IRLM | In IRLM | |
| REQLOCK | Error in lock processing | |
| REQPURGE | Error in PURGE processing | |
| MIGRATION/ FALLBACK | During migration to next release or fallback to previous release | |
| LOAD | During load phase of migration | |
| REMIGRATE | During migration after a fallback | |
| RESTORE | During restore phase of fallback | |
| UNLOAD | During unload phase of migration | |
| PRECOMPILER | During precompile | |
| ASM | During assembler processing | |
| C | During C processing | |
| COBOL | During COBOL processing | |
| FORTRAN | During FORTRAN processing | |
| PLI | During PL/I processing | |
| REXX | During REXX processing | |
| RECOVERY | During recovery, but not associated with the RECOVER utility | |
| BACKOUT | At backout time | |
| CHECKPOINT | At checkpoint time | |
| COMMIT | At commit time | |
| LOGGING | During logging | |
| RECOVER | During attempt to recover indoubt threads | |
| RESTART | During restart processor | |
| RRS ATTACH | With Resource Recovery Services attachment facility (RRSAF) | |
| APPLICATION | While an application in the RRS environment was processing an SQL statement | |
| DB2 COMMAND | While you process a Db2 command by using RRSAF | |
| DISC | During RRSAF TERMINATE IDENTIFY processing | |
| SERVICEAID | While you run a service aid utility | |
| DSN1COPY | While you run DSN1COPY | |
| DSN1LOGP | While you run DSN1LOGP | |
| DSN1PRNT | While you run DSN1PRNT | |
| DSN1SDMP | While you run DSN1SDMP | |
| SQL | After you issue an SQL statement | |
| ALLOCATE CURSOR | After you issue an ALLOCATE CURSOR statement | |
| ALTER | After you issue an ALTER statement | |
| ASSOCIATE LOCATORS | After you issue an ASSOCIATE LOCATORS statement | |
| CALL | After you issue a CALL statement | |
| CLOSE | After you issue a CLOSE statement | |
| COMMENT | After you issue a COMMENT statement | |
| COMMIT | After you issue a COMMIT statement | |
| CONNECT | After you issue a CONNECT statement | |
| CREATE | After you issue a CREATE statement | |
| DECLARE | After you issue a DECLARE statement | |
| DELETE | After you issue a DELETE statement | |
| DESCRIBE | After you issue a DESCRIBE statement | |
| DROP | After you issue a DROP statement | |
| EXECUTE | After you issue an EXECUTE statement | |
| EXPLAIN | After you issue an EXPLAIN statement | |
| FETCH | After you issue a FETCH statement | |
| FREE | After you issue a FREE statement | |
| GRANT | After you issue a GRANT statement | |
| HOLD | After you issue a HOLD statement | |
| SQL continued | INCLUDE | After you issue an INCLUDE statement |
| INSERT | After you issue an INSERT statement | |
| LOCK | After you issue a LOCK statement | |
| OPEN | After you issue an OPEN statement | |
| PREPARE | After you issue a PREPARE statement | |
| RELEASE | After you issue a RELEASE statement | |
| RELEASE SAVEPOINT | After you issue a RELEASE SAVEPOINT statement | |
| RENAME | After you issue a RENAME statement | |
| REVOKE | After you issue a REVOKE statement | |
| ROLLBACK | After you issue a ROLLBACK statement | |
| ROLLBACK TO SAVEPOINT | After you issue a ROLLBACK TO SAVEPOINT statement | |
| SAVEPOINT | After you issue a SAVEPOINT statement | |
| SELECT | After you issue a SELECT statement | |
| SELECT INTO | After you issue a SELECT INTO statement | |
| SET CONNECTION | After you issue a SET CONNECTION statement | |
| SET CURRENT APPLICATION ENCODING SCHEME | After you issue a SET CURRENT APPLICATION ENCODING SCHEME statement | |
| SET CURRENT DEGREE | After you issue a SET CURRENT DEGREE statement | |
| SET CURRENT LOCALE LC_CTYPE | After you issue a SET CURRENT LOCALE LC_CTYPE statement | |
| SET CURRENT MAINTAINED TABLE TYPES FOR OPTIMIZATION | After you issue a SET CURRENT MAINTAINED TABLE TYPES FOR OPTIMIZATION statement | |
| SET CURRENT OPTIMIZATION HINT | After you issue a SET CURRENT OPTIMIZATION HINT statement | |
| SQL continued | SET CURRENT PACKAGE PATH | After you issue a SET CURRENT PACKAGE PATH statement |
| SET CURRENT PACKAGESET | After you issue a SET CURRENT PACKAGESET statement | |
| SET CURRENT PRECISION | After you issue a SET CURRENT PRECISION statement | |
| SET CURRENT REFRESH AGE | After you issue a SET CURRENT REFRESH AGE statement | |
| SET CURRENT RULES | After you issue a SET CURRENT RULES statement | |
| SET CURRENT SQLID | After you issue a SET CURRENT SQLID statement | |
| SET host variable | After you issue a SET host variable statement | |
| SET transition variable | After you issue a SET transition variable statement | |
| UPDATE | After you issue an UPDATE statement | |
| VALUES | After you issue a VALUES statement | |
| VALUES INTO | After you issue a VALUES INTO statement | |
| WHENEVER | After you issue a WHENEVER statement | |
| STAND-ALONE | While you use one of the Db2 stand-alone utilities | |
| CHANGE LOG | While you use the Change Log Inventory Utility | |
| LOG READ | While you use the Log Read utility | |
| PRINT LOGMAP | While you use the Print Log Map utility | |
| TSOATTACH | With TSO/Batch attachment facility | |
| BIND | During BIND subcommand processing | |
| DB2 COMMAND | During Db2 command processing | |
| DCLGEN | During DCLGEN subcommand processing | |
| FREE | During FREE subcommand processing | |
| REBIND | During REBIND subcommand processing | |
| RUN | While you run an application program | |
| SPUFI | While you invoke SPUFI as a panel request | |
| TSOCOMMAND | During TSO command processing | |
| UTILITY | While a utility was processing | |
| BACKUP | While you run BACKUP SYSTEM utility | |
| CHECK | While you run CHECK utility | |
| COPY | While you run COPY utility | |
| COPYTOCOPY | While you run COPYTOCOPY utility | |
| DIAGNOSE | While you run DIAGNOSE utility | |
| INDEXBUILD | While you run REORG or LOAD (BUILD phase) | |
| LOAD | While you run LOAD utility | |
| MERGECOPY | While you run MERGECOPY utility | |
| MODIFY | While you run MODIFY utility | |
| REBUILD | While you run REBUILD INDEX utility | |
| RECOVER | While you run RECOVER utility | |
| RELOAD | While you run REORG utility (RELOAD phase) | |
| REORG | While you run REORG utility | |
| REPAIR | While you run REPAIR utility | |
| REPORT | While you run REPORT utility | |
| RESTORE | While you run RESTORE SYSTEM utility | |
| RUNSTATS | While you run RUNSTATS utility | |
| QUIESCE | While you run QUIESCE utility | |
| STOSPACE | While you run STOSPACE utility | |
| UNLOAD | While you run REORG (UNLOAD phase) or UNLOAD utility |
If Db2 rolls back
to the wrong savepoint: or if you encounter problems when you roll
back to a savepoint:
- Collect log records for the pertinent transaction.
- Verify that the savepoint you intended was not accidentally replaced
by another savepoint of the same name. (Savepoint log records have
a record type of X'2200' and subtype X'0014'.)
If Db2 rolls back to the wrong savepoint, the data is probably incorrect. In that case, you must recover to a prior point in time.
- If you suspect a Db2 error, then contact the IBM Support Center and report the symptoms and supply the pertinent log records.