| View previous topic :: View next topic |
| Author |
Message |
SureshKumar
Intermediate
Joined: 23 Jan 2003
Posts: 211
Topics: 21
|
 Posted: Tue Nov 11, 2003 1:36 pm Post subject: DB2 Unload - by partition |
 |
|
Hi,
I have a long running DB2 unload job (Using Platinum fast unload). I am aware of which partitions the data is residing in, Can I directly unload data from that partition ? and if so what is the syntax. Thanks
I am not able to get hold of a platinum manual, anyways following is my control card
FASTUNLOAD
LIMIT 0
LOAD-CONTROL DB2LOAD
OUTPUT-FORMAT DSNTIAUL
INPUT-FORMAT TABLE
DISPLAY-STATUS 1000000
IO-BUFFERS 60
VSAM-BUFFERS 360
SQL-ACCESS NONE
SHRLEVEL CHANGE
SELECT ......, |
|
| Back to top |
|
 |
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12375
Topics: 75
Location: San Jose
|
| Posted: Tue Nov 11, 2003 6:35 pm Post subject: |
|
|
Suresh kumar,
You will need PART on your unload card to unload only a specfic partition.
Try this
| Code: |
FASTUNLOAD
LIMIT 0
LOAD-CONTROL DB2LOAD
OUTPUT-FORMAT DSNTIAUL
INPUT-FORMAT TABLE
DISPLAY-STATUS 1000000
IO-BUFFERS 60
VSAM-BUFFERS 360
SQL-ACCESS NONE
SHRLEVEL CHANGE
SELECT * FROM OWNER.TABLE1
PART 1
WHERE ...
AND ...
|
Note the part statement after the select statement. Here I am selecting only partition 1
Hope this helps...
cheers
kolusu
PS: check this link for FASTUNLOAD MANUALS |
|
| Back to top |
|
|
SureshKumar
Intermediate
Joined: 23 Jan 2003
Posts: 211
Topics: 21
|
| Posted: Wed Nov 12, 2003 8:32 am Post subject: |
|
|
| Thank you very much. The link to the manuals was also very helpful. |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
