Results 1 to 6 of 6
  1. #1
    Join Date
    Apr 2007
    Posts
    3

    Red face Unanswered: Problem with DB2 redirect restore

    Hi,

    I have the same problem as sosdb:
    http://www.dbforums.com/archive/inde...t-1218647.html

    AIX 5.3, DB2 UDB 8.2 Fixpak 11
    I want to change tablespace containers from files to RAW devices via a redirect restore.

    db2 restore db AAA from /backup/20070429AAA/ replace existing redirect without rolling forward;
    db2 "set tablespace container for 1 using (device '/dev/rATEMP1' 512M, device '/dev/rATEMP2' 512M)";
    db2 restore db AAA continue;

    The RAW devices /dev/rATEMP1 and /dev/rATEMP2 are defined and chown.

    I got "done successfully" reply with command 1 and 2, but got an error when continue with restore.

    SQL1651N The request cannot be executed because the DB2 server version does not support this functionality.

    And I found when containers been set to RAW devices, all DB2 command will got a SQL1651N error, for example, db2 list tablespaces.

    I have check db2diag.log,

    2007-04-29-22.23.16.734174+480 E3764A360 LEVEL: Error (OS)
    PID : 630842 TID : 1 PROC : db2bp
    INSTANCE: db2cml NODE : 000
    FUNCTION: DB2 UDB, oper system services, sqloxltc_app, probe:15
    CALLED : OS, -, unspecified_system_function
    OSERR : EINVAL (22) "A system call received a parameter that is not valid."

    And found probe 15 in error.h is

    #define ENOTBLK 15 /* Block device required */

    Does redirect restore from files to RAW devices is supported by DB2 8.2?

    Please help, thanks!

  2. #2
    Join Date
    Nov 2003
    Location
    California,USA
    Posts
    72

    Problem with DB2 redirect restore

    You can not redirect restore from SMS to DMS tablespaces. The tablespace type should be the same. Only the containers can be changerd.

  3. #3
    Join Date
    Apr 2007
    Posts
    3
    Hi Nagasurir,

    Thanks for your reply, but I am redirect restore from DMS to DMS tablespaces.
    Would you please give me some further advices?
    Thanks in advance.

    Regards,

    Harward Gao

  4. #4
    Join Date
    Apr 2007
    Posts
    3
    Hi Nagasurir,

    In additional, after I defined containers for any one DMS or SMS when I redirect restore any database, DB2 commands can not be excuted.
    For example, I can list tablespaces when a redirect restore started, but I cannnot after a container definition.
    I really got bother about this for some days, any advice is greatly appreciated.

    Regards,

    Harward Gao

  5. #5
    Join Date
    Feb 2009
    Posts
    9
    Hello,

    I am having the same error message during Redirect restore. How did you resolve your issue?

    Thank you

  6. #6
    Join Date
    Dec 2008
    Location
    Toronto, Canada
    Posts
    399
    should not your set containers for all tablespaces (not just one)?

    manual says you need to 'list tablespaces show detail' after your restore command and than set all tablespace containers one by one...
    DB2 9.5/9.7 on Unix/AIX 6.1/Linux

Posting Permissions

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