Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Image Copy Steps in Job

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
sijayapal

New User


Joined: 23 Dec 2008
Posts: 69
Location: India

PostPosted: Tue Jun 28, 2011 12:22 pm    Post subject: Image Copy Steps in Job
Reply with quote

Hi,

We have set of load jobs which uses DSNUTILB to load the data into the database. After loading the tables go into copy pending state. To free the table, there are image copy steps at table space level in the job. There are about 150 tables totally.

Performance wise the image copy steps are taking huge time. Is there anyother approach for this problem instead of taking image copy?

Please kindly share your ideas. Thanks all.
Back to top
View user's profile Send private message

ramsankar rajkumar

New User


Joined: 07 Jun 2011
Posts: 18
Location: Chennai, India

PostPosted: Tue Jun 28, 2011 12:43 pm    Post subject:
Reply with quote

If you change controlcard of load job as mentioned below, you can avoid copy pending state of tables.

LOAD DATA -- REPLACE NOCOPYPEND INDDN SYSREC00 INTO TABLE
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1278
Location: Belgium

PostPosted: Tue Jun 28, 2011 12:46 pm    Post subject:
Reply with quote

It is surprising that between load/rebuild/(check)/IC, It is the IC that is the performance bottleneck. But I guess it's dependant on the media where you write your image copies.

Do you need the image copies ? if you don't need a backup (= if necessary, you can reload) , you can "repair".
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Tue Jun 28, 2011 6:03 pm    Post subject:
Reply with quote

Sija,

What kind of you LOAD you are doing ?
LOAD REPLACE - replace entire table's data
LOAD RESUME - append load

If you are doing an LOAD REPLACE, you can do what ramshankar and GuyC suggested(NOCOPYPEND or REPAIR)

If its LOAD RESUME, you did to discuss with DBA regarding recovery strategy and do incremental COPY(only changes since the last image copy), which will reduce time during appilcation batch processing, but may increase little bit DB2 Maintainance Cycle Time.

Thanks,
Sushanth
Back to top
View user's profile Send private message
sijayapal

New User


Joined: 23 Dec 2008
Posts: 69
Location: India

PostPosted: Tue Jun 28, 2011 6:43 pm    Post subject:
Reply with quote

Hi We are using load RESUME..
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Wed Jun 29, 2011 8:55 am    Post subject:
Reply with quote

Sija,

How many rows are you inserting at each run and How many rows are already existing in the table ?

Thanks,
Sushanth
Back to top
View user's profile Send private message
sijayapal

New User


Joined: 23 Dec 2008
Posts: 69
Location: India

PostPosted: Wed Jun 29, 2011 12:53 pm    Post subject:
Reply with quote

Mostly less than a million... in few jobs it will cross million records
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Wed Jun 29, 2011 4:22 pm    Post subject:
Reply with quote

Sija,

You have following options, but you need to discuss this with your DBA,
1. Start Taking INCREMENTAL image copy - additional maintainance needs to be done for merging image copies
2. Use LOG YES in your load resume - may flood DB2 Logs, if there are any storage constraints.

Quote:
Performance wise the image copy steps are taking huge time.
Just curious, can i know how much time Image Copy Step runs ?

Thanks,
Sushanth
Back to top
View user's profile Send private message
prasanth_thavva

New User


Joined: 28 Jul 2005
Posts: 86
Location: Chennai

PostPosted: Thu Jun 30, 2011 8:28 am    Post subject: Reply to: Image Copy Steps in Job
Reply with quote

Regd below response to avoid copypending status suggestion.


"
If you change controlcard of load job as mentioned below, you can avoid copy pending state of tables.

LOAD DATA -- REPLACE NOCOPYPEND INDDN SYSREC00 INTO TABLE"

almost all the shops/projects customizes there load control card like above even though the status of the data base gets changes to COPYPENDING status due to incorrect data like so many reasons. can throw light on this topic how to avoid Copypending status. when ever we get this we used to run a command i beleive its FORCE in Db2 command prompt to reset the database status, or REPAIR utility using batch job.

Thanks
Prasanth icon_biggrin.gif
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1278
Location: Belgium

PostPosted: Thu Jun 30, 2011 1:15 pm    Post subject:
Reply with quote

Forcing/ repairing/ using NOCOPYPEND does have its consequences. I hope you know them when you use it.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts syncsort: copy lines after the keyword shreya19 SYNCSORT 6 Fri Dec 02, 2016 9:47 am
No new posts Single COPY CICS TS datasets and when... Kyle Carroll CICS 2 Tue Oct 11, 2016 9:47 pm
No new posts dataset copy question - REPRO or some... atulxp TSO/ISPF 2 Wed Aug 03, 2016 10:56 pm
No new posts How to copy Tape dataset to unix main... chaky All Other Mainframe Topics 4 Fri Jul 08, 2016 2:52 am
No new posts Using Field names in FILEAID Batch CO... Atul Banke Compuware & Other Tools 2 Wed Jun 29, 2016 9:54 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us