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
 
Compress Vsam Dataset

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

New User


Joined: 05 Jul 2005
Posts: 49
Location: India

PostPosted: Tue Aug 16, 2005 12:11 pm    Post subject: Compress Vsam Dataset
Reply with quote

Hi ALL,
Can we compress the vsam dataset if it is out of space. How can we do this.
Back to top
View user's profile Send private message

elonics

New User


Joined: 05 Jul 2005
Posts: 49
Location: India

PostPosted: Tue Aug 16, 2005 5:24 pm    Post subject:
Reply with quote

This is a interview question for my friend in IBM. Can we compress it or not. or Did any faced a problem when VSAM is out of space.
Back to top
View user's profile Send private message
superk

Moderator Team Head


Joined: 26 Apr 2004
Posts: 4650
Location: Raleigh, NC, USA

PostPosted: Tue Aug 16, 2005 7:44 pm    Post subject: Re: Compress Vsam Dataset
Reply with quote

Virtually all VSAM datasets will already be compressed with SMS compression routines. So, if it is not already, yes, it can be. If it is already, then all that can be done is to either free up some space by eliminating or moving old data, or by actually increasing the storage requirements.
Back to top
View user's profile Send private message
shivashunmugam Muthu

Active User


Joined: 22 Jul 2005
Posts: 114
Location: Chennai

PostPosted: Wed Aug 17, 2005 9:25 am    Post subject:
Reply with quote

Hi SuperK

How to compress it? Is it like something which we used to compress PDS & PS in left extreme as "C"?

am jus searching whether am having any VSAM file...I dint get yet..will try that one...but b4 that please update me..
Back to top
View user's profile Send private message
elonics

New User


Joined: 05 Jul 2005
Posts: 49
Location: India

PostPosted: Wed Aug 17, 2005 2:10 pm    Post subject: Re: Compress Vsam Dataset
Reply with quote

hi Superk,
can u be mor specific in ur answer. i could nt get u .
Back to top
View user's profile Send private message
shivashunmugam Muthu

Active User


Joined: 22 Jul 2005
Posts: 114
Location: Chennai

PostPosted: Wed Aug 17, 2005 4:27 pm    Post subject:
Reply with quote

NOT 'C' .....Its 'Z' icon_smile.gif

Bit Confused!
Back to top
View user's profile Send private message
sarath_ibm

New User


Joined: 03 Aug 2005
Posts: 14
Location: hyderabad

PostPosted: Wed Aug 17, 2005 8:50 pm    Post subject: hi
Reply with quote

hi elonics . its very simple type z in leftside . it will get compressed.
Back to top
View user's profile Send private message
elonics

New User


Joined: 05 Jul 2005
Posts: 49
Location: India

PostPosted: Thu Aug 18, 2005 9:47 am    Post subject:
Reply with quote

I KNOW ,SARATH,THSI IS OK FOR FLATFILES . CAN THIS BE APPLICABLE FOR VSAM DATASETS
Back to top
View user's profile Send private message
Ravi Gopal

New User


Joined: 04 Aug 2005
Posts: 3

PostPosted: Thu Aug 18, 2005 12:17 pm    Post subject: Compress VSAM dataset
Reply with quote

Hi,

To avoid this out of space condition of vsam dataset, you need to do REORG.It can be done in the following ways:

Way1:
====
1.Unload the data from VSAM to falt file using REPRO.
2.Then allocate more volumes for the VSAM file using IDCAMS in batch.
3.Then reload the VSAM file from flat file again using REPRO.

Way2:
====
1.You can directly alter the VSAM file using the following command:
//STEP01 EXEC PGM=IDCAMS
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSIN DD *
ALTER VSAM.DATASET ADDVOLUMES(* * * * *)
/*

This will add 5 new candidate volumes to the file and will be taken care by SMS.

*Sometime it may not allow us to do this due to clients restriction on using the space.


Regards
Ravi
Back to top
View user's profile Send private message
shivashunmugam Muthu

Active User


Joined: 22 Jul 2005
Posts: 114
Location: Chennai

PostPosted: Thu Aug 18, 2005 12:36 pm    Post subject:
Reply with quote

hi Ravi

your options are perfect.. But how to compress is the question here. Adding space is something which we do later.....(after all options)

we cud compress by issuing 'z' only with PDS.

For PSDS/VSAM we cant?

any options guyz
Back to top
View user's profile Send private message
elonics

New User


Joined: 05 Jul 2005
Posts: 49
Location: India

PostPosted: Thu Aug 18, 2005 1:57 pm    Post subject:
Reply with quote

Thanx Ravi
Back to top
View user's profile Send private message
mmwife

Super Moderator


Joined: 30 May 2003
Posts: 1592

PostPosted: Sun Aug 21, 2005 7:59 am    Post subject:
Reply with quote

I've used DFSORT copy to reorg a vsam file. The seq is:

sort/copy to flat file; delete/define VSAM file; sort/copy to empty VSAM file.

As I recall, what you buy back is the freespace and the partially filled CI/CAs The used freespace is freed but the primary space is used in its stead; really not a savings.

The advantage is supposed to be better performance because the split processing overhead is avoided.
Back to top
View user's profile Send private message
ideas

New User


Joined: 25 May 2005
Posts: 53
Location: India

PostPosted: Mon Aug 22, 2005 5:19 pm    Post subject:
Reply with quote

Compression isnt feasible for VSAM I guess.
Back to top
View user's profile Send private message
dneufarth

Active User


Joined: 27 Apr 2005
Posts: 256
Location: Cincinnati OH USA

PostPosted: Tue Aug 23, 2005 1:35 am    Post subject:
Reply with quote

Products are available from CA and BMC that compress VSAM datasets.

Dave
Back to top
View user's profile Send private message
sendil

New User


Joined: 30 Jun 2005
Posts: 27

PostPosted: Fri Aug 26, 2005 2:04 pm    Post subject:
Reply with quote

When data is compressed, the length of a stored record may change after
an update without any logical record length change.
VSAM compression is done transparently to the application, through the data
class (DC) parameter in SMS data sets. This DC assigned to the data set has
to specify the following DSNTYPE=EXT with a required COMPACTION=Y
(blank defaults to N). The following screen pictures the ISMF list of the DC:

VSAM compression only applies to KSDS in extended format. All the fields to
the left of the key in the logical record are not compressed. In your next data
model, you can define the key field with offset equal to zero.
Compression affects the catalog, VTOC, and SMF information about VSAM
data sets.

DATACLAS EXTENDED MEDIA
NAME DATA SET NAME TYPE ADDRESSABILITY COMPACTION TYPE
--(2)--- -------(26)------- -----(27)----- ---(28)--- -(29)-
DCSMB EXTENDED REQUIRED NO ---- ------
DCSTRIPE EXTENDED REQUIRED NO ---- ------
DCXXXX EXTENDED REQUIRED NO ---- ------
DIRECT ------------------ NO ---- ------
ECCST ------------------ NO YES MEDIA2
EHPCT ------------------ NO YES MEDIA3
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 ISSUE IN copying Sequential file reco... thesumitk JCL & VSAM 2 Wed Dec 13, 2017 3:07 pm
No new posts File Tailoring -- Temporary dataset i... samzee71 CLIST & REXX 3 Fri Dec 01, 2017 3:12 am
No new posts Compare VSAM files using DFSORT pshongal DFSORT/ICETOOL 5 Thu Nov 23, 2017 10:24 am
No new posts Copy 4 byte of data from the last rec... arunsoods DFSORT/ICETOOL 9 Fri Oct 06, 2017 12:15 pm
No new posts opening a dataset after reading it fr... arunsoods DFSORT/ICETOOL 5 Wed Oct 04, 2017 3:54 pm

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