IBM Support

IT18603: SQL1419N ERROR (REASON CODE 23) IN PURESCALE ENVIRONMENT WHEN USING THE REBUILD OPTION OF THE RESTORE COMMAND.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • In a pureScale environment, when attempting to perform a RESTORE
    operation using the REBUILD option, an SQL149N error is returned
    with reason-code 23:
    
        SQL1419N  The statement, clause, command, API, or function
    is not supported in
        a DB2 pureScale environment. Reason code = "23".
    SQLSTATE=56038
    
        Reason Code 23: A restore operation with the REBUILD option
    is not supported in
             a DB2 pureScale environment.
    
    
    The db2diag.log will also display error messages similar to
    this:
    
    
       FUNCTION: DB2 UDB, database utilities, sqludInitCheck,
    probe:681
       DATA #1 : Sqlcode, PD_TYPE_SQLCODE, 4 bytes
       -1419
       DATA #2 : Hexdump, 8 bytes
       0x00007FA8A0A9EA10 : 75FA FFFF 1700 0000 
    
       FUNCTION: DB2 UDB, database utilities, sqludInitCheck,
    probe:681
       MESSAGE : SQL1419N  The statement, clause, command, API, or
    function is not 
                 supported in a DB2 pureScale environment. Reason
    code = "".
       DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
        sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -1419  
    sqlerrml: 2
        sqlerrmc: 23
        sqlerrp : sqludIni
        sqlerrd : (1) 0x00000000      (2) 0x00000000      (3)
    0x00000000
                     (4) 0x00000000      (5) 0x00000000      (6)
    0x00000000
        sqlwarn : (1)      (2)      (3)      (4)        (5)      
    (6)    
                      (7)      (8)      (9)      (10)        (11)  
    
        sqlstate:      
    
    
    This issue is addressed in the fixpack inclusive of this APAR,
    with restrictions:
    Both the RESTORE operation using the REBUILD option, as well as
    the ensuing database ROLLFORWARD operation, must be performed on
    a member which exists within the database topology of every
    backup image involved in the operation.
    For example, supposed the restore rebuild operation utilizes two
    backup images: backup-image-A has database member topology
    {0,1}, and backup-image-B has database member topology
    {0,1,2,3}. Then both the restore operation and the ensuing
    rollforward operation must be performed on either member-0 or
    member-1 (which exist in all backup images).
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * User using rebuild restore  function in pureScale            *
    * environment.                                                 *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Fixed in Fix Pack inclusive of this APAR                     *
    ****************************************************************
    

Problem conclusion

  • This problem is first fixed in V11.1 Mod 2 Fix Pack 2.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT18603

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-12-28

  • Closed date

    2017-07-25

  • Last modified date

    2017-07-25

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

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

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
29 June 2020