Results 1 to 6 of 6
  1. #1
    Join Date
    Sep 2003
    Location
    canada
    Posts
    230

    Unanswered: SAN storage and db2 database performance.

    db2 v8.2.3 and AIX 5.2

    we are going to transfer production database to SAN storage, my question is:

    In point of performance should I (dba) consider some factores like db or dbm parameters or changing registery variable or .....

    I realy appriciate if you help me or give me some resorces for more investigation.

  2. #2
    Join Date
    Jul 2002
    Posts
    48
    Hi

    These two registery variables might improve your performance
    DB2_STRIPED_CONTAINERS=TRUE
    DB2_PARALLEL_IO=*

    for SAN

    Thanks
    Nagesh

  3. #3
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Quote Originally Posted by Nageswaran
    Hi

    These two registery variables might improve your performance
    DB2_STRIPED_CONTAINERS=TRUE
    DB2_PARALLEL_IO=*

    for SAN

    Thanks
    Nagesh
    DB2_STRIPED_CONTAINERS=TRUE is not needed for any tablespaces created in 8.2 or later.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  4. #4
    Join Date
    Jan 2003
    Posts
    1,605
    Marcus_A,
    what about this parameter, if database was backuped up on old computer and restored on new one?
    Thanks,
    Grofaty

  5. #5
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Quote Originally Posted by grofaty
    Marcus_A,
    what about this parameter, if database was backuped up on old computer and restored on new one?
    Thanks,
    Grofaty
    Prior to 8.2, the DB2_STRIPED_CONTAINERS=TRUE parameter must be set before the tablespace is created. If you are using 8.2 (where DB2_STRIPED_CONTAINERS=TRUE by default), then the tablespace must be created after conversion to 8.2.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  6. #6
    Join Date
    Sep 2003
    Location
    canada
    Posts
    230
    Quote Originally Posted by Marcus_A
    Prior to 8.2, the DB2_STRIPED_CONTAINERS=TRUE parameter must be set before the tablespace is created. If you are using 8.2 (where DB2_STRIPED_CONTAINERS=TRUE by default), then the tablespace must be created after conversion to 8.2.

    Thank you all for your help.

Posting Permissions

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