470,619 Members | 1,444 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,619 developers. It's quick & easy.

Missing SYSKEYCST table on iSeries

Using DB2 on the iSeries OS ver 5.2
I am trying to connect to the iSeries using MS Access & an ODBC
connection. I get an error saying that the SYSKEYCST in library QSYS2
is missing. I understand that SYSKEYCST is a catalog table so I am
surprised that it is missing. Is there a utility/script that will
rebuild & populate the table?

Thanks in advance for your assistance

Jan 17 '07 #1
3 1948
Just realized the SYSKEYCST is a view and not a table. So I guess all I
need is a script to re-create it?
pali wrote:
Using DB2 on the iSeries OS ver 5.2
I am trying to connect to the iSeries using MS Access & an ODBC
connection. I get an error saying that the SYSKEYCST in library QSYS2
is missing. I understand that SYSKEYCST is a catalog table so I am
surprised that it is missing. Is there a utility/script that will
rebuild & populate the table?

Thanks in advance for your assistance
Jan 17 '07 #2
pali racontait dans comp.databases.ibm-db2:
Just realized the SYSKEYCST is a view and not a table. So I guess
all I need is a script to re-create it?
You may want to use the command RCLSTG SELECT(*DBXREF)

You probably need to run it from the console in restricted state (using
ENDSBS SBS(*ALL) OPTION(*IMMED) command).
>
pali wrote:
>Using DB2 on the iSeries OS ver 5.2
I am trying to connect to the iSeries using MS Access & an ODBC
connection. I get an error saying that the SYSKEYCST in library
QSYS2 is missing. I understand that SYSKEYCST is a catalog table
so I am surprised that it is missing. Is there a utility/script
that will rebuild & populate the table?

Thanks in advance for your assistance



--
Cordialement/Best regards
Marc Rauzier
Jan 17 '07 #3
Thanks Marc!
Marc Rauzier wrote:
pali racontait dans comp.databases.ibm-db2:
Just realized the SYSKEYCST is a view and not a table. So I guess
all I need is a script to re-create it?

You may want to use the command RCLSTG SELECT(*DBXREF)

You probably need to run it from the console in restricted state (using
ENDSBS SBS(*ALL) OPTION(*IMMED) command).

pali wrote:
Using DB2 on the iSeries OS ver 5.2
I am trying to connect to the iSeries using MS Access & an ODBC
connection. I get an error saying that the SYSKEYCST in library
QSYS2 is missing. I understand that SYSKEYCST is a catalog table
so I am surprised that it is missing. Is there a utility/script
that will rebuild & populate the table?

Thanks in advance for your assistance

--
Cordialement/Best regards
Marc Rauzier
Jan 18 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by Thad Rizzi | last post: by
1 post views Thread by zainis | last post: by
2 posts views Thread by --CELKO-- | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.