Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2003
    Posts
    1,605

    Unanswered: DB parameters that could help peformance of load from cursor

    Hi,
    I need to transfer multiple tables from one DB to another DB. I have chosen "load from cursor" method.
    I created multiple "load from cursor" commands from remote database using federated system and I need to execute them in parallel. Are there any DB2 parameters that could benefit (speed up) performance if they are changed/increased?

    Sample:
    Code:
    CREATE NICKNAME ADMIN.SOURCE_TABLE FOR MYSYSTEM.ADMIN.SOURCE_TABLE
    DECLARE MYCURSOR CURSOR FOR SELECT COL1 FROM ADMIN.SOURCE_TABLE;
    LOAD FROM MYCURSOR OF CURSOR INSERT INTO ADMIN.TARGET_TABLE;
    So what are DB parameters that could help increase performance?

    My system:
    Source (remote) DB: DB2/VSE/zSeries v7.5
    Target DB: DB2/Linux/zSeries v8.2 FP11

    Thanks,
    Grofaty
    Last edited by grofaty; 09-12-07 at 04:29.

  2. #2
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    You should use separate connections to avoid a serialization of the different LOAD operations. I would also declare the cursor as FOR READ ONLY to allow blocked cursor operations. Other than that, it's basic performance considerations that apply.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  3. #3
    Join Date
    Jan 2003
    Posts
    1,605
    stolze,
    thanks for help.

    When this commands are executed there are no other application on source and on target database. So the "for read only" is probably not needed.

    Thanks,
    Grofaty

Posting Permissions

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