PH54367: ARSLOAD FAILURE WITH SQLCODE = -302

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Under some circumstances, arsload can fail with :
  
  ARS0013E DB Error: {DB2 FOR OS/390}{ODBC DRIVER}{DSN11015}
  DSNT408I SQLCODE = -302, ERROR:  THE VALUE OF INPUT VARIABLE OR
  PARAMETER IS INVALID OR TOO LARGE FOR THE TARGET  COLUMN OR
  THE TARGET VALUE
  
  Some of those circumstances are:
  
  -- ARSLOAD is running in "direct mode" i.e. NOTCPIP mode.
  -- Multiple indexes are associated with the same document in the
  load
  

Local fix

• Run arsload in TCPIP mode.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Content Manager OnDemand for z/OS 10.5   *
  *                 customers using arsload running notcpip to   *
  *                 store documents that contain multiple        *
  *                 indexes that point to the same document      *
  ****************************************************************
  * PROBLEM DESCRIPTION: When running notcpip arsload can issue  *
  *                      a message:                              *
  *                                                              *
  *                      ARS0013E ARSTTT DB Error: {DB2 FOR      *
  *                      OS/390}{ODBC DRIVER}{DSN11015}          *
  *                      DSNT408I SQLCODE = -302, ERROR:  THE    *
  *                      VALUE OF INPUT VARIABLE OR PARAMETER    *
  *                      NUMBER 17 IS INVALID OR TOO LARGE FOR   *
  *                      THE TARGET COLUMN OR THE TARGET VALUE   *
  *                      DSNT418I SQLSTATE   = 22003 SQLSTATE    *
  *                      RETURN CODE                             *
  *                      DSNT415I SQLERRP  = DSNXRIHB SQL        *
  *                      PROCEDURE DETECTING ERROR               *
  *                      DSNT416I SQLERRD    = -385  0  0  -1  0 *
  *                      0 SQL DIAGNOSTIC INFORMATION            *
  *                      DSNT416I SQLERRD    = X'FFFFFE7F'       *
  *                      X'00000000'  X'00000000'  X'FFFFFFFF    *
  *                      X'00000000'  X'00000000' SQL DIAGNOSTIC *
  *                      INFORMATION ERRLOC=5:10:2 --            *
  *                      SQLSTATE=22003, SQLCODE=-302,           *
  *                      File=arsdoc.c, Line=5660                *
  *                                                              *
  *                      An ODBC trace shows the values for the  *
  *                      comp_off or comp_len columns exceed 2G. *
  ****************************************************************
  When arsload is creating duplicate rows, some information needs
  to be copied from one row to another.  During that process and
  when running notcpip, arsload was not resetting a variable
  causing the first row of the duplicate rows to contain invalid
  data for doc_name, doc_off, doc_len, comp_off, and comp_len.  If
  that data exceeded 2G for a length or offset, DB2 will raise the
  -302 SQLCODE. Subsequent duplicate rows for that document will
  have the correct values.
  
  Further, this defect only manifests itself if the document being
  stored would need to be stored in a new object due to the
  current object exceeding the applgrp maximum object size.  If
  the document will fit in the existing object, the error will not
  occur.
  

Problem conclusion

• arsload is changed to reset the variable, allowing the data to
  be copied.
  
  In cases where the fix is not yet applied and the error has
  already occurred in the storing of the data, if DB2 does not
  detect the error, then the first row of the duplicate rows will
  receive an error during retrieval.  This can be corrected by
  updating the failed row doc_name, doc_off, doc_len, comp_off,
  comp_len columns with the values from a subsequent duplicate
  row.
  

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:

  UI92298

Modules/Macros

• ARGL390A ARGL390C ARGLOAD
  

Fix information

• Fixed component name

  CM OD Z/OS, OD/

• Fixed component ID

  5655H3900

Applicable component levels

• RA50 PSY UI92298

     UP23/06/22 P F306

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.