View previous topic :: View next topic
|
Author |
Message |
rambabu Currently Banned New User
Joined: 18 Apr 2005 Posts: 67
|
|
|
|
helllo ,
can any body pls answer this questiions?
!
1) Difference between delete , purge erase force?
2)How do u check how many records are there in vsam cluster and the fspc availabillity for future insertion?
3)
If the key is from 10th byte to 13th byte, how will u code key parameter?
4)
How dou rename set of files in one shot?
5)
what is vsam re organization and how frequently we need do that?
6) after the vsam is created , first operation we should do is , initializing it with dummy record.(TRUE/FALSE).if if iam not initializing , what operation would give me problem? |
|
Back to top |
|
|
superk
Global Moderator
Joined: 26 Apr 2004 Posts: 4652 Location: Raleigh, NC, USA
|
|
|
|
rambabu wrote: |
6) after the vsam is created , first operation we should do is , initializing it with dummy record.(TRUE/FALSE).if if iam not initializing , what operation would give me problem? |
True. |
|
Back to top |
|
|
MGIndaco
Active User
Joined: 10 Mar 2005 Posts: 432 Location: Milan, Italy
|
|
|
|
Quote: |
1) Difference between delete , purge erase force? |
Delete is a primary command and purge/erase/force are subcommands.
Quote: |
2)How do u check how many records are there in vsam cluster and the fspc availabillity for future insertion? |
2.1 Number of record: use LISTCA in ISPF near the vsam or use LISTCAT with IDCAMS in batch process and see the field REC-TOTAL
2.2 Freespace availability: use the same of 2.1 but look for FREESPC
Quote: |
3) If the key is from 10th byte to 13th byte, how will u code key parameter? |
Key (3 09)
Quote: |
4) How dou rename set of files in one shot? |
With IEBCOPY utility can do this but also IEHPROG.
Quote: |
5) what is vsam reorganization and how frequently we need do that? |
what do you mean with reorganization?
are you talking about the verify command? |
|
Back to top |
|
|
siva79
New User
Joined: 11 Jun 2005 Posts: 3
|
|
|
|
Hi,
5) what is vsam re organization and how frequently we need do that?
a: whenever there is too many splits(CA & CI) happens, the CI & CA becomes complicated and also with the Index and sequence sets. So the performance may decrease in due course. So to avoid this, we go for re-organization of VSAM datasets. This is mainly for KSDS(as ESDS has nothing to do with insertions). Back up of the current dataset is taken and then define the new KSDS file and load the backup data to it back. This forms the VSAM dataset organized. Hope this will clear your doubt. |
|
Back to top |
|
|
|