This section does not describe the functionality and parameters of the functions Unload and Load. This information is given in the sections Unload and Load. Instead, this section tells you how to proceed step by step and indicates some special considerations or restrictions that apply to the individual steps.
The examples given here are for the Migrate Load and Unload functions, but the information given applies in most cases equally to ALF Import and Export functions. Any differences in behavior are described as required.
This section covers the following topics:
This section first describes the unload procedure in general and then gives two detailed examples: one unload operation performed online and one in batch mode.
Create one or more extracts which contain the objects to be unloaded. Before starting the unload operation, please consider the following points:
It is not possible to select fields to be included in an extract. All fields of a file contained in an extract are exported automatically.
If you select userviews, you must also select the related master files if they do not exist in the target environment.
With IMS files and databases, you must always select the entire IMS structure.
All objects that are referenced by objects contained in an extract but are not contained in the extract are stored in the target environment as placeholder objects.
If Predict Security is active, you must have at least READ access to objects you wish to export.
Metadata, retrieval models and XRef data cannot be included in an extract. You can specify them directly with the Unload function.
After an extract has been created online, you have the option to select the objects in batch mode using the command BUILD.
Execute the Unload function under consideration of the following points:
You have to decide whether the Internal ID of objects is to be used. If not, set the parameter with internal ID to N. The concept of the Internal ID and examples of unload operations with or without Internal ID are given in the section Internal ID.
If you wish to unload metadata and objects, you are recommended to perform this unload operation in two steps. First, unload the metadata, and then unload the objects to another transfer medium. This saves time when you load the data at a later time.
After the Unload function has been executed, the source FDIC file contains a protocol in an object of type report listing.
In this example, all objects of an FDIC file are unloaded.
Call Predict
Call Predict with the commands LOGON SYSDIC and MENU.
Create an extract
Create an extract with the command ADD ET ALL-OBJECTS.
Select all objects
Select all objects with the command BUILD ET ALL-OBJECTS.
Do not specify an object type in the screen below.
13:57:37 ***** P R E D I C T ***** 2013-05-31
Plan 14 - Build/extend an Extract - Profile SYSTEM
Extract ID ......... ALL-OBJECTS
Added 2013-05-31 at 13:57
by SYSTEM
Build extract for object type ..*
|
In the next screen, specify the parameters as follows:
13:58:29 ***** P R E D I C T ***** 2013-05-31
Plan 14 - Build/extend an Extract - Profile SYSTEM
Extract ID ......... ALL-OBJECTS
Added 2013-05-31 at 13:57
by SYSTEM
Build extract for object type ..* ( All objects )
Retrieval type .....* D
Output-mode ........* L List
Search criteria
Object ID .........
Drop existing objects N (Y,N)
List objects ........ N (Y,N)
Restrictions .......* E empty
Output options .....* D Profile Default
|
The following window appears:
+--------- Status of Processing --------+ ! ! ! Current time ............... 13:01:31 ! ! No. of objects processed ... 99 ! ! Resulting no. of objects ... 0 ! ! ! ! Continue processing .......* ! +---------------------------------------+ |
Enter U in the field Continue processing.
Unload the objects
Enter the command SYSDICBE to change to the Coordinator.
The following parameters are specified in the Coordinator Main Menu:
Set Function to U.
Set Transfer medium type to 1. This is the default setting which is used in this example.
Set To FDIC DBnr to 46 and To FDIC Fnr to 13. (Default setting is the current FDIC file.)
Specify additional parameters
In the next screen, specify the parameters as follows:
13:42:18 ***** P R E D I C T ***** 2013-05-31
- Unload Extracts -
Extract ID * No. Extract ID * No.
1 ALL-OBJECTS 6
2 7
3 8
4 9
5 10
Unload options Build set for unloading No.
With code ..............* N Metadata ................ N (Y/N)
With profile ............ N (Y/N) Retrieval models ........ N (Y/N)
With internal ID ........ Y (Y/N) XRef data ............... N (Y/N)
Include Extracts ........ N (Y/N)
Target environment .....* 83
Create Report listing ... Y (Y/N)
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
- - Stop - - Flip Print - - - - -
|
Unload successfully terminated
The source FDIC file contains a protocol in an object of
type report listing. The ID of this object is consists of your user ID, the
function code UNL and a timestamp. This protocol lists the objects that have
been unloaded.
In this example, all objects of an FDIC file are unloaded.
Call Predict (online)
Call Predict with the commands LOGON SYSDIC and MENU.
Create an extract (online)
Create an Extract with the command ADD ET ALL-OBJECTS.
Start the unload process
Start the batch job with the following commands:
LOGON SYSDIC MENU BUILD EXTRACT ALL-OBJECTS LIST ALL (select all objects) SYSDICBE (change to Coordinator) SET MEDIUM-TYPE=5 FDIC-DBNR=46 FDIC-FNR=13 (optional) UNLOAD EXTRACT EXTRACT1=ALL-OBJECTS CODE=Y PROFILE=Y FIN |
Unload successfully terminated
The source FDIC file contains a protocol in an object of
type report listing.
This section first describes the load procedure in general and then gives two detailed examples: one performed online and one performed in batch mode.
Check whether an FDIC file has been defined as the Coordinator FDIC with parameters Coordinator FDIC DBnr/Fnr under Defaults > Coordinator Defaults. If this is not the case, define the Coordinator FDIC by specifying these parameters.
To start a load operation, you do not necessarily have to use the function Load, which first performs various checks and then transfers the data to the Main FDIC. You can instead execute the function Test. This command performs the same checks as the function Load but does not transfer the data.
If another load operation is in process when you start a load, the Coordinator FDIC is locked. If the Coordinator FDIC is locked by your own user ID, i.e. the load operation was started by you, you can unlock and clear the Coordinator FDIC with the command CLEAR.
If the Coordinator FDIC is locked by a load operation started by another user, you may have to contact this user and/or wait until the load is completed. If this load was interrupted, it may be necessary to clear the Coordinator FDIC. This can be done by your DB Administrator with the command SPECIAL REFRESH. See Refresh Coordinator FDIC in the section Special Functions in the Predict Administration documentation.
Note:
With both commands CLEAR and SPECIAL REFRESH, all the data on
the Coordinator FDIC is deleted.
The following table shows the actions which are performed by the Coordinator, and the functions/commands you can use to execute the various actions. Each action is described below. See also section Coordinator Check Cycle in this documentation.
|
Transfer to |
Coordinator Check Cycle |
Transfer to |
|||
|---|---|---|---|---|---|
|
Conflict |
Security |
Consistency |
|||
| LOAD | ---------> | ---------> | ---------> | ---------> | ---------- |
| TEST | ---------> | ---------> | ---------> | ---------- | |
| CONTINUE | ---------> | ---------> | ---------> | ---------- | |
| CHECK | ---------> | ---------> | ---------- | ||
|
Report Listing |
Coordinator |
Coordinator |
Coordinator |
Coordinator |
Main FDIC |
Transfer to Coordinator FDIC
The syntax of the ALF/Migrate file to be transferred is
checked. If no error is detected, the data is transferred to the Coordinator
FDIC. If the ALF/Migrate file was created by you and an error occurred, you
must correct the file and reexecute the operation.
Conflict Management - First Phase of the Coordinator
Check Cycle
The Coordinator checks whether there are conflicts
resulting from Internal IDs. In case of a conflict, the operation is cancelled.
After you solved the conflicts, continue by executing the command
CHECK if the data is to be checked only and not to be transferred, or
CONTINUE if the data is to be checked and transferred.
Security - Second Phase of the Coordinator Check
Cycle
The Coordinator checks whether you have the appropriate
access rights to load the data. If there are objects for which you do not have
the required access rights, the operation is cancelled. After you have either
obtained the necessary access rights or deleted the corresponding objects on
the Coordinator FDIC, continue by executing the command
CHECK if the data is to be checked only and not to be transferred, or
CONTINUE if the data is to be checked and transferred.
Consistency Check - Third Phase of the Coordinator Check
Cycle
The data is checked for logical consistency (for example,
uniqueness of file number with file objects). If inconsistencies are detected,
the operation is cancelled. After resolving the consistency conflicts on the
Coordinator FDIC, continue by executing the command
CHECK if the data is to be checked only and not to be transferred, or
CONTINUE if the data is to be checked and transferred.
Transfer to Main FDIC
All objects are transferred from the Coordinator FDIC to
the Main FDIC. Then the contents of the Coordinator FDIC are deleted. After
successful execution of the load operation, the report listing containing the
protocol can be found on the Main FDIC. It contains the list of the objects
loaded. If the Coordinator cancelled the load because of errors, the report
listing can be found on the Coordinator FDIC.
In this example, the workfile used contains two objects: the program PROG-1 and the system SY-1. The program PROG-1 is to be imported.
LOGON SYSDICBE MENU
Specify the load parameters
The following parameters are specified in the Coordinator
Main Menu:
Set Function to L.
Set Transfer medium type to 1. This is the default setting which is used in this example.
Set To FDIC DBnr to 46 and To FDIC Fnr to 13. (Default setting is the current FDIC file.)
Set Object type to PR. All objects of this type are loaded.
Coordinator FDIC is locked by another import
Another import is running and locks the Coordinator FDIC. A
window appears which contains information about the import in process:
13:59:43 ***** P R E D I C T ***** 2013-05-31
- Coordinator -
Migrate Function ALF Function
+------------------------------------------------------------------------+
U ! !
L ! Coordinator FDIC locked !
T ! ----------------------------------- !
D ! !
B ! Attention: User PRDUNDA TID LOADDOC for main FDIC 46 , 13 !
! has given command !
F ! Load All objects !
! on 2013-05-31 at 13:59:06 !
T ! !
! Status: Transfer main FDIC started at 13:59:11 !
! !
! !
+------------------------------------------------------------------------+
Cipher ........... Cipher .... Cipher ....
Identification ..*
Command ===>
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12--
- - Stop - - Flip Print - - - - -
|
If the current load operation was started by you, you can clear the Coordinator FDIC with the command CLEAR 46 13. Otherwise, you must wait until the current load operation is terminated. Start the load operation again as described under point 2, Specify the load parameters.
Specify additional load parameters
In the following screen, additional load parameters are
specified. In this example, only new objects of type program are to be
imported:
Set Replace to N. This is the default setting.
Start the load by pressing ENTER.
13:38:19 ***** P R E D I C T ***** 2013-05-31
- Load (PR) Program -
Program ID ....................
Load options
Program of type ............*
From date ................... 0000-00-00 00:00 (YYYY-MM-DD HH:II)
Prefix ......................
Suffix ......................
Create Report listing ....... Y (Y/N)
Replace ..................... N (Y/N)
|
Conflict resulting from Internal ID
The following window appears:
+---------------- Attention -----------------------+ ! ! ! Function not successfully terminated. ! ! ! ! Error during CONFLICT MANAGEMENT ! ! ! ! ENTER 'Y' to go to ! ! Coordinator FDIC (180,62) ! ! of Main FDIC ( 46,13) ... Y ! ! ! ! Enter any other value to go to Coordinator Menu ! +--------------------------------------------------+ |
Enter Y to change to the Coordinator FDIC.
Display the report listing
Enter the command DISPLAY RT #SAG-ERROR to display the
report listing which contains the list of errors. The report listing provides
the following information:
CHECKING OBJECTTYPE: PR , OBJECT-ID: PROG-1
DIC1635 OBJECT WITH THIS OBJECT ID, BUT DIFF. INTERNAL ID EXISTS.
DIC1628 CHECKED WITH ERRORS PR PROG-1.
|
Rename object PROG-1 to PROG-2.
Enter the command SYSDICBE to return to the Coordinator.
Enter the command CONTINUE to continue the import that was interrupted.
Error in Check Consistency phase
The following window appears:
+---------------- Attention -----------------------+ ! ! ! Function not successfully terminated. ! ! ! ! Error during CHECK CONSISTENCY ! ! ! ! ENTER 'Y' to go to ! ! Coordinator FDIC (180,62) ! ! of Main FDIC ( 46,13) ... Y ! ! ! ! Enter any other value to go to Coordinator Menu ! +--------------------------------------------------+ |
Enter Y to change to the Coordinator FDIC.
Display the report listing:
Enter the command DISPLAY RT #SAG-ERROR to display the
report listing which contains the list of errors. The Report Listing provides
the following information:
CHECKING OBJECTTYPE: PR , OBJECT-ID: PROG-1
DIC2851 MEMBER ALREADY DOCUMENTED IN SYSTEM PROGRAM : PROG-1
PROGRAM PROG-1 IS ON THE MAIN FDIC.
DIC1628 CHECKED WITH ERRORS PR PROG-2.
|
Resolve the consistency conflict:
One way to resolve the conflict is:
Enter command BACK to change to Main FDIC (target FDIC).
Delete or change the member name in the program PROG-1.
Enter command SYSDICBE to return to the Coordinator.
Enter command CONTINUE to continue the load operation.
Another way to resolve the conflict is:
Delete or change the member name in the program PROG-2.
Enter command SYSDICBE to return to the Coordinator.
Enter command CONTINUE to continue the load operation.
Enter command SYSDIC to change to Main FDIC (target FDIC).
Select the report listing containing the protocol with the command SELECT RT name. The name of the report listing is built from your user ID followed by the string 'IMP' and a time stamp. See the section Logging Coordinator Functions.
Display the report listing.
In this example, a data set exists which contains two objects: program PROG-1 and the System SY-1. The program PROG-1 is to be loaded.
Start the load operation
In the following job, the data set containing the object to
be loaded must be assigned to workfile 5.
LOGON SYSDICBE MENU SET MEDIUM-TYPE=5 FDIC-DBNR=46 FDIC-FNR=13 (optional) LOAD OBJECTTYPE PR REPLACE=N FIN |
Coordinator FDIC is locked by another load
operation
The job is cancelled and provides the following output:
+-----------------------------------------------------------------------------+ ! ! ! Coordinator FDIC locked ! ! ------------------------------ ! ! ! ! ! ! ! ! Attention: User ULH TID DAESA048 for main FDIC 46 , 13 ! ! has given command ! ! Import All objects ! ! on 2013-05-31 at 08:36:02 ! ! ! ! ! ! Status: Transfer main FDIC started at 08:36:06 ! +-----------------------------------------------------------------------------+ |
If the load in process was started by you, you can clear the Coordinator FDIC with the command CLEAR 46 13. Otherwise, you must wait until the current load operation is terminated. Start the job again as described under point 1, Start the load operation.
Conflict resulting from Internal ID
The job is cancelled and provides the following output:
CHECKING OBJECTTYPE: PR , OBJECT-ID: PROG-1
DIC1635 OBJECT WITH THIS OBJECT ID, BUT DIFF. INTERNAL ID EXISTS.
DIC1628 CHECKED WITH ERRORS PR PROG-1.
|
Call Predict with the commands LOGON SYSDIC and MENU.
Enter the command COORDINATOR to change to the Coordinator FDIC.
Rename object PROG-1 to PROG-2.
Continue the load operation
You do not need to specify a workfile for the job started
with the following commands.
LOGON SYSDICBE MENU SET FDIC-DBNR=46 FDIC-FNR=13 (optional) CONTINUE FIN |
Error in Check Consistency phase
The job is cancelled and provides the following output:
CHECKING OBJECTTYPE: PR , OBJECT-ID: PROG-1
DIC2851 MEMBER ALREADY DOCUMENTED IN SYSTEM PROGRAM : PROG-1
PROGRAM PROG-1 IS ON THE MAIN FDIC.
DIC1628 CHECKED WITH ERRORS PR PROG-2.
|
Resolve the consistency conflict online
Call Predict with the commands LOGON SYSDIC and MENU. One
way to resolve the conflict is:
Delete or change the member name in the program PROG-1.
Another way to resolve the conflict is:
Enter the command COORDINATOR to change to the Coordinator FDIC.
Delete or change the member name in the program PROG-2.
Continue the load operation as described under point 5, Continue the load operation.
Load terminated successfully
The load protocol is provided in the job output and in the
Report Listing on the Main FDIC (target FDIC). To display the Report Listing,
see point 11 of the online example (Load operation terminated
successfully).
If you are working with more than one FDIC file, we strongly recommend you consolidate the Internal IDs of the objects at your site.
Consolidating Internal IDs can be done either in a two-step process or in one single step. Both methods are described below.
To consolidate Internal IDs in two steps:
Unload the Internal IDs from the FDIC to a Workfile
Enter the following command:
LOGON SYSDICBE MENU SET dbnr1 fnr1 MEDIUM-TYPE=1 UNLINTERNAL FIN |
where dbnr1 and fnr1 represent
the database and file number of the FDIC.
Load the Internal IDs to the Current FDIC
Enter the following command:
LOGON SYSDICBE MENU SET dbnr2 fnr2 MEDIUM-TYPE=1 LOAD INTERNAL-ID ALL UPDATE=Y FIN |
where dbnr2 and fnr2 represent
the database and file number of the FDIC to be converted.
To consolidate Internal IDs in one step:
Unload the Internal IDs from the FDIC to a Workfile and Load the Internal IDs to the Current FDIC
Enter the following command:
LOGON SYSDICBE MENU SET fnr1 dbnr1 MEDIUM-TYPE=1 UNLINTERNAL SET fnr2 dbnr2 LOAD INTERNALID ALL UPDATE=Y FIN |
where
dbnr1 and fnr1 represent the
file and database number of the source FDIC,
and
dbnr2 and fnr2 represent the
file and database number of the target FDIC.