home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC73677 Status: Geschlossen

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

Produkt:
DB2 FOR LUW / DB2FORLUW / 910 - DB2
Problembeschreibung:
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.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* AFTER LOAD CLIENT FAILURE, DB2 TABLESPACE IS IN 0X20020      * 
* STATE,BUT LOAD QUERY SHOWS TABLE IN NORMAL STATE.            * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to v91 Fixpak11                                      * 
****************************************************************
Local-Fix:
Deactivate the database or disconnect all clients from the 
database should clear the "Load in progress" state.
verfügbare FixPacks:
DB2 Version 9.1 Fix Pack 11  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12  for Linux, UNIX and Windows

Lösung
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.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
05.01.2011
07.12.2011
07.12.2011
Problem behoben ab folgender Versionen (IBM BugInfos)
9.1.
Problem behoben lt. FixList in der Version
9.1.0.11 FixList