View previous topic :: View next topic
|
Author |
Message |
amolgijare
New User
Joined: 19 Mar 2005 Posts: 8 Location: Pune, India
|
|
|
|
hi,
we are having one conversion projects. Here we need to insert lot of data in multiple db2 tables. does anyone know any faster loan utility for DB2?
other than : DSNUTILB
Thanks, |
|
Back to top |
|
|
MFRASHEED
Active User
Joined: 14 Jun 2005 Posts: 186 Location: USA
|
|
|
|
Mostly in our shop we use DSNUTILB and PLATINUM, i some cases PLATINUM works faster, try both and compare. |
|
Back to top |
|
|
amolgijare
New User
Joined: 19 Mar 2005 Posts: 8 Location: Pune, India
|
|
|
|
Can you provide me with some example of platinum.
Thanks in advance.
Amol |
|
Back to top |
|
|
MFRASHEED
Active User
Joined: 14 Jun 2005 Posts: 186 Location: USA
|
|
|
|
Here is example of PLATINUM load control statements:
-Does load Replace (Replace all rows)
-Puts table in RW status
-Does Image copies
Code: |
FASTLOAD
REPLACE
STARTUP-ACCESS RW
ESTIMATED-ROWS 000100000
DMS/OS
ALLMSGS
QUICKCOPY COPY01(Y,SYSCP101,,LP,TAP38)
COPY02(Y,SYSCP201,,RP,TAP38)
SORTDEVT SORTDA
SORTNUM 8
SPACE-DEFN NO
UPDATE-SYSCOPY
UPDATE-CATSTATS ALL
INTO TABLE 'table name'
|
|
|
Back to top |
|
|
amolgijare
New User
Joined: 19 Mar 2005 Posts: 8 Location: Pune, India
|
|
|
|
Thanks |
|
Back to top |
|
|
meetreks
New User
Joined: 28 Sep 2006 Posts: 26 Location: Edinburgh
|
|
|
|
One Problem with PLATNIUM though is it always DELETE/DEFINES the cluster before loading. This might take some extra time for bigger tables. |
|
Back to top |
|
|
|