Troubleshooting
Problem
Resolving a phantom quiesce and SQL0290N in DB2 in a partitioned database using table functions:
Symptom
A DB2 query or utility might fail with this error:
"SQL0290N Table space access is not allowed. SQLSTATE=55039"
db2pd -alldbpart -d sample -tablespaces| egrep -ip "Tablespace Statistics:"
Which shows:
Tablespace Statistics:
Address Id TotalPgs UsablePgs UsedPgs PndFreePgs FreePgs HWM Max HWM State MinRecTime NQuiescers PathsDropped TrackmodState
0x07000000349AA940 1 1 1 1 0 0 - - 0x00000000 0 0 No n/a
0x07000000349B9B20 2 4096 4064 1824 0 2240 1824 1824 0x00000004 0 1 No n/a
0x07000000349C6CC0 3 4096 4092 80 0 4012 80 80 0x00000000 0 0 No n/a
0x07000000DEFB0080 4 4096 4092 328 0 3764 328 328 0x00000000 0 0 No n/a
$ db2tbst 0x00000004
State = Quiesced Exclusive
"SQL0290N Table space access is not allowed. SQLSTATE=55039"
And the underlying tablepsace is in a quiesced state as evidenced by this db2pd command:
db2pd -alldbpart -d sample -tablespaces| egrep -ip "Tablespace Statistics:"
Which shows:
Tablespace Statistics:
Address Id TotalPgs UsablePgs UsedPgs PndFreePgs FreePgs HWM Max HWM State MinRecTime NQuiescers PathsDropped TrackmodState
0x07000000349AA940 1 1 1 1 0 0 - - 0x00000000 0 0 No n/a
0x07000000349B9B20 2 4096 4064 1824 0 2240 1824 1824 0x00000004 0 1 No n/a
0x07000000349C6CC0 3 4096 4092 80 0 4012 80 80 0x00000000 0 0 No n/a
0x07000000DEFB0080 4 4096 4092 328 0 3764 328 328 0x00000000 0 0 No n/a
$ db2tbst 0x00000004
State = Quiesced Exclusive
[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Performance - Lock-Latch","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.8;9.7;10.1;10.5;11.1","Edition":"Advanced Enterprise Server;Advanced Workgroup Server;Enterprise Server","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
Modified date:
30 April 2025
UID
swg21986441