Results 1 to 10 of 10
  1. #1
    Join Date
    Oct 2010
    Posts
    56

    Unanswered: restore db fals with SQL0968C The file system is full

    Hi all,


    on AIX db2 v9.5 , i'm trying to restore db v8.2 (offline backup).
    I use command :
    db2 "restore db merlin from . to '/db2data1/merlin/db2inst1' REPLACE HISTORY FILE without prompting"

    (in order to using it like HADR stand by db ).

    but i'd get the message : SQL0968C The file system is full. SQLSTATE=57011

    i've enough space in Fs /db2data1, and the ulimit is up of 2G .
    All db containers are on /db2data1/merlin/db2inst1 path.

    What am i missing ?
    Pls help !1

    Tnks,

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    do you get the error while executing restore ?
    any indication in diag.log ? this file indicates the fs that is full or what db2 is trying to access. is instance owner owner of fs for db ?
    have you verified the container paths on primary ?
    have you checked the migration guide /infocenter - sometimes it is indicated that wile migration from x to y you need x space in catalog tablespace - log space should be x.....
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  3. #3
    Join Date
    Oct 2010
    Posts
    56
    hi Guy,
    In db2diag i saw that some tablespace containers creation is faild because file system is full, but this container is defined on fs with enough free space available .
    I also can see during the restore that db2 try to create files on this fs, but after 0.21G , it fail with this message of not enough space

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    When creating a DB2 HADR standby database, you should be able to restore without specifying any "TO" or "INTO" options, assuming that two servers are set up with the same paths for the instance (which is highly recommended).

    So you should be able to do this:

    db2 "restore db merlin from /xxx... REPLACE HISTORY FILE without prompting"

    If you have more than one backup on the "from path" obviously you will need to use the TAKEN AT clause.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  5. #5
    Join Date
    Oct 2010
    Posts
    56
    Hi,
    If i Don't use to.. in the restore order , iget : SQL0298N Bad container path. SQLSTATE=428B2.

    In db2diag i get : OSERR : ENOENT (2) "A file or directory in the path name does not exist."

    I prepare exact path in the new server, like in the old one .
    How can i know wich file or directory in not exists ?

    Tks,

  6. #6
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    when the restore ends (with error) do you see any files already created with larger size?
    can you execute df -k
    ls -latr on the db filesystem
    while creating a hadr standby db - upgrading at the same time from V8 to V9 ?
    put some details - from command - messages - diag.... fs.
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  7. #7
    Join Date
    Oct 2010
    Posts
    56
    I don't see any file created during the restore .

    message in db2diag :
    2011-08-18-16.58.57.538298-300 I2737533A523 LEVEL: Info (OS)
    PID : 557074 TID : 772 PROC : db2acd 0
    INSTANCE: db2inst1 NODE : 000
    EDUID : 772 EDUNAME: db2acd 0
    FUNCTION: DB2 Common, OSSe, OSSHIPCMemory::attach, probe:20
    MESSAGE : ECF=0x90000047=-1879048121=ECF_MEM_DOESNT_EXIST
    The specified memory is not found and IPC_CREAT flag is not specified.
    CALLED : OS, -, shmget
    OSERR : ENOENT (2) "A file or directory in the path name does not exist."


    command line message :
    $ db2 "restore db merlin from . REPLACE HISTORY FILE without prompting"
    SQL0298N Bad container path. SQLSTATE=428B2

    this is the containers in old db:
    /db2data1/merlin2/db2inst1/NODE0000/SQL00001/SQLT0000.0
    /db2data1/merlin2/db2inst1/NODE0000/SQL00001/SQLT0001.0
    /db2data1/merlin2/db2inst1/NODE0000/SQL00001/SQLT0002.0
    /db2data1/merlin/db2inst1/NODE0000/SQL00001/tbs/rmaxdat
    SQL0445W Value "/db2data1/merlin/db2inst1/NODE0000/SQL00001/tbs/rmaxdata" has
    been truncated. SQLSTATE=01004

    /db2data1/merlin/db2inst1/NODE0000/SQL00001/tbs/rmaxidx
    /db2data1/merlin/db2inst1/NODE0000/SQL00001/tbs/temp
    /db2data1/merlin2/db2inst1/NODE0000/SQL00001/SYSTOOLSPA
    SQL0445W Value "/db2data1/merlin2/db2inst1/NODE0000/SQL00001/SYSTOOLSPACE"
    has been truncated. SQLSTATE=01004

    /db2data1/merlin2/db2inst1/NODE0000/SQL00001/SYSTOOLSTM
    SQL0445W Value "/db2data1/merlin2/db2inst1/NODE0000/SQL00001/SYSTOOLSTMPSPAC"
    has been truncated. SQLSTATE=01004

    in new server , i have those directories :
    /db2data1/merlin/db2inst1
    /db2data1/merlin2/db2inst1

    something i miss ?

  8. #8
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    I do not see any indication about FULL - where did it come from
    where was the db generated : db2 list db directory should tell
    probably this is the problem or the default db path is pointing to a non existing path
    you are misleading the people that are trying to help you..
    specify in restore where to create the db on.. see syntax diagram..
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  9. #9
    Join Date
    Oct 2010
    Posts
    56
    Hi ,
    During the restore order , i looked on " list db directory" and i see that the db going to another place : /db2/db2inst1/db2data

    Why it try to created on this fs ?
    is the any parameter told db2 to create this new db in this fs ?

  10. #10
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    why do you think IBM has created some doc.. please read..
    RESTORE DATABASE
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

Posting Permissions

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