Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2006
    Posts
    3

    Unanswered: problem in accessing the tablespace

    I am not able to reset the table space which is quiesce exclusive mode. I have tried all the possible. Db is hosted on windows NT and the version is 7.1

    This is the current log.

    2006-03-16-17.45.35.859000 InstanceB2 Node:000
    PID:1052(db2syscs.exe) TID:1360 Appid:AC132350.3906.060316114244
    buffer_pool_services sqlbCheckStateTransition Probe:0 Database:VMS
    DIA9999E An internal error occurred. Report the following error code :
    "0xFFFF8138".

    2006-03-16-17.45.36.031000 InstanceB2 Node:000
    PID:1052(db2syscs.exe) TID:1360 Appid:AC132350.3906.060316114244
    buffer_pool_services sqlbTestSetDatapoolState Probe:633 Database:VMS
    DIA9999E An internal error occurred. Report the following error code :
    "0xFFFF8138".

    2006-03-16-17.45.36.031001 InstanceB2 Node:000
    PID:1052(db2syscs.exe) TID:1360 Appid:AC132350.3906.060316114244
    buffer_pool_services sqlbTestSetDatapoolState Probe:633 Database:VMS

    oldState = 0, newState = 4, currentState = 4

    2006-03-16-17.45.36.031002 InstanceB2 Node:000
    PID:1052(db2syscs.exe) TID:1360 Appid:AC132350.3906.060316114244
    buffer_pool_services sqlbTestSetDatapoolState Probe:778 Database:VMS
    DIA9999E An internal error occurred. Report the following error code :
    "0xFFFF8138".

    2006-03-16-17.45.36.046000 InstanceB2 Node:000
    PID:1052(db2syscs.exe) TID:1360 Appid:AC132350.3906.060316114244
    database_utilities sqluRegisterLoadStart Probe:70 Database:VMS

    Load Error: Unable to quiesce pools for table.

    2006-03-16-17.45.36.109000 InstanceB2 Node:000
    PID:1052(db2syscs.exe) TID:1360 Appid:AC132350.3906.060316114244
    database_utilities sqlu_register_table_load Probe:150 Database:VMS

    CA before rollback5351 4c43 4120 2020 8800 0000 23f1 ffff SQLCA ...#
    0300 32ff 31ff 0020 2020 2020 2020 2020 ..21.
    2020 2020 2020 2020 2020 2020 2020 2020
    2020 2020 2020 2020 2020 2020 2020 2020
    2020 2020 2020 2020 2020 2020 2020 2020
    2020 2020 2020 2020 5351 4c55 5655 544c SQLUVUTL
    0000 0000 0000 0000 0000 0000 0000 0000 ................
    0000 0000 0000 0000 2020 2020 2020 2020 ........
    2020 2020 2020 2020


    2006-03-16-17.45.36.296000 InstanceB2 Node:000
    PID:1052(db2syscs.exe) TID:1916 Appid:AC132350.3006.060316113219
    base_sys_utilities sqle_db2ra_lob_send_receive Probe:103 Database:VMS
    DIA3535C LOB File transfer error. Communications error encountered when
    "sending". ("0" "10054 * 0 TCP/IP SOCKETS send ")

    2006-03-16-17.45.36.359000 InstanceB2 Node:000
    PID:1052(db2syscs.exe) TID:1916 Appid:AC132350.3006.060316113219
    database_utilities DIAG_ERROR Probe:0 Database:VMS

    Error!!! open client file -32147, 00000000, Detected in file: d:\db2bld\src\sqluvld.c, line 13270

    2006-03-16-17.45.36.390000 InstanceB2 Node:000
    PID:1052(db2syscs.exe) TID:2404 Appid:none
    database_utilities sqluMCInitRestoreMC Probe:60

    Media controller -- Unable to initialize device C:\db21n

    2006-03-16-17.45.36.421000 InstanceB2 Node:000
    PID:1052(db2syscs.exe) TID:1916 Appid:AC132350.3006.060316113219
    database_utilities DIAG_ERROR Probe:0 Database:VMS

    Load warning: Early error detected, rc = 0, sqlcode = 3107

    PLease suggest.


    Rgds
    treddy

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Did you restart the DB2 instance?
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Feb 2006
    Posts
    3
    I have tried the option of restarting the DB instance but still no luck.

  4. #4
    Join Date
    Feb 2006
    Posts
    3
    marcus,
    can you suggest me the steps to be followed in this case and let me see if these work out for me.

  5. #5
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Generally when you get the message "An internal error occurred" you are instructed to call IBM support for resolution. But DB2 version 7 is no longer supported by IBM. Sorry, but I don't have a solution.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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