Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Need help in DB2 Unload utility

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions
View previous topic :: :: View next topic  
Author Message
salehi

New User


Joined: 30 Sep 2006
Posts: 14
Location: Iran

PostPosted: Wed Aug 22, 2007 11:50 am    Post subject: Need help in DB2 Unload utility
Reply with quote

Hi all
I want to ask you something about DB2 UNLOAD program,
our UNLOADs are getting slower and slower time by time by increasing data in small rate !!!
maybe we are not using a good utility or either it's natural ,
but i 'am sure that IBM utilities should be much better than this
and maybe we are not using the appropriate ones,
for unloading we just create a primary master JCL in our sys1.proclib which accepts some parameters like table name ,region name and so on and uses IKJFT01 utility to copy a data set from one region to another one with simple renaming procedure
but i 've read some article which tells something about
Unload utility which is designed just for this purpose and this utility would bypass the SQL and directly work with table spaces leading to increase the speed.
Would u please give me a JCL sample of these utility or a good source with samples prepared...
also we are running DB2 V7.1 ..
now our jcll is like this ...

//UNLOADT PROC TABLE=,SPC='TRK,(1,300)'
//*
//* UNLOAD DATA FROM A TEST REGION DB/2 TABLE
//UNLOADT EXEC PGM=IKJEFT01,DYNAMNBR=20
//STEPLIB DD DSN=&DB2LOAD,DISP=SHR
//SYSREC00 DD DSN=BKUPUNLD.&SUBSYS..TS&TABLE.(+1),
// DISP=(NEW,CATLG,DELETE),
// UNIT=SYSALLDA,
// SPACE=(&SPC,RLSE),
// DCB=BLKSIZE=0
//SYSPUNCH DD DUMMY
//SYSTSPRT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD DUMMY
//SYSTSIN DD DISP=SHR,DSN=&PREFIX..FNETCOM.DB2DDL
//SYSIN DD DISP=SHR,DSN=&PREFIX..FNETCOM.UNLDCARD(&TABLE)
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue Aug 28, 2007 5:04 am    Post subject:
Reply with quote

Hello,

Yes, the increase in time should be fairly linear. As you add more data, the unload/load will take longer.

Hopefully, when your data was defined/created, there was purge criteria specified also. If your data is forever-to-date, any unload/load process will continually take longer as will many/most of your other processes.

If you post your control statements, we may be able to offer suggestions.
Back to top
View user's profile Send private message
salehi

New User


Joined: 30 Sep 2006
Posts: 14
Location: Iran

PostPosted: Mon Nov 12, 2007 10:33 am    Post subject: Reply to: Need help in DB2 Unload utility
Reply with quote

Hi
Remember that always the problem may not be from the utility ,
they are other critical success factor which influence the time
for example in our site ofter a long investigation we found that
the volumes which was dedicated for unload datasets was MIRRORED
like all other volumes in Production system ,
mirroring may not have a sensible increase for small transaction but when you want to take an unload it would effect the total time so much,
mirroring a record of table(for online transactios) is not compatible with mirroing a full data base basckup(all tables) ,
so check the setting of your site through IS to see if the disks which you are going to take UNLOAD are mirrored? if so discard them from mirroring because it is not neccessary, in all site they are taking some other strategies for protecting such data(Daily back up, archiving log data to tape , ext ).

i hope this would help u.
Regards
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 -> Mainframe Interview Questions All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts NULLFILE on ICEGENER Utility Ashishpanpaliya DFSORT/ICETOOL 5 Wed Nov 08, 2017 10:45 pm
No new posts Table(Unicode(Graphic) table) loading... muralikrishnan_new DB2 0 Thu Oct 05, 2017 5:10 pm
No new posts How to Use DebugTool CodeCoverage Uti... neo4u IBM Tools 0 Thu Jun 22, 2017 6:38 pm
No new posts Search utility(3.14) using JCl and Cobol RKS3 COBOL Programming 12 Sat Jun 10, 2017 10:24 pm
No new posts DB2 - TERMINATE utility vasanthz DB2 5 Mon May 15, 2017 11:49 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us