DB parameters that could help peformance of load from cursor

grofaty · #1 (**permalink**) 09-12-07, 03:21

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

stolze · #2 (**permalink**) 09-12-07, 04:30

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.

grofaty · #3 (**permalink**) 09-12-07, 04:37

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

Internet Services

Web Development

Digital Marketing

Consumer Tech