Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2009
    Posts
    27

    Unanswered: SYSCAT.SEQUENCES on OS390 DB2

    Hello All,

    Our product fails to establish connection with DB2 on OS 390.

    It tries to fetch sequence details from the sequence object SYSCAT.SEQUENCES but we receive an error table undefined.

    We don't have a OS390 to test out whats causing the trouble, can any one let me know if OS390 have sequence object SYSCAT.SEQUENCES ?

    If not what is the equivalent schema object. DB2 version is DB2 OS/390 9.1.5.

    Any help would be highly appreciated.

    Thanks and Regards,
    Mahesh

  2. #2
    Join Date
    Dec 2005
    Posts
    273
    The catalog views SYSCAT.*** do not exist in DB2 for z/OS.
    Access SYSIBM.SYSSEQUENCES instead
    Last edited by umayer; 06-23-10 at 08:49.

  3. #3
    Join Date
    Feb 2009
    Posts
    27
    Thanks a lot for swift response!!

    So db2 on OS 390 don't have SYSCAT.SEQUENCES and SYSIBM.SYSSEQUENCES is the equivalent.

    But when I tested on my Windows version of DB2 I see both of the objects(syscat.sequences and sysibm.sequences), so my question is that, is there any way using whcih I can continue to use syscat.sequences on os390 as well?

    Thanks a lot again!!

  4. #4
    Join Date
    Dec 2005
    Posts
    273
    Sysibm.syssequences ist the name of the catalog table and syscat.sequences is a view defined on that table.

    If you want to use SYSCAT.SEQUENCES on your DB2 for z/OS, simply execute

    CREATE VIEW SYSCAT.SEQUENCES
    AS SELECT * FROM SYSIBM.SYSSEQUENCES ;

    GRANT SELECT ON SYSCAT.SEQUENCES TO anyone-who-needs-it;

    on your DB2 for z/OS.

  5. #5
    Join Date
    Feb 2009
    Posts
    27
    Many Many thanks!!

    I will try it and keep you posted.

    Thanks again,
    Mahesh

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •