Unanswered: Db2 error SQL2048 N with error cose 6...Plz reply.
I am pretty new to db2. I have an error when i was perfoming the backup.
It returned sql2048n rc 6.
I checked the tbsp and one of them is in reorg in progress state. How to come out of this. For reference the log and tablespace details are below.
Anticipating an early reply. Thank you.
Tablespace ID = 2
Name = USERSPACE1
Type = Database managed space
Contents = All permanent data. Large table space.
State = 0x0400
Reorganization in progress
Total pages = 125000
Useable pages = 124960
Used pages = 26880
Free pages = 98080
High water mark (pages) = 26880
Page size (bytes) = 8192
Extent size (pages) = 32
Prefetch size (pages) = 32
Number of containers = 1
Minimum recovery time = 2011-04-07-19.30.46.000000
2011-06-13-00.01.24.680422-240 E9067A687 LEVEL: Error
PID : 2068718 TID : 85584 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : ENBPE2XA
APPHDL : 0-27294 APPID: *LOCAL.db2inst1.110613040125
AUTHID : DB2INST1
EDUID : 85584 EDUNAME: db2agent (ENBPE2XA) 0
FUNCTION: DB2 UDB, database utilities, sqlubBuildAppTbsp, probe:1680
MESSAGE : SQL2048N An error occurred while accessing object "". Reason code:
DATA #1 : String, 114 bytes
The BACKUP_IN_PROGRESS state cannot be turned on.
It is not compatible with the current state of the table space.
DATA #2 : String, 10 bytes
Thank for whoever tried or thought of helping me. This is for beginners like me. Plz dont mind .
The problem is resolved and here is how i figured out.
I took a snapshot of all the applications, Checked for the application which is performing the reorg and found its holding 5 locks and is in lock wait state. I forced this and tablespace came back to normal.
I am working on this even deep so that this doesnt happen again and will post for any further solutions.