moving container? 
Author Message
 moving container?
I am using DB2 on Linux with a DMS database. Is it possible to shutdown
the database and then to move some container to other disks using Linux
system commands?

Is a container a normal file that can be moved and copied without
affecting its contents or does DB2 handle these container in a manner that
makes it impossible to treat them as normal files?

Any information or link to information appreciated.

Ingo



Fri, 07 Mar 2003 03:00:00 GMT
 moving container?

Ingo,


Quote:
> I am using DB2 on Linux with a DMS database. Is it possible to shutdown
> the database and then to move some container to other disks using Linux
> system commands?

No, take an offline backup and with this image take a redirected restore

Quote:

> Is a container a normal file that can be moved and copied without
> affecting its contents or does DB2 handle these container in a manner that
> makes it impossible to treat them as normal files?

Sure, it is a normal file, but don't delete this files, because they are
handled from the database manager

Quote:

> Any information or link to information appreciated.

> Ingo

best regards
Joachim Mueller


Fri, 07 Mar 2003 03:00:00 GMT
 moving container?
   I don't know if it can be done just as you describe... I suspect not.

   However, you can perform a "redirected restore".  Take a backup of the
database, then restore it using the keyword "redirect" on your RESTORE
command.  This will cause the restore to pause while you issue "db2 set
tablespace containers ..." commands to tell DB2 how to override the current
tablespaces container info.  Then you resume the restore, and your overrides
will be used.

   For more details, see the Command Reference ("restore database" command).

Quote:

> I am using DB2 on Linux with a DMS database. Is it possible to shutdown
> the database and then to move some container to other disks using Linux
> system commands?

> Is a container a normal file that can be moved and copied without
> affecting its contents or does DB2 handle these container in a manner that
> makes it impossible to treat them as normal files?

> Any information or link to information appreciated.

> Ingo

--
Larry Menard
IBM Workstation Database (DB2) Performance Team
Defender of Geese and of all things Natural


Fri, 07 Mar 2003 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Moving containers...

2. Moving containers...

3. Moving containers in filesystem

4. Question VFP3: Drag Drop - how to move between two containers

5. move - servercursor - slow when moving form record 1 to record 20.000

6. To Move or not to Move

7. move a mouse pointer to a different location without moving the mouse

8. ADODB::Recordset::Move() erroneously setting EOF when moving to last record

9. move - servercursor - slow when moving form record 1 to record 20.000

10. Move Next or move previous

11. Move() moves to wrong row

12. ADODB::Recordset::Move() erroneously setting EOF when moving to last record


 
Powered by phpBB® Forum Software