Missing SYSKEYCST table on iSeries

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • pali
    #1

    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

    Tags: None
    • pali
      #2
      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

        Comment

        • Marc Rauzier
          #3
          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

            Comment

            • pali
              #4
              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

                Comment

                Previous template Next
                Working...