INCORROUT modifier keyword

Use this modifier keyword if the type-of-failure keyword is INCORROUT.

Procedure

  1. Determine the primary and secondary modifier keywords for the problem.
  2. If the primary modifier keyword is not SQL, add that keyword and the secondary modifier keyword to the string. Refer to Searching the IBM Support site for known problems and solutions.
      (free format):
      5740XYR00 R111 INCORROUT UTILITY
       MERGECOPY
      (structured format):
      PIDS/5740XYR00 LVLS/111 INCORROUT
  3. If the primary modifier keyword is SQL, determine whether you have access to the SQLCA (structured query language communication area).

    This area is available if the application program displays the SQLCA or if a dump was issued for this specific problem. Refer to Finding the SQLCA for examples.

    The SQL communication area (SQLCA) describes how to locate the SQLCA in a dump.

  4. If you have access to the SQLCA, add the primary and secondary modifier keywords to the string. Next, go to SQLCODE modifier keyword.
      (free format):
      5740XYR00 R111 INCORROUT SQL INSERT
      (structured format):
      PIDS/5740XYR00 LVLS/111 PCSS/SQL
       PCSS/INSERT INCORROUT
  5. If you do not have access to the SQLCA, add the primary and secondary modifier keywords to the string. Next, turn to Searching the IBM Support site for known problems and solutions.

What to do next

Table 1. INCORROUT modifier keywords
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:
  1. Collect log records for the pertinent transaction.
  2. 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.

  3. If you suspect a Db2 error, then contact the IBM Support Center and report the symptoms and supply the pertinent log records.