• Article Type: General
• Product: Aleph
• Product Version: 18.01

Description:
When I do "select * from z970;" in our new abc04 parallel library and get no rows selected, that's not really a problem, right, since the same query in abc01 gives me all the synonyms?

Or have I still not connected abc04 correctly to abc01's data?

Resolution:
abc01 file_list has:

LS Z970 ABC03

but util a/17/5/1 in abc01 shows that this synonym is not actually defined:

Enter value for lib: ABC01
Z95 ABC03 Z95
Z97 ABC03 Z97
Z98 ABC03 Z98
Z980 ABC03 Z980


and we see that the SQL for abc01 shows 50:

abc01@ALEPH0> select count(*) from z970;
**** Hit return to continue ****

COUNT(*)
----------
50


The z970 currently exists in abc04, with zero records. In order for a p_manage_01 run in abc04 to generate z97 records from the z970, the z970's will either need to be moved to abc04 or the lines in the abc04 file_list will need to be changed to:

!TAB z970 10M 0K TS4D
!IND z970_id 1M 0K TS3X
!IND z970_id1 1M 0K TS3X
LS z970 abc01

If you do the latter, you will need to drop the z970 before running p_manage_01:

s+ abc04
SQL> select count(*) from z970; [stop if result is more than 0]
SQL> drop table z970;

(Note: You do the "select" above in order to verify that there are 0 records. If there are more than 0 records, you should stop and double-check what you are doing.)

If the result of the select is 0, then do util a/17/5/2 run to generate the synonym.

• Article last edited: 10/8/2013