PK93044: SQLCODE904 WRONGLY ISSUED WITH RC00C90090

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• During UPDATE processing, SQLcode904 with REASON 00C90090
  is received. The resource type was zero and resource name was
  empty.
  
  DSNT408I SQLCODE = -904, ERROR:  UNSUCCESSFUL EXECUTION CAUSED
  BY AN UNAVAILABLE RESOURCE. REASON 00C90090, TYPE OF RESOURCE
  00000000, AND RESOURCE NAME
  DSNT418I SQLSTATE   = 57011 SQLSTATE RETURN CODE
  DSNT415I SQLERRP    = DSNXRRC SQL PROCEDURE DETECTING ERROR
  DSNT416I SQLERRD    = 102  13172746  0  13226962  -991424510
  1073741826 SQL DIAGNOSTIC INFORMATION
  DSNT416I SQLERRD    = X'00000066'  X'00C9000A'  X'00000000'
  X'00C9D3D2'
  
  Development has found that this was caused by residual return
  code that is causing the 00C90090 failures when there is no
  need.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: DB2 for z/OS users with ZPARM SKIPUNCI=YES   *
  *                 or using SKIP LOCKED DATA clause and running *
  *                 SQL operations on partitioned table spaces.  *
  *                 It may be possible for this problem to be    *
  *                 seen for other operations that attempt to    *
  *                 make use of conditional locking.             *
  ****************************************************************
  * PROBLEM DESCRIPTION: Customers were seeing numerous -904     *
  *                      SQLCODE904 application failures with    *
  *                      reason code RC00C90090 00C90090 during  *
  *                      periods of heavy SQL scan and update    *
  *                      activities. The MSGDSNT408I error       *
  *                      message would indicate a blank resource *
  *                      name and type of resource was zeroes.   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  For skip uncommitted insert with SKIPUNCI=YES (ZPARM SPRMSKUI)
  or when the SKIP LOCKED DATA clause is specified, SQL operations
  will first attempt to obtain a conditional lock. If the request
  for a conditional lock on the partition fails, DB2 code will set
  RC00C90090 flags and then attempt to lock unconditionally. After
  obtaining the lock, the update operation succeeds but the
  residual 00C90090 settings subsequently result in applications
  getting DSNT408I -904 resource unavailable failures.
  

Problem conclusion

• DB2 code has been corrected to initialize reason code and return
  code fields before performing the unconditional lock operation.
  

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:

  UK49987 UK49988

Modules/Macros

• DSNIADR  DSNIGLOK DSNIONX2 DSNIOST2 DSNIRNXT
  DSNIRPRE DSNISFRL DSNISFS  DSNISFX2 DSNISRID
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• R810 PSY UK49987

     UP09/09/29 P F909

• R910 PSY UK49988

     UP09/09/29 P F909

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.