PM81794: DB2 ADMIN TOOL WHEN GENERATING VIEW DDL ISSUES MSGADB1649E ADB2REM: UNEXPECTED SQLCODE IN : FETCH C_VIEW LOOP. RC=12

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Administration Tool for z/OS when GENerating VIEW DDL
  ends with RC=12 and the msgADB1649E ADB2REM:  Unexpected sqlcode
  in : Fetch c_view loop
  DSNT408I SQLCODE = -904, ERROR:  UNSUCCESSFUL EXECUTION CAUSED
  BY AN
           UNAVAILABLE RESOURCE. REASON 00C900D1, TYPE OF RESOURCE
  00000907, AND
           RESOURCE NAME
  DSNT418I SQLSTATE   = 57011 SQLSTATE RETURN CODE
  DSNT415I SQLERRP    = DSNXROHB SQL PROCEDURE DETECTING ERROR
  DSNT416I SQLERRD    = -505  13172746  0  14083011  -489291776  0
  SQL DIAGNOSTIC
           INFORMATION
  DSNT416I SQLERRD    = X'FFFFFE07'  X'00C9000A'  X'00000000'
  X'00D6E3C3'
           X'E2D60000'  X'00000000' SQL DIAGNOSTIC INFORMATION
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use the Generate (GEN) command to   *
  *                 generate views DDL on panel ADB21VV          *
  *                 'Views'.                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: When using the GEN line command to      *
  *                      generate view DDL, a RC=12 / Return     *
  *                      Code 12 and SQLCODE=-904 /              *
  *                      SQLCODEN904 is displayed:               *
  *                                                              *
  *                      msgADB1649E ADB2REM:                    *
  *                      Unexpected sqlcode                      *
  *                      in : Fetch c_view loop                  *
  *                      DSNT408I SQLCODE = -904,                *
  *                      ERROR:  UNSUCCESSFUL                    *
  *                      EXECUTION CAUSED BY AN                  *
  *                      UNAVAILABLE RESOURCE.                   *
  *                      REASON 00C900D1, TYPE                   *
  *                      OF RESOURCE 00000907,                   *
  *                      AND RESOURCE NAME                       *
  *                      DSNT418I SQLSTATE   = 57011             *
  *                      SQLSTATE RETURN CODE                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  GEN on views causes a DB2 error SQLCODE=-904 / SQLCODEN904,
  reason 00C900D1.  The total number of views that causes the
  failure is based on the user's USER LOB VALUE STG field
  (DSNZPxxx DSN6SYSP LOBVALA subsystem parameter) setting.
  

Problem conclusion

• Problem has been resolved.
  

Temporary fix

Comments

• ž**** PE14/01/08 FIX IN ERROR. SEE APAR PI09158  FOR DESCRIPTION
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UK92891 UK92892

Modules/Macros

•    ADB2REM  ADB2REP  ADB2REY
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK92891

     UP13/03/28 P F303

• RA20 PSY UK92892

     UP13/03/28 P F303

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.