PI97450: 10.1.0.3 ARSDB -I <INSTANCE_NAME> -RV FAILS 18/05/01 PTF PECHANGE

CMOD 10.1.0.3 ifix 1 for Linux
CMOD 10.1.0.3 ifix 1 for Windows
CMOD 10.1.0.3 ifix 1 for linux390
CMOD 10.1.0.3 ifix 1 for Aix

APAR status

• Closed as program error.

Error description

• 10.1.0.3 arsdb -I <instance_name> -rv fails
  
  DSNT408I SQLCODE = -104, ERROR:  ILLEGAL SYMBOL
  "<END-OF-STATEMENT>".
  SOME
           SYMBOLS THAT MIGHT BE LEGAL ARE: <IDENTIFIER>
  DSNT418I SQLSTATE   = 42601 SQLSTATE RETURN CODE
  DSNT415I SQLERRP    = DSNHPARS SQL PROCEDURE DETECTING ERROR
  DSNT416I SQLERRD    = 3  0  0  -1  206  502 SQL DIAGNOSTIC
  INFORMATION
  DSNT416I SQLERRD    = X'00000003'  X'00000000'  X'00000000'
  X'FFFFFFFF'
           X'000000CE'  X'000001F6' SQL DIAGNOSTIC INFORMATION
   ERRLOC=1:13:1 -- SQLSTATE=37000, SQLCODE=-104
  
  ARS4054E DB Error: {DB2 FOR OS/390}{ODBC DRIVER}  SQLSTATE=37000
  ERRLOC=3:90:2 -- SQLSTATE=37000, SQLCODE=-99999
  
  ARS4125I Failed while processing sql statement >CREATE UNIQUE
  INDEX
  ARSSERVR.arsapp_idx ON ARSSERVR.arsapp ( agid, aid, name )
  INCLUDE (
  description, doc_type, doc_comp_type, res_comp_type, idx_type,
  comp_obj_size, pid, upd_userid,  upd
  
  arsdb:.ARS4035E Unable to create index ARSSERVR.arsapp_idx
  

Local fix

• Run arsdb -rv at 10.1.0.2 but not at 10.1.0.3
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Content Manager OnDemand for z/OS 10.1   *
  *                 and above customers using arsdb -r.          *
  ****************************************************************
  * PROBLEM DESCRIPTION: arsdb -r fails with:                    *
  *                                                              *
  *                      ARS4125I Failed while processing sql    *
  *                      statement >CREATE UNIQUE INDEX          *
  *                      ARSSV100.arsapp_idx ON ARSSV100.arsapp  *
  *                       agid, aid, name                        *
  *                      INCLUDE  description, doc_type,         *
  *                      doc_comp_type, res_comp_type, idx_type, *
  *                      comp_obj_size, pid, upd_userid,         *
  *                      upd_date, db_exp_date,<                 *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  arsdb was trying to INCLUDE a list of columns in the index.  The
  variable used to contain the string is not big enough hold the
  entire string, causing the string to be truncated, and thereby
  creating an invalid SQL statement.
  

Problem conclusion

• The variable is made large enough to hold the entire string.
  

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:

  UI55617

Modules/Macros

•    ARGDB
  

Fix information

• Fixed component name

  CM OD Z/OS, OD/

• Fixed component ID

  5655H3900

Applicable component levels

• RA10 PSY UI55617

     UP18/05/03 I 1000 Ø

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.