RESTRUCTURE CONNECT

The RESTRUCTURE CONNECT utility statement connects new prior and owner pointers in existing sets. You execute the RESTRUCTURE CONNECT statement after executing the RESTRUCTURE statement as part of a database restructure operation. The RESTRUCTURE CONNECT statement uses the specifications in the base restructuring table and the information in the spill file generated by the RESTRUCTURE statement to make the pointer connections.
idmscu19
The RESTRUCTURE CONNECT utility statement connects new prior and owner pointers in existing sets. You execute the RESTRUCTURE CONNECT statement after executing the RESTRUCTURE statement as part of a database restructure operation. The RESTRUCTURE CONNECT statement uses the specifications in the base restructuring table and the information in the spill file generated by the RESTRUCTURE statement to make the pointer connections.
This article describes the following information:
2
2
Authorization
To
You need this privilege
On
Connect pointers in an area
DBAWRITE
The area
Connect pointers in a segment
DBAWRITE
All areas of the segment
Syntax
  ►►─── RESTRUCTURE CONNECT ──┬── SEGMENT 
segment-name
 ──┬─────────────────►                             └── DBNAME 
db-name
 ────────┘  ►─── USING 
subschema-name
 ──────────────────────────────────────────────►  ►─┬───────────────────────┬─────────────────────────────────────────────►    └─ CONTINUE ─┬─ YES ──┬─┘                 └─ NO ◄──┘    ►─┬──────────────────────────────┬──────────────────────────────────────►    └─ RSTTMOD ─┬─ 
rstt-modname
 ─┬─┘                └─ IDMSRSTT ◄────┘  ►─┬───────────────────────────────────────────────────┬─────────────────►◄    │             ┌───────────────────────────────────┐ │    └────── AREA ─▼────────────────── 
area-name
 ──────┴─┘  
Parameters
  • db-name
    Identifies the database name whose segments include the area or areas to be processed.
  • USING
    Specifies the subschema that defines the records and sets being restructured.
  • subschema-name
    The name of a subschema compiled under a schema that describes the database after restructuring.
  • CONTINUE
    Specifies whether processing is to continue if an error condition is detected during processing.
    By default, if you do not specify YES, RESTRUCTURE CONNECT will not continue processing when an error is detected.
  • YES
    Specifies that processing should continue when an error is detected.
  • NO
    Specifies that processing should stop when an error is detected.
    NO is the default.
  • RSTTMOD
    Specifies the base restructuring table that defines the changes in the database being made by the RESTRUCTURE and RESTRUCTURE CONNECT statements.
    By default, if you do not specify a base restructuring table, IDMSRSTT is used.
  • rstt-modname
    The name of the base restructuring table.
    The default base restructuring table is IDMSRSTT.
  • AREA
    Restricts processing to one or more specified areas.
    By default, if you do not specify one or more areas, all areas in the specified segment that contain occurrences of the records or members of the sets being restructured are processed.
  • area-name
    The name of an area.
Usage
How to submit the RESTRUCTURE CONNECT statement
You submit the RESTRUCTURE CONNECT statement only through the batch command facility. You must be running CA IDMS/DB in local mode.
Vary areas offline
Before submitting the RESTRUCTURE CONNECT statement, vary all affected areas offline.
Connecting pointers for new sets
The RESTRUCTURE CONNECT statement connects new pointers for existing sets only. To connect pointers for new sets, you must run a user-written program after the restructure process is complete.
JCL Considerations
When you submit a RESTRUCTURE CONNECT statement through the batch command facility, the JCL to execute the facility must include statements to define:
  • The database file(s) that map to the area(s) to be processed.
  • The file containing the assembled base restructuring table.
  • The spill file generated by RESTRUCTURE. The size of the spill file should be a multiple of 40 with a maximum block size of 32,760.
  • Sort files to sort the spill file in database key sequence.
For more information about the generic JCL used to execute the batch command facility, see the Batch Command Facility (z/OS) or z/VSE JCL topics.
Examples and Sample Output
To illustrate the use of the RESTRUCTURE CONNECT utility, the RESTRUCTURE utility is run first to add pointers to a set. The RESTRUCTURE CONNECT utility is then executed to update the prefix portion of affected records with pointers.
Adding set pointers
The following example directs the RESTRUCTURE utility to use the base restructuring table, LRDKRSTT, to add prior pointers to the owners and members of set A-B and owner pointers to the members of set A-B.
Input to RESTRUCTURE
RESTRUCTURE empdemo using restr01      rsttmod lrdkrstt continue yes;
Output from RESTRUCTURE
When the RESTRUCTURE operation is completed, the following listing is generated.
IDMSBCF                                              IDMS Batch Command Facility                            mm/dd/yy   PAGE 1    RESTRUCTURE EMPDEMO USING RESTR01         RSTTMOD LRDKRSTT CONTINUE YES;  UT000038 Starting Restructure of area EMPDEMO.EMP-DEMO-REGION  UT000041 Completed processing of area EMPDEMO.EMP-DEMO-REGION, Pages read=10  Records read=6  UT011023   Record name AA  Found=2  Changed=2  Ldel=0 0UT000038 Starting Restructure of area EMPDEMO.INS-DEMO-REGION  UT000041 Completed processing of area EMPDEMO.INS-DEMO-REGION,  Pages read=10  Records read=3  UT011023   Record name BB  Found=3  Changed=3  Ldel=0  Status = 0
Connecting prior and owner pointers
To complete this restructure operation, the RESTRUCTURE CONNECT utility is executed to connect the prior and owner pointers in all occurrences of set A-B after restructuring records A and B.
Input to RESTRUCTURE CONNECT
restructure connect segment empdemo using EMPSS01      rsttmod lrdkrstt continue yes;
Output from RESTRUCTURE CONNECT
When the RESTRUCTURE CONNECT operation is completed, the following listing is generated.
IDMSBCF                                              IDMS Batch Command Facility                            mm/dd/yy   PAGE 1    RESTRUCTURE CONNECT SEGMENT EMPDEMO USING EMPSS01         RSTTMOD LRDKRSTT CONTINUE YES;  UT000038 Starting Connect of area EMPDEMO.EMP-DEMO-REGION  UT000041 Completed processing of area EMPDEMO.EMPDEMO-REGION,  Pages read=10  Records read=6  UT011023   Record name AA  Found=2  Changed=2  Ldel=0  UT000038 Starting Connect of area EMPDEMO.INSDEMO-REGION  UT000041 Completed processing of area EMPDEMO.INSDEMO-REGION,  Pages read=10  Records read=3  UT011023   Record name BB  Found=3  Changed=3  Ldel=0  Status = 0
More Information