SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 11:29 AM
| ||||
| ||||
 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      |
|
02-27-2008, 11:29 AM
| |||
| |||
| Re: Missing SYSKEYCST table on iSeries 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 |
|
02-27-2008, 11:29 AM
| |||
| |||
| Re: Missing SYSKEYCST table on iSeries 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 |
|
02-27-2008, 11:30 AM
| ||||
| ||||
| Re: Missing SYSKEYCST table on iSeries 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 |
Linear Mode
