PH29438: BIND OF RD GENERATED DBRM DSNX200I SQLCODE -104 TRANSFER GET SQLSAVEPOINT HOLD FREE CALL

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The RD ('Regenerate DBRM') command on panel ADB21K may generate
  an EBCDIC, and not UNICODE DBRM.   As a result the subsequent
  bind of the DBRM may result in an SQLCODE -104 error:
  
  DSNX200I BIND SQL ERROR
  USING >owner< AUTHORITY
  PLAN=(NOT APPLICABLE)
  DBRM=>dbrm-name<
  STATEMENT=>statement-number<
  SQLCODE=-104
  SQLSTATE=42601
  TOKENS= <ERR_STMT
  <WNG_STMT
  TRANSFER GET SQL SAVEPOINT HOLD FREE CALL
  CSECT NAME=DSNHLEX
  RDS CODE=17
  
  
  Keyword:  SQLCODEN104
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool for     *
  *                 z/OS 'RD' option to regenerate               *
  *                 DBRMs.                                       *
  ****************************************************************
  * PROBLEM DESCRIPTION: DBRMs regenerated from packages         *
  *                      created after DB2 V8 may not            *
  *                      be in the correct format, resulting     *
  *                      in a SQLCODE=-104 error during the      *
  *                      bind process.                           *
  ****************************************************************
  Executing line command 'RD' on panel ADB21K
  to regenerate a DBRM may result in the DBRM
  being recreated in an ebcdic format instead
  of unicode (all packages newer than Db2 V8
  should be in unicode format). When binding
  the incorrectly formatted DBRM, the
  following error may result:
  
  DSNX200I BIND SQL ERROR
  USING >owner< AUTHORITY
  PLAN=(NOT APPLICABLE)
  DBRM=>dbrm-name<
  STATEMENT=>statement-number<
  SQLCODE=-104
  SQLSTATE=42601
  TOKENS= <ERR_STMT
  <WNG_STMT
  TRANSFER GET SQL SAVEPOINT HOLD FREE CALL
  CSECT NAME=DSNHLEX
  RDS CODE=17
  

Problem conclusion

• Problem has been resolved.
  

Temporary fix

Comments

APAR Information

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

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

  UI72551 010PC2Ÿ 010PC2Ÿ

Modules/Macros

• ADBGENA
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI72551

     UP20/11/14 P F011

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.