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

The catalog views SYSCAT.*** do not exist in DB2 for z/OS.
Access SYSIBM.SYSSEQUENCES instead

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!!

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.

Many Many thanks!!

I will try it and keep you posted.

Thanks again,
Mahesh