Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Location
    Hamburg Germany
    Posts
    5

    Unanswered: DB2 V81 load with long varchar Column very slow

    Hi,
    we are trying to migrate a DB2 Database to a sun Solaris plattform.
    Db2 8.1 Fixpak 5.
    There we have the problem that a Load from a table with a long varchar column take several hours.
    The same load on a AIX 5.2 Maschine with db2 7.2 only takes 5 minutes.

    Any Idea???

  2. #2
    Join Date
    Mar 2004
    Location
    Hamburg Germany
    Posts
    5

    Re: DB2 V81 load with long varchar Column very slow

    Originally posted by entitecdb
    Hi,
    we are trying to migrate a DB2 Database to a sun Solaris plattform.
    Db2 8.1 Fixpak 5.
    There we have the problem that a Load from a table with a long varchar column take several hours.
    The same load on a AIX 5.2 Maschine with db2 7.2 only takes 5 minutes.

    Any Idea???
    I got a solution from IBM.
    They say that it is a performance problem of the Solaris filesystem.
    We use SMS Tablespaces.
    There are 3 possible Workarounds!
    1. use DMS and the load takes only about 3 Minutes.
    2. use SMS with 32K Pagesize and load takes only about 11 Minutes
    3. use SMS and varchar (if possible) and load takes only about 3 Minutes

Posting Permissions

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