Derby
  1. Derby
  2. DERBY-60

Document system schemas including SYSIBM

    Details

    • Type: Improvement Improvement
    • Status: Open
    • Priority: Trivial Trivial
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Documentation
    • Labels:
      None

      Description

      http://incubator.apache.org/derby/manuals/tools/tools109.html refers to the SYSIBM system schema as an example, but SYSIBM is not mentioned anywhere else in the Derby documentation (when I searched for it).

        Issue Links

          Activity

          Hide
          Knut Anders Hatlen added a comment -

          Reclassifying from Bug to Improvement.

          Show
          Knut Anders Hatlen added a comment - Reclassifying from Bug to Improvement.
          Hide
          Kathey Marsden added a comment -

          Changing title to better reflect the user request.

          Show
          Kathey Marsden added a comment - Changing title to better reflect the user request.
          Hide
          Kathey Marsden added a comment -

          The SYSIBM schema is used internally by Network Client and Network Server for JDBC Metadata methods.
          It has no impact externally except that the user cannot create a schema by this name and it will show up in queries of the system tables.

          Show
          Kathey Marsden added a comment - The SYSIBM schema is used internally by Network Client and Network Server for JDBC Metadata methods. It has no impact externally except that the user cannot create a schema by this name and it will show up in queries of the system tables.
          Hide
          Jeff Levitt added a comment -

          So I am going to create a page in the Ref manual that lists system schemas, and I am going to include the following:

          APP
          NULLID
          SQLJ
          SYS
          SYSCAT
          SYSCS_DIAG
          SYSCS_UTIL
          SYSFUN
          SYSIBM
          SYSPROC
          SYSSTAT

          Is there any information I should include about them or about these in general?

          Thanks!

          Show
          Jeff Levitt added a comment - So I am going to create a page in the Ref manual that lists system schemas, and I am going to include the following: APP NULLID SQLJ SYS SYSCAT SYSCS_DIAG SYSCS_UTIL SYSFUN SYSIBM SYSPROC SYSSTAT Is there any information I should include about them or about these in general? Thanks!
          Hide
          John Sisson added a comment -

          Sorry, I should have been clearer. What I am saying is that the Derby documentation does not document what each of the system schemas are and that if the documentation refers to a schema name such as SYSIBM, then it should be documented elsewhere in the manual.

          There are some comments in SchemaDescriptor.java that lists the system schemas. Some of them, such as SYSCAT, SYSFUN, SYSPROC, SYSSTAT and NULLID appear to be the names used in DB2 databases and have an IBM prefix in their variable names in the code.

          Out of interest, I did a quick search for FUN_ to see where SYSFUN was used and I could only see SYSFUN schema being added in DataDictionaryImpl.java

          At some stage someone familiar with the code should review what these system schemas are used for (are some of them not used?) and document them in the Derby manuals.

          Show
          John Sisson added a comment - Sorry, I should have been clearer. What I am saying is that the Derby documentation does not document what each of the system schemas are and that if the documentation refers to a schema name such as SYSIBM, then it should be documented elsewhere in the manual. There are some comments in SchemaDescriptor.java that lists the system schemas. Some of them, such as SYSCAT, SYSFUN, SYSPROC, SYSSTAT and NULLID appear to be the names used in DB2 databases and have an IBM prefix in their variable names in the code. Out of interest, I did a quick search for FUN_ to see where SYSFUN was used and I could only see SYSFUN schema being added in DataDictionaryImpl.java At some stage someone familiar with the code should review what these system schemas are used for (are some of them not used?) and document them in the Derby manuals.
          Hide
          Jean T. Anderson added a comment -

          At least it's a valid schema name:

          ij> select distinct schemaname from sys.sysschemas;
          SCHEMANAME
          ---------------------------------------------------
          APP
          NULLID
          SQLJ
          SYS
          SYSCAT
          SYSCS_DIAG
          SYSCS_UTIL
          SYSFUN
          SYSIBM
          SYSPROC
          SYSSTAT

          11 rows selected

          Show
          Jean T. Anderson added a comment - At least it's a valid schema name: ij> select distinct schemaname from sys.sysschemas; SCHEMANAME --------------------------------------------------- APP NULLID SQLJ SYS SYSCAT SYSCS_DIAG SYSCS_UTIL SYSFUN SYSIBM SYSPROC SYSSTAT 11 rows selected

            People

            • Assignee:
              Unassigned
              Reporter:
              John Sisson
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:

                Development