Results 1 to 3 of 3

Thread: backup command

  1. #1
    Join Date
    Dec 2010
    Posts
    123

    Unanswered: backup command

    Hi all, in windows machine ,i have db2 with following details .


    C:\Documents and Settings\icmadmin>db2level
    DB21085I Instance "DB2" uses "32" bits and DB2 code release "SQL08026" with
    level identifier "03070106".
    Informational tokens are "DB2 v8.1.13.193", "s060801", "WR21371", and FixPak
    "13".
    Product is installed at "D:\IBM\SQLLIB".


    After taking backup , i am getting backup in following folder format

    B:\backup\SAMPLE.0\DB2\NODE0000\CATN0000\20130803\ 160136.001,

    but i want to get in following format

    SAMPLE.0.db2inst1.NODE0000.CATN0000.20130726151144 .001

    which backup command i have to use...

  2. #2
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    Quote Originally Posted by ravichandrapratap View Post
    After taking backup , i am getting backup in following folder format

    B:\backup\SAMPLE.0\DB2\NODE0000\CATN0000\20130803\ 160136.001,

    but i want to get in following format

    SAMPLE.0.db2inst1.NODE0000.CATN0000.20130726151144 .001
    Hi,

    What for?
    This is an expected behavior for db2 8 on Windows:
    Backup overview:
    Note: DB2 Universal Database™, Version 8.2.2 and earlier versions used a four-level subdirectory tree when storing backup images on Windows operating systems:
    DB_alias.Type\Inst_name\NODEnnnn\CATNnnnn\yyyymmdd \hhmmss.Seq_num

    This directory structure is recognizable by the RESTORE utility of newer db2 versions.
    Regards,
    Mark.

  3. #3
    Join Date
    Jan 2003
    Posts
    1,605
    Quote Originally Posted by ravichandrapratap View Post
    which backup command i have to use...
    Version 8.x does NOT support long names, because v8.x was still supported on Windows that had file name limitation 8-3 (eight for file name and three for file extension). So in this case it was not possible to store all of the info in file name, so directory structure was used. In DB2 v8.x it is not possible to execute backup command and to get new long-file-name. You can create a backup on 8.x and restore on newer database version. Just use: db2 restore database from c:\backup
    if there is only single backup image (plus directory structure) in it.

Posting Permissions

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