Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Aleph

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Aleph
    3. Knowledge Articles
    4. Setting up z970 synonym for parallel indexing

    Setting up z970 synonym for parallel indexing

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    No headers
    • 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
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Setting up parallel indexing: file_list and tablespaces
      • Setting Z30-MATERIAL and Z68-MATERIAL-TYPE in p_file_96
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 18.01
      2. contype:kba
      3. Prod:Aleph
      4. Type:General
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved