Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2004
    Location
    Inside Intel
    Posts
    165

    Talking Unanswered: Enabling Multipage File Allocation

    Db2 8.1.5 on Windows 2000 Server

    I am using SMS and would like to enable multipage file allocation to increase the performance. Could anyone guide me how to do so? I was not able to find "db2empfa" command in the bin directory.

    Also i would like to know what are the factors which could be altered to give a thrust in the performance of the DB. Like what configuration parameters would do increase the performance? My main concerns are bulk inserts and nested queries.

    Other info:
    512 MB Ram, Pentium 3, 600 MHz. <-- This is just a test machine
    300 tables, Avg. of 400,000 records in some tables (most are empty), Maximum of 14,000,000 records (about 5 tables).

    Thanx in advance,

    Newbie

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    my aix db2 box has db2empfa ..

    Stop the database and then issue
    db2empfa <dbname>

    The important parms are logbuffer for insert performance and sortheap for queries .. Additonal parms include - your tablespace extent and prefetch size, numioservers,numiocleaners etc.

    Why not use DMS ?



    Cheers
    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Apr 2004
    Location
    Inside Intel
    Posts
    165

    Talking Thanks

    Sathyaram,

    I guess the articles i read influenced me (mind you i am a rookie).

    http://www-106.ibm.com/developerwork..._adamache.html

    and

    http://www.dbforums.com/archive/index.php/t-887567.html

    suggested that the major gains on DMS are fast disappearing.

    Thanks,
    Newbie

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    I don't deny that the gap is disappearing, but isn't it still there ...

    Again, the advantage of using DMS over SMS may be less significant if you are using Enterprise level storge system like IBM Shark, EMC etc. These storage systems handle your IO very efficiently ...
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  5. #5
    Join Date
    Sep 2003
    Posts
    85
    Don't forget that if the database is using DPF (aka EEE), then one needs to issue db2_all "db2empfa db-alias" .

Posting Permissions

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