Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2011
    Posts
    10

    Exclamation Unanswered: Db2 error SQL2048 N with error cose 6...Plz reply.

    HI
    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
    Detailed explanation:
    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.187146-240 E3957A494 LEVEL: Info
    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, sqluxGetDegreeParallelism, probe:509
    DATA #1 : <preformatted>
    Autonomic backup/restore - using parallelism = 4.

    2011-06-13-00.01.24.495487-240 E4452A518 LEVEL: Info
    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, sqluxGetAvailableHeapPages, probe:620
    DATA #1 : <preformatted>
    Autonomic BAR - heap consumption.
    Targetting (50%) - 4968 of 9936 pages.

    2011-06-13-00.01.24.495733-240 E4971A508 LEVEL: Info
    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, sqlubTuneBuffers, probe:871
    DATA #1 : <preformatted>
    Autonomic backup - tuning enabled.
    Using buffer size = 1217, number = 4.

    2011-06-13-00.01.24.679197-240 I5480A523 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, buffer pool services, sqlbCheckStateTransition, probe:0
    MESSAGE : ZRC=0x80020038=-2147352520=SQLB_INVALID_STATE_TRANSITION
    "Invalid state transition"
    2011-06-13-00.01.24.679465-240 I6004A525 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, buffer pool services, sqlbTestSetDatapoolState, probe:633
    MESSAGE : ZRC=0x80020038=-2147352520=SQLB_INVALID_STATE_TRANSITION
    "Invalid state transition"

    2011-06-13-00.01.24.679612-240 I6530A509 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, buffer pool services, sqlbTestSetDatapoolState, probe:633
    DATA #1 : String, 60 bytes
    poolID = 2, oldState = 0, newState = 800, currentState = 400

    2011-06-13-00.01.24.679755-240 I7040A525 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, buffer pool services, sqlbTestSetDatapoolState, probe:778
    MESSAGE : ZRC=0x80020038=-2147352520=SQLB_INVALID_STATE_TRANSITION
    "Invalid state transition"

    2011-06-13-00.01.24.679900-240 E7566A569 LEVEL: Severe
    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:1678
    DATA #1 : Sqlcode, PD_TYPE_SQLCODE, 4 bytes
    -2048
    DATA #2 : Hexdump, 12 bytes
    0x07000001C69849B8 : FFFF F800 0000 0002 0000 0006 ............

    2011-06-13-00.01.24.680158-240 E8136A930 LEVEL: Severe
    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:1678
    MESSAGE : SQL2048N An error occurred while accessing object "". Reason code:
    "".
    DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
    sqlcaid : SQLCA sqlcabc: 136 sqlcode: -2048 sqlerrml: 3
    sqlerrmc: 2 6
    sqlerrp : sqlubBui
    sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000
    (4) 0x00000000 (5) 0x00000000 (6) 0x00000000
    sqlwarn : (1) (2) (3) (4) (5) (6)
    (7) (8) (9) (10) (11)
    sqlstate:

    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
    USERSPACE1

    2011-06-13-00.01.24.839126-240 E9755A433 LEVEL: Severe
    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, sqlubcka, probe:848
    MESSAGE : Backup terminated.

  2. #2
    Join Date
    Oct 2007
    Posts
    246

  3. #3
    Join Date
    Mar 2011
    Posts
    10

    Resolved

    Hi guys,

    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.

  4. #4
    Join Date
    Mar 2011
    Posts
    10

    thanks

    Thanks mathew....that was a good link.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •