IBM Support

IC79471: AFTER LOAD CLIENT FAILURE, DB2 TABLESPACE IS IN 0X20020 STATE, BUT LOAD QUERY SHOWS TABLE IN NORMAL STATE.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • This APAR is a complement of APAR JR35724.
    APAR JR35724 fixed the problem only when client and server
    systems are of the same endian, i.e. both are big-endian
    platforms or both are little-endian platforms. This APAR fixes
    the problem in all cases.
    Big-endian platforms are AIX, HP on IA64, Solaris SPARC, Linux
    on zSeries, Linux on pSeries.
    Little-endian platforms are Solaris x64, Linux on IA-64, Linux
    on AMD64 and Intel EM64T, 32-bit Linux on x86, Windows.
    
    If the input file is incorrect while loading a table with LOAD
    CLIENT, load encounters error, and the tablespace is left in
    "Load in progress" state.  For example:
    
    1:----
    
    
    LOAD CLIENT FROM C:\a.del OF DEL MODIFIED BY COLDEL0x09
    USEDEFAULTS METHOD P (1, 2, 3) replace INTO AYSEL.TABLO1 (A,
    B,C) COPY NO INDEXING MODE AUTOSELECT
    
    SQL3039W  The memory available to LOAD for DATA BUFFER prohibits
    full
    LOAD parallelism.  Load parallelism of "4" will be used
    
    SQL3109N  The utility is beginning to load data from file
    "C:\a.del".
    
    SQL2036N  The path for the file or device "C:\a.del" is not
    valid.
    
    SQL3107W  There is at least one warning message in the message
    file.
    
    Number of rows read        = 0
    Number of rows skipped      = 0
    Number of rows loaded      = 0
    Number of rows rejected    = 0
    Number of rows deleted      = 0
    Number of rows committed    = 0
    
    
    2:----
    
    
    LOAD query table AYSEL.TABLO1
    
    SQL3039W  The memory available to LOAD for DATA BUFFER prohibits
    
    full LOAD parallelism.  Load parallelism of "4" will be used
    
    SQL3109N  The utility is beginning to load data from file
    "C:\a.del".
    
    SQL2036N  The path for the file or device "C:\a.del" is not
    valid.
    
    SQL3532I  The Load utility is currently in the "UNKNOWN" phase.
    
    Tablestate:
    Load in Progress
    
    
    3:----
    
    Customer terminates LOAD:
    
    LOAD CLIENT FROM C:\a.del OF DEL MODIFIED BY COLDEL0x09
    USEDEFAULTS METHOD P (1, 2, 3)  terminate INTO AYSEL.TABLO1
    
    SQL3110N  The utility has completed processing.  "0" rows were
    read from the input file.
    
    Number of rows read        = 0
    Number of rows skipped      = 0
    Number of rows loaded      = 0
    Number of rows rejected    = 0
    Number of rows deleted      = 0
    Number of rows committed    = 0
    
    
    4:----
    
    Customer checks the table state:
    
    LOAD query table AYSEL.TABLO1
    
    Tablestate:
    Normal
    
    
    5:----
    
    Customer checks the tablespace
    
    
    Name    = AYSELTS01
    Type    = System managed space
    Contents = All permanent data. Regular table space.
    State    = 0x20020
              Detailed explanation:
              Backup pending
              Load in progress
    
    
    Although no load job are running and table is in normal state,
    the tablespace is left in "Load in progress" state. As a result
    customer cannot take any backup.  Drop/Create Tablespace or
    db2stop/db2start solves the issue.  Deactivate the database or
    disconnect all clients from the database should also clear the
    "Load in progress" state.
    

Local fix

  • Deactivate the database or disconnect all clients from the
    database should clear the "Load in progress" state.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All users of version 9.7 on Linux, Unix and Windows          *
    * platforms.                                                   *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 UDB Version 9.7 Fix Pak 6 or higher levels.   *
    ****************************************************************
    

Problem conclusion

  • First fixed in DB2 LUW Version 9.7 Fix Pak 6.
    

Temporary fix

  • Deactivate the database or disconnect all clients from the
    database should clear the "Load in progress" state.
    

Comments

APAR Information

  • APAR number

    IC79471

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-10-26

  • Closed date

    2012-06-11

  • Last modified date

    2012-06-11

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

    IC78755

  • 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

  • R970 PSN

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
11 June 2012