copy vsam file with alternate index

Post your questions related to VSAM

Moderator: Moderator Group

Post Reply
manswe1350
Member
Posts: 1
Joined: Sat Nov 16, 2013 12:04 pm
Location: PUNE

copy vsam file with alternate index

Post by manswe1350 » Sat Nov 16, 2013 12:42 pm

Hello,
I am trying to create a exact replica of vsam with alternate index.

I followed this steps:
1.I copied first a.vsam file to another b.vsam file
2. created b.aix
3 created b.path
4. build alternate index.

My base cluster is 100% matching, but when I am trying to compare the a.aix with b.aix, I am getting some unmatched records.
Unmatched records are coming due to order change, I checked the data and found its only sequence of data which is improper, I would like to know why this is occurring, Please let me know, if I missed any thing from my end to fulfill this task.
I am having a utility CA MASTER PLUS, I tried with batch as well as ca master plus utility.

DEFINE ALTERNATEINDEX
(NAME(TEST.XREFAIX)
RELATE(TEST.XREF)
CYL (10 2)
FREESPACE(30 10)
SHAREOPTIONS(2 3)
KEYS(39 39)
NONUNIQUEKEY
UPGRADE
RECORDSIZE(83 19544))
DATA
(NAME(TEST.XREFAIX.DATA)
CISZ(2048))
INDEX
(NAME(TEST.XREFAIX.INDEX))
DEFINE PATH
(NAME(TEST.XREF.PATH)
PATHENTRY(TEST.XREFAIX))
BLDINDEX INDATASET(TEST.XREF)
OUTDATASET(TEST.XREFAIX)

Please reply.
Regards,
Manswe1350

yujinmermaid
Member
Posts: 2
Joined: Mon Mar 16, 2015 4:27 pm
Location: sdfgsdfg

Post by yujinmermaid » Mon Mar 16, 2015 4:38 pm

yujinmermaid,

stop wasting our time
and board space
with your useless posts.

dbz

User avatar
dbzTHEdinosauer
Moderator
Posts: 981
Joined: Mon Oct 02, 2006 8:31 pm

Post by dbzTHEdinosauer » Mon Mar 16, 2015 7:24 pm

manswe1350,

if you reorg your 'a' file first,
and then do the duplication (copy/build)
i imagine that both will be the same.
Dick Brenholtz
JCL, SQL and code in programs have an irritating habit of doing what you say,
not what you meant.

Bookosweet
Member
Posts: 2
Joined: Tue Jul 26, 2016 4:31 pm
Contact:

Post by Bookosweet » Tue Jul 26, 2016 4:42 pm

It is very useful me. Knowledge is very good for me.

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others