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 information about Load and Unload Utility

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

New User


Joined: 13 Jul 2005
Posts: 13

PostPosted: Fri Mar 24, 2006 4:54 pm    Post subject: Need information about Load and Unload Utility
Reply with quote

Hi,

I am not understanding the Load/ Unload utility.. icon_question.gif

Could somone provide me information on this.

Thanks.
Back to top
View user's profile Send private message

daredevil

New User


Joined: 30 Dec 2005
Posts: 9

PostPosted: Wed Mar 29, 2006 2:45 pm    Post subject: Re: Load and Unload Utility
Reply with quote

Hi,

Refer to " DB2/UDB V8 Utility Guide " for details and expalnation about load/unload utilities.

This material is available in the same forum.

Thanks
Daredevil
Back to top
View user's profile Send private message
shammiullah

New User


Joined: 13 Jun 2005
Posts: 24

PostPosted: Wed Mar 29, 2006 5:24 pm    Post subject: Re: Load and Unload Utility
Reply with quote

hi,

Hi,
unload tility is used for taking a backup of a TABLE INTO A FLAT FILE.
LOAD UTILITY IS FOR LOADING A FLAT FILE RECORDS INTO A TABLE.

UNLOAD UTILITY::

//SYSREC00 DD DSN=NUUST.IMR.RTRV.DATA,-DISP=(NEW,CATLG,DELETE)
--THIS IS THE PS WHERE THE BACKUP'LL B STORED
//
//SYSIN DD *
SELECT * FROM TABLENAME;
//
Back to top
View user's profile Send private message
habibullah_j

New User


Joined: 16 Mar 2006
Posts: 3

PostPosted: Fri Mar 31, 2006 12:20 pm    Post subject: Re: Load and Unload Utility
Reply with quote

hi all,
Load is to upload data into a table. (Restore process)
Unload is to download data into a table.(Backup process)
Please do revert it back if i'm wrong.

cheers,
habib

-----------------load process-------------------------------------------
/LOADCUST EXEC PGM=DSNUTILB'
//STEPLIB DD DSN=SYS4.DB2.DB2T.SDSNEXIT,DISP=SHR
// DD DSN=SYS4.DB2.DB2T.SDSNLOAD,DISP=SHR
//SYSERR DD SPACE=(TRK,(200,11),RLSE),UNIT=SYSDA
//SYSMAP DD SPACE=(CYL,(400,11),RLSE),UNIT=SYSDA
//SYSDISC DD SPACE=(TRK,(200,11),RLSE),UNIT=SYSDA
//SYSUT1 DD SPACE=(CYL,(100,300)),UNIT=(SYSDA,4)
//SORTOUT DD SPACE=(CYL,(100,300)),UNIT=(SYSDA,4)
//SORTWK01 DD SPACE=(CYL,(100,200),RLSE),UNIT=(SYSDA,4)
//SORTWK02 DD SPACE=(CYL,(100,200),RLSE),UNIT=(SYSDA,4)
//SORTWK03 DD SPACE=(CYL,(100,200),RLSE),UNIT=(SYSDA,4)
//SORTWK04 DD SPACE=(CYL,(100,200),RLSE),UNIT=(SYSDA,4)
//SORTWK05 DD SPACE=(CYL,(100,200),RLSE),UNIT=(SYSDA,4)
//SORTWK06 DD SPACE=(CYL,(100,200),RLSE),UNIT=(SYSDA,4)
//SYSPRINT DD SYSOUT=*
//UTPRINT DD SYSOUT=*
//SYSIN DD DISP=SHR,DSN=<<member>
//SYSREC DD DISP=SHR,DSN=<member>
-----------------------------------------------------------------------------
-----------------unload process-------------------------------------------
//jobcard........
//*
//UNLAD EXEC PGM=INZUTILB,PARM='DB2T,FASTUNLD'
//STEPLIB DD DSN=SYS4.DB2TOOLS.SINZLINK,
// DISP=SHR
// DD DSN=SYS4.DB2.DB2T.SDSNEXIT,DISP=SHR
// DD DSN=SYS4.DB2.DB2T.SDSNLOAD,DISP=SHR
//SYSREC DD DSN=<member>,
// DISP=(NEW,CATLG,DELETE),UNIT=SYSDA,
// SPACE=(CYL,(1,1),RLSE)
//SYSPUNCH DD DSN=<member>
// DISP=(NEW,CATLG,DELETE),UNIT=SYSDA,
// SPACE=(TRK,(1,1),RLSE)
//UTPRINT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSTERM DD SYSOUT=*
//SYSIN DD *
UNLOAD TABLESPACE <tablespace>
DB2 YES
LOCK NO QUIESCE NO QUIESCECAT NO
SELECT *
FROM <schema>.<tablename>
ORDER CLUSTER
OUTDDN ( SYSREC )
FORMAT DSNTIAUL
LOADDDN SYSPUNCH
LOADOPT (
NOKEEPDICTIONARY
RESUME NO REPLACE STATISTICS TABLE(ALL) INDEX(ALL) UPDATE ALL 00490000
SORTKEYS 4
ENFORCE NO
LOG NO )
/*
Back to top
View user's profile Send private message
Jag

New User


Joined: 07 Dec 2005
Posts: 30
Location: India

PostPosted: Sun Apr 02, 2006 12:27 pm    Post subject: Hi Friends
Reply with quote

The basic concepts load and unload comes when you wnat to production data in the test ernvironment where we do our all the research work icon_smile.gif ..In the load process we unload all the productiond data into a samf file.... In the Load process we will be loading the data from the SAMF files to the test region database..

While loading the database we will load the parent table first and child tables in order maintain the referntial integrity...There are more concepts like Check Pending,Copy Pending,RunStats,Reorg Concepts related to this Unload and Load concepts..Please read this form the book..Feel Free to raise the doubts..As so many people are waiting to know variety of questions and so many people are there to answer as well
..

Cheers,
Jag.
Email: ***EMail ID REMOVED... Read Forum Rules***
Back to top
View user's profile Send private message
jemonthomas

New User


Joined: 24 Jul 2006
Posts: 35
Location: india

PostPosted: Thu Aug 02, 2007 12:13 pm    Post subject: hi
Reply with quote

Can you tell me what SMAF file means??
Back to top
View user's profile Send private message
SharathG

New User


Joined: 23 Jan 2007
Posts: 12
Location: India

PostPosted: Thu Aug 02, 2007 6:54 pm    Post subject: Re: Need information about Load and Unload Utility
Reply with quote

Hi Jag,

While unloading Production data into sequential files, is there an option to mask some sensitive columns and then unload them onto sequential files? As Production database contains customer sensitive information, masking becomes absolutely necessary. Any ideas? Also, is there a way to unload only selected rows from tables. I think there is one but I dont know the exact method. Thanks...
Back to top
View user's profile Send private message
kgumraj2

New User


Joined: 01 Aug 2007
Posts: 42
Location: Hyderabad

PostPosted: Thu Aug 02, 2007 7:01 pm    Post subject:
Reply with quote

Hi,

In Unload JCL, SYSIN does the trick for you.

Code:
//SYSIN DD *
SELECT col1, col2 , col4
FROM TABLENAME;
//


here col3 which is sensitive data is not unloaded.
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: Thu Aug 02, 2007 8:10 pm    Post subject:
Reply with quote

Hello,

Quote:
Can you tell me what SMAF file means??


That was a typo (i believe). It should have been SAM file which is a Sequential Access Method file. Also known as a qsam or flat file.
Back to top
View user's profile Send private message
Jag

New User


Joined: 07 Dec 2005
Posts: 30
Location: India

PostPosted: Fri Aug 03, 2007 12:17 pm    Post subject: Re: Need information about Load and Unload Utility
Reply with quote

Regarding masking certain User sentive columns as per my knowledge its not possiblem...

But there is an another turn around to do this..

We can always create a table eliminating perticular columns of the base or original table and unload from that table...

Cheers,
Jag
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: Fri Aug 03, 2007 7:27 pm    Post subject:
Reply with quote

Hello,

For this
Quote:
As Production database contains customer sensitive information, masking becomes absolutely necessary. Any ideas? Also, is there a way to unload only selected rows from tables.

you might create an additional table or simply write your own program to create a file of exactly what you want - both rows and content.

Even if you found a way to "work around" the issue, at some point, the scope of the requirement might expand and you'd need to write the code then anyway. If you write the code, you have complete control and will not waste resources for special purpose tables that are not needed for other than a work-around.
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 Table(Unicode(Graphic) table) loading... muralikrishnan_new DB2 0 Thu Oct 05, 2017 5:10 pm
No new posts Information About the Equifax Securit... Rohit Umarjikar PC Guides & IT News 6 Mon Sep 11, 2017 9:10 pm
No new posts retrieving envelope information out o... VintageReceiver TSO/ISPF 6 Thu Aug 10, 2017 8:13 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

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