Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2008
    Posts
    136

    Unanswered: for moving datafiles or tablespaces from one disk to another

    Hi,
    Please tell me what i need to do for moving all database files or tablespaces files from one pathe to another...

    like...
    if my all database files exist on /pawan/

    and i want to move in /pawan1/

    then what procedure required
    whats action plan
    please send me reply ASAP....


    Thanks
    Pawan

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Look at db2relocatedb command (Command Reference manual).
    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
    Mar 2008
    Posts
    136
    for using this command we need to stop and start db2???????please reply ASAP

  4. #4
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    I would definitively deactivate the database. I didn't find anything regarding instance start/stop in the documentation for db2relocatedb. To be on the safe side, stopping the instance(s) wouldn't hurt either.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

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