Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2003
    Posts
    30

    Unanswered: Data Archival strategies and suggestions

    Hi,
    We have a requirement for archival of data on a regular basis.

    We have a set of tables and its related tables that needs to be archived so that we would be able to bring the archived tables on line with minimal data movement. I am thinking of something like the Table partioning in Oracle database server where you can partition a table in several tablespaces EG Q1,q2,q3,q4 for the four quarters. You can selectively take the tablespace online and offline at the drop of a hat with a couple of commands in oracle. Do we have something similar to that? We are using the workgroup server edition.

    Any suggestions and/or white paper articles on this topic are very appreciated.
    Thanks.
    -Soumil

  2. #2
    Join Date
    Jul 2003
    Location
    Austin, TX, USA
    Posts
    278

    Suggestions

    Hi Soumil,

    YOu can look at archiving tables so that they can be stored offline and accessed back whenever required.

    You can also consider help from the Replication Center that is also a good tool.

    Finally please search the forum I am sure you will find it has been discussed before and get a good idea of suggestions that have been put here.

    hth

    Nitin.

  3. #3
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Check out this article entitled: "Partitioning in DB2 Using the UNION ALL View"
    http://www7b.software.ibm.com/dmdd/l...202zuzarte.pdf
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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