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 IC77513 Status: Geschlossen

CREATE TABLESPACE SHOULD FAIL WITH SQL1524N WHEN NEW PARTITION IS JUST
ADDED & ALL OTHER PARTITIONS ARE NOT RECOGNIZED IT YET.

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
CREATE TABLESPACE should fail with SQL1524N when new partition 
is just added and all other partitions are not recognized this 
new partition: 
The issue can be recreated as following (alter/drop 
tablesapce, in step 7 & 8, failed with SQL1524N, but create 
tablespace, in step 6, is successful): 
1. db2sampl 
2. $ cat tbspace_crt_dpf.clp 
create regular tablespace testts1 managed by database using 
(FILE '/data2/shenh/pmr85282/ts1 $N' 300000) EXTENTSIZE 16 
PREFETCHSIZE 16; 
db2 -tvf tbspace_crt_dpf.clp 
3. db2 "CREATE DATABASE PARTITION GROUP sxh_group1 ON 
DBPARTITIONNUM (0,1)" 
4. $ cat tbspace_crt_dpf.clp1 
create regular tablespace testts4 in DATABASE PARTITION GROUP 
sxh_group1 managed by database using (FILE 
'/data2/shenh/pmr85282/ts4 $N' 300000) EXTENTSIZE 16 
PREFETCHSIZE 16; 
db2 -tvf tbspace_crt_dpf.clp1 
5. db2 "START DBM DBPARTITIONNUM 2 ADD DBPARTITIONNUM HOSTNAME 
db2debug port 2" 
6. $ cat tbspace_crt_dpf.clp2 
create regular tablespace testts7 in DATABASE PARTITION GROUP 
sxh_group1 managed by database using (FILE 
'/data2/shenh/pmr85282/ts7 $N' 300000) EXTENTSIZE 16 
PREFETCHSIZE 16; 
db2 -tvf tbspace_crt_dpf.clp2 
7. db2 "ALTER TABLESPACE testts4 (or testtst1,testtst7) 
AUTORESIZE YES INCREASESIZE 5 Percent MAXSIZE NONE" 
DB21034E  The command was processed as an SQL statement because 
it was not a 
valid Command Line Processor command.  During SQL processing it 
returned: 
SQL1524N  The request cannot occur until all applications in the 
instance are 
aware of the new database partition server.  SQLSTATE=55077 
8. $ db2 drop tablespace testtst4 
DB21034E  The command was processed as an SQL statement because 
it was not a 
valid Command Line Processor command.  During SQL processing it 
returned: 
SQL1524N  The request cannot occur until all applications in the 
instance are 
aware of the new database partition server.  SQLSTATE=55077
Problem-Zusammenfassung:
Users Effected: 
All users 
 
Problem Description: 
CREATE TABLESPACE SHOULD FAIL WITH SQL1524N WHEN NEW PARTITION 
IS JUST ADDED & ALL OTHER PARTITIONS ARE NOT RECOGNIZED IT YET. 
 
Problem Summary: 
CREATE TABLESPACE should fail with SQL1524N when new partition 
 
is just added and all other partitions are not recognized this 
new partition: 
The issue can be recreated as following (alter/drop 
tablesapce, in step 7 & 8, failed with SQL1524N, but create 
tablespace, in step 6, is successful): 
1. db2sampl 
2. $ cat tbspace_crt_dpf.clp 
create regular tablespace testts1 managed by database using 
(FILE '/data2/shenh/pmr85282/ts1 $N' 300000) EXTENTSIZE 16 
PREFETCHSIZE 16; 
db2 -tvf tbspace_crt_dpf.clp 
3. db2 "CREATE DATABASE PARTITION GROUP sxh_group1 ON 
DBPARTITIONNUM (0,1)" 
4. $ cat tbspace_crt_dpf.clp1 
create regular tablespace testts4 in DATABASE PARTITION GROUP 
sxh_group1 managed by database using (FILE 
'/data2/shenh/pmr85282/ts4 $N' 300000) EXTENTSIZE 16 
PREFETCHSIZE 16; 
db2 -tvf tbspace_crt_dpf.clp1 
5. db2 "START DBM DBPARTITIONNUM 2 ADD DBPARTITIONNUM HOSTNAME 
db2debug port 2" 
6. $ cat tbspace_crt_dpf.clp2 
create regular tablespace testts7 in DATABASE PARTITION GROUP 
sxh_group1 managed by database using (FILE 
'/data2/shenh/pmr85282/ts7 $N' 300000) EXTENTSIZE 16 
PREFETCHSIZE 16; 
db2 -tvf tbspace_crt_dpf.clp2 
7. db2 "ALTER TABLESPACE testts4 (or testtst1,testtst7) 
AUTORESIZE YES INCREASESIZE 5 Percent MAXSIZE NONE" 
DB21034E  The command was processed as an SQL statement because 
it was not a 
valid Command Line Processor command.  During SQL processing it 
returned: 
SQL1524N  The request cannot occur until all applications in the 
instance are 
aware of the new database partition server.  SQLSTATE=55077 
8. $ db2 drop tablespace testtst4 
DB21034E  The command was processed as an SQL statement because 
it was not a 
valid Command Line Processor command.  During SQL processing it 
returned: 
SQL1524N  The request cannot occur until all applications in the 
instance are 
aware of the new database partition server.  SQLSTATE=55077
Local-Fix:
verfügbare FixPacks:
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
defect  wsdbu00873881 
CSD     First fixed in DB2 UDB Version 9.7, FixPak 5 
module  engn_sqnq
Workaround
Upgrade to DB2 Version Version 9.7, FixPak 5
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
13.07.2011
07.12.2011
07.12.2011
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.
Problem behoben lt. FixList in der Version
9.7.0.5 FixList