|
View previous topic :: View next topic
|
| Author |
Message |
martita
New User
.jpg)
Joined: 20 Jan 2006
Posts: 1
|
|
|
|
Hi,
I would need to unload db2 data from production system (DBP1), and then load this data into appl system (DBA1) in the same job. Production and appl systems are defined in different mainframe machines SY2 & SY4.
I am running my jcl in appl system, using
DSN SYSTEM(DBA1)
RUN PROGRAM(DSNTIAUL) PLAN(DSNTIAUC) -
LIB('DBA1.RUNLIB.LOAD') -
END
and A.SYSIN DD DBP1.CC.CURRENCY
I am getting SQLCODE = -904.
Would you know how to perform an unload from a different db2 system? THANKS!!
Marta. |
|
| Back to top |
|
 |
wanderer
Active User
Joined: 05 Feb 2007
Posts: 199
Location: Sri Lanka
|
|
|
|
| Please post the complete -904 error message along with reason code. |
|
| Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10873
Location: italy
|
|
|
|
| Quote: |
-904 UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABLE RESOURCE. REASON
reason-code, TYPE OF RESOURCE resource-type, AND RESOURCE NAME
resource-name
|
if the prod and appla db2 systems are on different systems/cpus/lpars it does not seem reasonable to pretend doing the unload and reload in one job,
on what system would You be running it??
the reasonable ( and at first glance the only way ) is
run the unload on the production system
transfer the unloaded data to the application system
reload
regards
e.s |
|
| Back to top |
|
|
rajandhla
Active User
.jpg)
Joined: 18 Oct 2005
Posts: 182
Location: Luton UK
|
|
|
|
let know the reason code you are getting for the sqlcode
Regards,
jai |
|
| Back to top |
|
|
|
|
