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
 

 

How to unload partitioned tablespace into Fixed length file

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

New User


Joined: 21 Jul 2007
Posts: 27
Location: Chennai

PostPosted: Tue Apr 29, 2008 1:14 pm    Post subject: How to unload partitioned tablespace into Fixed length file
Reply with quote

Hi priyesh.agrawal,

How to unload partitioned tablespace into Fixed length file. I am getting it in variable length file even if i give the DCB parameter.
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 Apr 29, 2008 7:37 pm    Post subject:
Reply with quote

Hello,

Is this a sort question or a db2 unload question?
Back to top
View user's profile Send private message
kalaikala

New User


Joined: 21 Jul 2007
Posts: 27
Location: Chennai

PostPosted: Wed Apr 30, 2008 4:13 pm    Post subject:
Reply with quote

Hi Mr. priyesh.agrawal

How to unload partitioned tablespace into Fixed length file. I am getting it in variable length file even if i give the DCB parameter.

I used the sysin card as below,

UNLOAD TABLESPACE DBXXXXX.TSMYYYY
PART 1
PUNCHDDN SYSPUNCH
UNLDDN YYYYUNLD
SHRLEVEL REFERENCE

The table has 101 byte data but i am getting VB file with 107 bytes length.
Why its creating 2 bytes extra for unload, normally VB file has only 4 bytes its of information.

Can you please explain abount this extra 6 bytes and also how do we get the unloaded data in FB file.
Back to top
View user's profile Send private message
guptae

Moderator


Joined: 14 Oct 2005
Posts: 1187
Location: Bangalore,India

PostPosted: Wed Apr 30, 2008 4:43 pm    Post subject:
Reply with quote

Hello Kalai,

Would you please tell me which utility u are using ?
Is it dsntiaul or DSNTEP2?
Back to top
View user's profile Send private message
kalaikala

New User


Joined: 21 Jul 2007
Posts: 27
Location: Chennai

PostPosted: Wed Apr 30, 2008 4:57 pm    Post subject: Reply to: How to unload partitioned tablespace into Fixed le
Reply with quote

I am using DSNUTILB utility.
Back to top
View user's profile Send private message
UmeySan

Active Member


Joined: 22 Aug 2006
Posts: 755
Location: Germany

PostPosted: Wed Apr 30, 2008 5:49 pm    Post subject:
Reply with quote

Hi !

Compared to the DSNTIAUL unload format the rows of DSNUTILB are prefixed with six bytes, where two of these bytes contains the OBID. In the generated LOAD utility statement the extra six bytes are taken care of and only records with the correct OBID will be loaded.

An why not use a simple IEBGENER Job to copy the output to an other file with FB-Format.

Regards, UmeySan
Back to top
View user's profile Send private message
kalaikala

New User


Joined: 21 Jul 2007
Posts: 27
Location: Chennai

PostPosted: Mon May 05, 2008 3:40 pm    Post subject: Reply to: How to unload partitioned tablespace into Fixed le
Reply with quote

Actually this research is to improve the performance because the table has huge number of data icon_sad.gif. So i don't want to introduce one more step for this.
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6967
Location: porcelain throne

PostPosted: Mon May 05, 2008 6:15 pm    Post subject:
Reply with quote

why do you need a fixed length file?
Back to top
View user's profile Send private message
kalaikala

New User


Joined: 21 Jul 2007
Posts: 27
Location: Chennai

PostPosted: Tue May 06, 2008 5:06 pm    Post subject: Reply to: How to unload partitioned tablespace into Fixed le
Reply with quote

Actually my requirement is,

Parallel unload from partitioned tablespace with single index space

A table (YYYY) has huge number of data. It is a partitioned tablespace with single index space. It has 16 partitions. I want to unload it partition by partition and then one more sort step (for further processes here i want fixed length file).

If I use the below unload tablespace then I can unload the partition 1 but I could do the same parallel for all partition because it has single index space.

UNLOAD TABLESPACE DBXXX001.TSMYYYY
PART 1
PUNCHDDN SYSPUNCH
UNLDDN YYYYUNLD
SHRLEVEL REFERENCE

How to do parallel unload from partitioned tablespace with single index space and also I want to get better performance. Please help me out in this.
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 Converting Variable block file to Fix... bhavana yalavarthi DFSORT/ICETOOL 10 Tue May 16, 2017 2:20 pm
No new posts Getting error while opening a variabl... apandey1 COBOL Programming 5 Fri May 05, 2017 12:22 pm
No new posts Issue with NDM process to transmit ES... chetanambi All Other Mainframe Topics 6 Wed May 03, 2017 10:52 am
No new posts File processing vishwakotin Mainframe Interview Questions 9 Fri Apr 28, 2017 11:38 am
No new posts Occurrence of various strings within ... TS70363 JCL & VSAM 1 Thu Apr 27, 2017 8:18 pm


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