|
View previous topic :: View next topic
|
| Author |
Message |
rammohan paulrajan
New User
.jpg)
Joined: 28 Nov 2007
Posts: 11
Location: chennai
|
|
|
|
| Which utility is being suggested to do a mass load (approx 450 million) into DB2 table? |
|
| Back to top |
|
 |
ahalyah
New User
Joined: 13 Dec 2007
Posts: 25
Location: india
|
|
|
|
| we can use LOAD UTILITY for this. |
|
| Back to top |
|
|
rammohan paulrajan
New User
Joined: 28 Nov 2007
Posts: 11
Location: chennai
|
|
|
|
| i am sorry for not mentioning it clearly, I want to know which LOAD utility can be used for this |
|
| Back to top |
|
|
Gnanas N
Active Member
Joined: 06 Sep 2007
Posts: 792
Location: Chennai, India
|
|
|
|
| You can use IBM Load utility(DSNUPROC) or BMC Load utility based on which is installed in your shop. |
|
| Back to top |
|
|
ahalyah
New User
Joined: 13 Dec 2007
Posts: 25
Location: india
|
|
|
|
| you can use DSNUTLIB utility. |
|
| Back to top |
|
|
rammohan paulrajan
New User
Joined: 28 Nov 2007
Posts: 11
Location: chennai
|
|
|
|
| Will it be performance friendly? I mean can i load 450 million without any performance issue? |
|
| Back to top |
|
|
vasanthkumarhb
Active User
Joined: 06 Sep 2007
Posts: 275
Location: Bang,iflex
|
|
|
|
Hi,
You can load it, it takes few minutes rather. |
|
| Back to top |
|
|
|
|
