Chapter 12. Automatic Business System View creation 417
the gemsp_migrateToAlob stored procedure, which converts the distributed rules
and stores the data in the GEM_Pattern, GEM_CriteriaToPattern, GEM_Path,
and GEM_CriteriaToPath tables. The script also produces an output file in the
same format as the ABS configuration file.
We use the sh migrateToAbs.ksh -Sibmtiv5 -Usa -PXXXX -o migrateToAbs.txt
command to generate the migrateToAbs.txt configuration file. The output file
generated by the migration script is shown in Example 12-8.
Example 12-8 Output file migrateToAbs.txt
PatternList
ListName Operand
Pattern
Pattern Class Attribute When Operator Operand1 Operand2
1 G02E MgedSystemName Current EGREP i ibmtiv*
2 G02K MgedSystemName Current EGREP i ibmtiv*
CriteriaToPattern
Criteria Pattern PatternRelated
111
222
Path
Path Level Name
Distributed NetworkLOBC 1 Distributed Network
Distributed NetworkLOBC 2
CriteriaToPath
Criteria Path Level Pattern Variable Value
1 Distributed NetworkLOBC 2 1 name <1:name>
2 Distributed NetworkLOBC 2 2 name <2:name>
The migration tool also produces a log file containing the patterns that could not
be migrated. Example 12-9 shows the contents of the log file in our example.
Example 12-9 Log file migrateToAbs.txt.log
gemsp_migrateToAlob: @start_pattern_id=[1], @start_criteria_id=[1],
@rm_dup_patterns=[1]
Non-Migratable Patterns - do them manually !!
cid LOBKey memOptions memPattern memExpr
memTest enabled exclusive priority
---- ---------------------------------- ---------- ---------- -------------
-------- ------- --------- --------
G02J TEC GenericDistributed NetworkLOBC SQL_LIKE ibmtiv* %HB_HOSTNAME% 0
1 0 0