Results 1 to 5 of 5
  1. #1
    Join Date
    May 2015
    Location
    Korea
    Posts
    54
    Provided Answers: 1

    Unanswered: Lost DB files - Cannot connect to DB - How to recover?

    Our Dev is on AIX 7.1 DB2 V10.5Fp7
    Connect to DB is giving : SQL1051N The path "" does not exist or is not valid. SQLSTATE=57019

    $ db2 List database directory

    System Database Directory

    Number of entries in the directory = 1

    Database 1 entry:

    Database alias = SAMPLE
    Database name = SAMPLE
    Local database directory = /data/db2inst01
    Database release level = 10.00
    Comment =
    Directory entry type = Indirect
    Catalog database partition number = 0
    Alternate server hostname =
    Alternate server port number =

    But lost files under:
    /data/db2inst01/db2inst01/NODE0000/SAMPLE

    drwx--x--x 2 db2inst01 db2iadm 256 Apr 16 2012 T0000003
    drwx--x--x 2 db2inst01 db2iadm 256 Nov 20 2015 T0000002
    drwx--x--x 2 db2inst01 db2iadm 256 Apr 16 2012 T0000000

    ./T0000003:
    total 65544
    -rw------- 1 db2inst01 db2iadm 33554432 Jul 29 06:58 C0000000.LRG

    ./T0000002:
    total 16
    -rw------- 1 db2inst01 db2iadm 4096 Dec 31 2012 dummy.txt

    ./T0000000:
    total 327808
    -rw------- 1 db2inst01 db2iadm 167772160 Jul 29 06:58 C0000000.CAT


    We don't have DB2 Backup and Filesystem backup.
    How to recover in this situation?

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    I would say you are out of luck. This error is either a permissions problem, or the directories/files are missing. You can recover from the permission problem, but if files and directories are missing, and you have no backup, then you have nothing to recover from.

    Andy

  3. #3
    Join Date
    Jul 2016
    Location
    Moscow
    Posts
    108
    Provided Answers: 13
    What appears in the db2diad.log when you are trying to connect?
    Regards,
    Mark.

  4. #4
    Join Date
    May 2015
    Location
    Korea
    Posts
    54
    Provided Answers: 1
    2016-08-16-22.02.01.745864-420 I89796024A1544 LEVEL: Error (OS)
    PID : 22020104 TID : 12853 PROC : db2sysc 0
    INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
    APPHDL : 0-33 APPID: *LOCAL.db2inst1.160817050201
    AUTHID : DB2INST1
    EDUID : 12853 EDUNAME: db2agent (SAMPLE) 0
    FUNCTION: DB2 Common, OSSe, ossGetDiskInfo, probe:90
    MESSAGE : ECF=0x9000001A=-1879048166=ECF_FILE_DOESNT_EXIST
    File doesn't exist
    CALLED : OS, -, statvfs
    OSERR : ENOENT (2) "No such file or directory"
    DATA #1 : String, 15 bytes
    /data/SAMPLE
    DATA #2 : unsigned integer, 8 bytes
    384
    CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol)
    [0] 0x09000000074198E8 pdOSSeLoggingCallback + 0x34
    [1] 0x09000000036B31C4 oss_log__FP9OSSLogFacUiN32UlN26iPPc + 0x1C4
    [2] 0x09000000036B36D0 ossLogSysRC + 0xD0
    [3] 0x09000000036D84E4 ossGetDiskInfo + 0x804
    [4] 0x09000000083E8DF8 sqlbGetFileSystemInfo__FPcP11OSSDiskInfoUi + 0x168
    [5] 0x09000000083E8054 sqlbCopyStoragePathsFromDiskCB__FPcUlP13SQLO_MEM_P OOLT1P20SQLB_STORAGEGROUP_CBUi + 0x34C
    [6] 0x090000000832E768 sqlbReadStorageGroupEntry__FPcl12SQLO_FHANDLET2P13 SQLO_MEM_POOLPP20SQLB_STORAGEGROUP_CBUi + 0x1B8
    [7] 0x090000000832E45C sqlbReadStorageGroup__FlP23SQLB_STORAGEGROUP_TABLE P13SQLO_MEM_POOLPcUi + 0x164
    [8] 0x090000000832E248 sqlbReadStorageGroupTable__FPcP23SQLB_STORAGEGROUP _TABLEP13SQLO_MEM_POOLUi + 0x84
    [9] 0x090000000832EAE8 sqlbInitStorageGroupTable + 0x29C

    2016-08-16-22.02.01.747589-420 I89797569A728 LEVEL: Severe
    PID : 22020104 TID : 12853 PROC : db2sysc 0
    INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
    APPHDL : 0-33 APPID: *LOCAL.db2inst1.160817050201
    AUTHID : DB2INST1
    EDUID : 12853 EDUNAME: db2agent (SAMPLE) 0
    FUNCTION: DB2 UDB, buffer pool services, sqlbGetFileSystemInfo, probe:30
    MESSAGE : ZRC=0x800201A5=-2147352155=SQLB_AS_INVALID_STORAGE_PATH
    "Storage path does not exist or is inaccessible."
    DATA #1 : String, 30 bytes
    Could not get file system info
    DATA #2 : Pointer, 8 bytes
    0x07000000d00fb880
    DATA #3 : Pointer, 8 bytes
    0x0700000003bee170
    DATA #4 : Bitmask, 4 bytes
    0x00000180

    2016-08-16-22.02.01.747786-420 I89798298A606 LEVEL: Severe
    PID : 22020104 TID : 12853 PROC : db2sysc 0
    INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
    APPHDL : 0-33 APPID: *LOCAL.db2inst1.160817050201
    AUTHID : DB2INST1
    EDUID : 12853 EDUNAME: db2agent (SAMPLE) 0
    FUNCTION: DB2 UDB, buffer pool services, sqlbCopyStoragePathsFromDiskCB, probe:20
    MESSAGE : ZRC=0x800201A5=-2147352155=SQLB_AS_INVALID_STORAGE_PATH
    "Storage path does not exist or is inaccessible."
    DATA #1 : String, 29 bytes
    Error copying paths from disk

    2016-08-16-22.02.01.747920-420 I89798905A692 LEVEL: Severe
    PID : 22020104 TID : 12853 PROC : db2sysc 0
    INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
    APPHDL : 0-33 APPID: *LOCAL.db2inst1.160817050201
    AUTHID : DB2INST1
    EDUID : 12853 EDUNAME: db2agent (SAMPLE) 0
    FUNCTION: DB2 UDB, buffer pool services, sqlbReadStorageGroupEntry, probe:30
    MESSAGE : ZRC=0x800201A5=-2147352155=SQLB_AS_INVALID_STORAGE_PATH
    "Storage path does not exist or is inaccessible."
    DATA #1 : String, 38 bytes
    Error reading from storage group files
    DATA #2 : signed integer, 8 bytes
    0
    DATA #3 : Pointer, 8 bytes
    0x0700000003bee900

    2016-08-16-22.02.01.748427-420 I89801143A728 LEVEL: Severe
    PID : 22020104 TID : 12853 PROC : db2sysc 0
    INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
    APPHDL : 0-33 APPID: *LOCAL.db2inst1.160817050201
    AUTHID : DB2INST1
    EDUID : 12853 EDUNAME: db2agent (SAMPLE) 0
    FUNCTION: DB2 UDB, buffer pool services, sqlbGetFileSystemInfo, probe:30
    MESSAGE : ZRC=0x800201A5=-2147352155=SQLB_AS_INVALID_STORAGE_PATH
    "Storage path does not exist or is inaccessible."
    DATA #1 : String, 30 bytes
    Could not get file system info
    DATA #2 : Pointer, 8 bytes
    0x07000000d00fb880
    DATA #3 : Pointer, 8 bytes
    0x0700000003bee170
    DATA #4 : Bitmask, 4 bytes
    0x00000180


    2016-08-16-22.02.01.748736-420 I89802479A692 LEVEL: Severe
    PID : 22020104 TID : 12853 PROC : db2sysc 0
    INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
    APPHDL : 0-33 APPID: *LOCAL.db2inst1.160817050201
    AUTHID : DB2INST1
    EDUID : 12853 EDUNAME: db2agent (SAMPLE) 0
    FUNCTION: DB2 UDB, buffer pool services, sqlbReadStorageGroupEntry, probe:30
    MESSAGE : ZRC=0x800201A5=-2147352155=SQLB_AS_INVALID_STORAGE_PATH
    "Storage path does not exist or is inaccessible."
    DATA #1 : String, 38 bytes
    Error reading from storage group files
    DATA #2 : signed integer, 8 bytes
    0
    DATA #3 : Pointer, 8 bytes
    0x0700000003bee908

    2016-08-16-22.02.01.748897-420 I89803172A733 LEVEL: Severe
    PID : 22020104 TID : 12853 PROC : db2sysc 0
    INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
    APPHDL : 0-33 APPID: *LOCAL.db2inst1.160817050201
    AUTHID : DB2INST1
    EDUID : 12853 EDUNAME: db2agent (SAMPLE) 0
    FUNCTION: DB2 UDB, buffer pool services, sqlbReadStorageGroup, probe:20
    MESSAGE : ZRC=0x800201A5=-2147352155=SQLB_AS_INVALID_STORAGE_PATH
    "Storage path does not exist or is inaccessible."
    DATA #1 : String, 38 bytes
    Error reading from storage group files
    DATA #2 : signed integer, 8 bytes
    0
    DATA #3 : Pointer, 8 bytes
    0x07000000d00fb240
    DATA #4 : Pointer, 8 bytes
    0x0780000000ed87b1

    2016-08-16-22.02.01.749092-420 I89803906A702 LEVEL: Severe
    PID : 22020104 TID : 12853 PROC : db2sysc 0
    INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
    APPHDL : 0-33 APPID: *LOCAL.db2inst1.160817050201
    AUTHID : DB2INST1
    EDUID : 12853 EDUNAME: db2agent (SAMPLE) 0
    FUNCTION: DB2 UDB, buffer pool services, sqlbReadStorageGroupTable, probe:20
    MESSAGE : ZRC=0x800201A5=-2147352155=SQLB_AS_INVALID_STORAGE_PATH
    "Storage path does not exist or is inaccessible."
    DATA #1 : String, 38 bytes
    Failed to read the storage group table
    DATA #2 : Pointer, 8 bytes
    0x0780000000ed87b1
    DATA #3 : Pointer, 8 bytes
    0x07000000d00fb240

    2016-08-16-22.02.01.749253-420 I89804609A754 LEVEL: Severe
    PID : 22020104 TID : 12853 PROC : db2sysc 0
    INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
    APPHDL : 0-33 APPID: *LOCAL.db2inst1.160817050201
    AUTHID : DB2INST1
    EDUID : 12853 EDUNAME: db2agent (SAMPLE) 0
    FUNCTION: DB2 UDB, buffer pool services, sqlbInitStorageGroupTable, probe:20
    MESSAGE : ZRC=0x800201A5=-2147352155=SQLB_AS_INVALID_STORAGE_PATH
    "Storage path does not exist or is inaccessible."
    DATA #1 : String, 44 bytes
    Failed to initialize the storage group table
    DATA #2 : Pointer, 8 bytes
    0x0780000000ed87b1
    DATA #3 : Pointer, 8 bytes
    0x0780000000edd100
    DATA #4 : Pointer, 8 bytes
    0x0780000000ef0080

    2016-08-16-22.02.01.750182-420 I89805364A526 LEVEL: Error
    PID : 22020104 TID : 12853 PROC : db2sysc 0
    INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
    APPHDL : 0-33 APPID: *LOCAL.db2inst1.160817050201
    AUTHID : DB2INST1
    EDUID : 12853 EDUNAME: db2agent (SAMPLE) 0
    FUNCTION: DB2 UDB, buffer pool services, sqlbinit, probe:15
    MESSAGE : ZRC=0x800201A5=-2147352155=SQLB_AS_INVALID_STORAGE_PATH
    "Storage path does not exist or is inaccessible."

    2016-08-16-22.02.01.750308-420 I89805891A496 LEVEL: Severe
    PID : 22020104 TID : 12853 PROC : db2sysc 0
    INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
    APPHDL : 0-33 APPID: *LOCAL.db2inst1.160817050201
    AUTHID : DB2INST1
    EDUID : 12853 EDUNAME: db2agent (SAMPLE) 0
    FUNCTION: DB2 UDB, base sys utilities, sqledint, probe:160
    DATA #1 : Hexdump, 4 bytes
    0x0700000003BEEF14 : 8002 01A5 ....

    2016-08-16-22.02.01.750421-420 I89806388A495 LEVEL: Error
    PID : 22020104 TID : 12853 PROC : db2sysc 0
    INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
    APPHDL : 0-33 APPID: *LOCAL.db2inst1.160817050201
    AUTHID : DB2INST1
    EDUID : 12853 EDUNAME: db2agent (SAMPLE) 0
    FUNCTION: DB2 UDB, base sys utilities, sqledint, probe:160
    DATA #2 : Hexdump, 4 bytes
    0x0700000003BEEF14 : 8002 01A5 ....

    2016-08-16-22.02.01.750540-420 I89806884A518 LEVEL: Severe
    PID : 22020104 TID : 12853 PROC : db2sysc 0
    INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
    APPHDL : 0-33 APPID: *LOCAL.db2inst1.160817050201
    AUTHID : DB2INST1
    EDUID : 12853 EDUNAME: db2agent (SAMPLE) 0
    FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:125
    DATA #1 : Hexdump, 4 bytes
    0x0780000000EF5D3C : FFFF FBE5 ....

    2016-08-16-22.02.01.760634-420 E89807403A468 LEVEL: Event
    PID : 22020104 TID : 12853 PROC : db2sysc 0
    INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
    APPHDL : 0-33 APPID: *LOCAL.db2inst1.160817050201
    AUTHID : DB2INST1
    EDUID : 12853 EDUNAME: db2agent (idle) 0
    FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::TermDbConnect, probe:2000
    STOP : DATABASE: SAMPLE : DEACTIVATED: NO

  5. #5
    Join Date
    Jul 2016
    Location
    Moscow
    Posts
    108
    Provided Answers: 13
    /data/SAMPLE

    Is this really one of the storage paths of this datadase?
    Is it accessible?
    Regards,
    Mark.

Posting Permissions

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