IBM Support

PH01064: ROLL-UP MULTIPLATFORM FIXPACK 10.1.0.4

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as new function.

Error description

  • Development APAR
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All Content Manager OnDemand for z/OS 10.1   *
    *                 customers                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION: 1. Rollup Multiplatform 10.1.0.4        *
    *                      fixpack.                                *
    *                                                              *
    *                      2.Message ARS0013E ARSTTT DB Error:     *
    *                      {DB2 FOR OS/390}{ODBC DRIVER}{DSN11015} *
    *                      DSNT408I SQLCODE = -104, ERROR:         *
    *                      ILLEGAL SYMBOL ";".                     *
    *                      SOME SYMBOLS THAT MIGHT BE LEGAL        *
    *                      ARE: AT MICROSECONDS MICROSECOND        *
    *                      SECONDS SECOND MINUTES MINUTE HOURS     *
    *                      DSNT418I SQLSTATE   = 42601 SQLSTATE    *
    *                      RETURN CODE DSNT415I SQLERRP =          *
    *                      DSNHPARS SQL PROCEDURE DETECTING ERROR  *
    *                      DSNT416I SQLERRD = 3  0  0  -1  71  502 *
    *                      SQL DIAGNOSTIC INFORMATION DSNT416I     *
    *                      SQLERRD    = X'00000003'  X'00000000'   *
    *                      X'00000000'  X'FFFFFFFF' X'00000047'    *
    *                      X'000001F6' SQL DIAGNOSTIC INFORMATION  *
    *                      ERRLOC=5:10:1 -- SQLSTATE=37000,        *
    *                      SQLCODE=-104, File=arsdoc.c, Line=3079  *
    *                      can occur when using                    *
    *                      arsuperm for action 4  - SQL query      *
    *                      string - in 31-bit mode.                *
    *                                                              *
    *                      3. Message ARS1109E Unable to allocate  *
    *                      enough memory.                          *
    *                      File=SYS18109.T101342.RA000.ARGL390C.SR *
    *                      Line=671 occurs when using the 390      *
    *                      indexer for a large-object load with    *
    *                      greater than 10,000 pages.              *
    *                                                              *
    *                                                              *
    *                      4. Message ARS0013E ARSSOCKD DB Error:  *
    *                      {DB2 FOR OS/390}{ODBC DRIVER}{DSN11015} *
    *                      DSNT408I SQLCODE = -302, ERROR:  THE    *
    *                      VALUE OF INPUT                          *
    *                      VARIABLE OR PARAMETER NUMBER 13 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=5026 is received    *
    *                      when retrieving a V2 large object.      *
    *                      Note that the retrieve is successful,   *
    *                      but the logging of the retrieve is what *
    *                      fails.                                  *
    *                                                              *
    *                      5.  When using the 390 indexer with     *
    *                      INDEXSTYLE=AFP, excessive CPU           *
    *                      consumption may be noticed.             *
    *                                                              *
    *                      6. When using the 390 indexer with      *
    *                      INDEXSTYLE=AFP and the INDEXnnn         *
    *                      statements do not specify sequentially  *
    *                      increasing nnn can receive              *
    *                      ARS5432I Match not found for value in   *
    *                      TLE record, record number 281. Input    *
    *                      DDNAME //DD:SYS00004                    *
    *                      ARS1129E Row 1:  The string "07022017"  *
    *                      could not be converted to a date from   *
    *                      the format of %m/%d/%y                  *
    *                                                              *
    *                      7.arsdb -u without an                   *
    *                      ARS_ORIGINAL_CODEPAGE in the ars.cfg    *
    *                      issues ARS4012E with                    *
    *                      ARS_ORIGINAL_CODEPAGE=0 like            *
    *                      ARS4012E Unable to initialize           *
    *                      environment. The return code is -1.  If *
    *                      this is a new (created in version 8.5   *
    *                      or later) instance, then define         *
    *                      ARS_ORIGINAL_CODEPAGE=0 in ars.cfg.     *
    *                      Otherwise, if this is an existing       *
    *                      instance (created prior to 8.5), then   *
    *                      define ARS_ORIGINAL_CODEPAGE=1047 in    *
    *                      ars.cfg.  Once set,                     *
    *                      ARS_ORIGINAL_CODEPAGE must never        *
    *                      change.                                 *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    1. Rollup Multiplatform 10.1.0.4 fixpack.
    
    2. When using the 31-bit arsuperm, for action 4 and if the exit
    returns updated sql, ARSZ31OS was updating the wrong pointer
    causing corruption of the SQL.
    
    3. ARGL390C was using the wrong variable tor a realloc.
    
    4. V2 LO processing may result in a comp_off > 2G.  ARNDOC did
    not allow for that possibility, resulting in a too big value
    being passed to ODBC.
    
    5. ARGL390A was excessively zeroing storage.
    
    6. ARGL390A was not properly dealing with 'missing' INDEXnnn
    statements.
    
    7. ARGDB was formatting the text for ARS4012E before getting the
    actual codepage resulting in a '0' for the codepage.
    

Problem conclusion

Temporary fix

Comments

  • 1. Rollup Multiplatform 10.1.0.4 fixpack.
    A list of the MP APARs incorporated in the 10.1.0.4 rollup can
    be found in the OnDemand MP 10104 FP Readme at
    http://www.ibm.com/support/docview.wss?uid=ibm10732483
    
    2. ARSZ31OS is changed to update the correct pointer
    
    3. ARGL390C is changed to use the correct variable for a
    realloc.
    
    4. ARGDOC is changed to allow for V2 LO processing returning a
    value > 2G.
    
    5. ARGL390A is change to not excessively zero storage.
    
    6. ARGL390A is changed to properly deal with 'missing' INDEXnnn
    statements.
    
    7. ARGDB is changed to get the database codepage before
    formatting the ARS4012E.
    

APAR Information

  • APAR number

    PH01064

  • Reported component name

    CM OD Z/OS, OD/

  • Reported component ID

    5655H3900

  • Reported release

    A10

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-07-30

  • Closed date

    2018-10-09

  • Last modified date

    2018-11-01

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

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

    UI59016

Modules/Macros

  •    ARGADMIN ARGAFPD  ARGAFPMN ARGAG    ARGAGF
    ARGAGI   ARGAGP   ARGANN   ARGAPL   ARGAPP   ARGAPPLG ARGCAB
    ARGCABIN ARGCMLDV ARGCMNFN ARGCP    ARGCS    ARGCSSM  ARGCSVDC
    ARGCSVLG ARGCSX   ARGDATA  ARGDB    ARGDBDEF ARGDBMN  ARGDBMS
    ARGDBSTB ARGDBUTL ARGDB2   ARGDCFTN ARGDOC   ARGDOCX  ARGEXC
    ARGEXP   ARGEXPRT ARGFLD   ARGFLDAC ARGFLDAS ARGFLDDS ARGFLDDT
    ARGFLDEX ARGFLDF  ARGFLDFI ARGFLDFM ARGFLDFO ARGFLDFZ ARGFLDII
    ARGFLDIN ARGFLDIX ARGFLDLI ARGFLDLS ARGFLDMF ARGFLDOD ARGFLDP
    ARGFLDPR ARGFLDS  ARGFLDSS ARGFLDTC ARGFLDTL ARGFLDTP ARGFLDUC
    ARGFOL   ARGFUDPS ARGGROUP ARGHLD   ARGHOLD  ARGHP    ARGID
    ARSODFTM ARSODVJ2 ARSOLGJA ARSPRDSC ARSPRDSJ ARSRSARA ARSRSCHS
    ARSRSCHT ARSRSCZE ARSRSDAN ARSRSDEU ARSRSELL ARSRSENU ARSRSESP
    ARSRSFIN ARSRSFRA ARSRSHEB ARSRSHRV ARSRSHUN ARSRSITA ARSRSJPN
    ARSRSKOR ARSRSNLD ARSRSNOR ARSRSPLK ARSRSPTB ARSRSRUS ARSRSSKY
    ARSRSSLO ARSRSSVE ARSXSD01 ARSXSE01 ARSZMJAR ARSZ31OS
    

Fix information

  • Fixed component name

    CM OD Z/OS, OD/

  • Fixed component ID

    5655H3900

Applicable component levels

  • RA10 PSY UI59016

       UP18/10/12 P F810

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.

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSQHWE","label":"Content Manager OnDemand for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"A10","Edition":"","Line of Business":{"code":"LOB36","label":"IBM Automation"}}]

Document Information

Modified date:
01 November 2018