You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "John Sisson (JIRA)" <de...@db.apache.org> on 2004/11/08 11:27:32 UTC
[jira] Created: (DERBY-60) Documentation refers to SYSIBM system schema
Documentation refers to SYSIBM system schema
--------------------------------------------
Key: DERBY-60
URL: http://nagoya.apache.org/jira/browse/DERBY-60
Project: Derby
Type: Bug
Components: Documentation
Reporter: John Sisson
Priority: Trivial
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).
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://nagoya.apache.org/jira/secure/Administrators.jspa
-
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-60) Documentation refers to SYSIBM system schema
Posted by "Jean T. Anderson (JIRA)" <de...@db.apache.org>.
[ http://nagoya.apache.org/jira/browse/DERBY-60?page=comments#action_55327 ]
Jean T. Anderson commented on DERBY-60:
---------------------------------------
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
> Documentation refers to SYSIBM system schema
> --------------------------------------------
>
> Key: DERBY-60
> URL: http://nagoya.apache.org/jira/browse/DERBY-60
> Project: Derby
> Type: Bug
> Components: Documentation
> Reporter: John Sisson
> Priority: Trivial
>
> 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).
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://nagoya.apache.org/jira/secure/Administrators.jspa
-
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-60) Documentation refers to SYSIBM system
schema
Posted by "Jeff Levitt (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-60?page=comments#action_12369125 ]
Jeff Levitt commented on DERBY-60:
----------------------------------
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!
> Documentation refers to SYSIBM system schema
> --------------------------------------------
>
> Key: DERBY-60
> URL: http://issues.apache.org/jira/browse/DERBY-60
> Project: Derby
> Type: Bug
> Components: Documentation
> Reporter: John Sisson
> Priority: Trivial
>
> 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).
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Updated: (DERBY-60) Document system schemas including SYSIBM
Posted by "Knut Anders Hatlen (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-60?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Knut Anders Hatlen updated DERBY-60:
------------------------------------
Issue Type: Improvement (was: Bug)
Reclassifying from Bug to Improvement.
> Document system schemas including SYSIBM
> ----------------------------------------
>
> Key: DERBY-60
> URL: https://issues.apache.org/jira/browse/DERBY-60
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Reporter: John Sisson
> Priority: Trivial
>
> 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).
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-60) Documentation refers to SYSIBM system
schema
Posted by "Kathey Marsden (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-60?page=comments#action_12370274 ]
Kathey Marsden commented on DERBY-60:
-------------------------------------
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.
> Documentation refers to SYSIBM system schema
> --------------------------------------------
>
> Key: DERBY-60
> URL: http://issues.apache.org/jira/browse/DERBY-60
> Project: Derby
> Type: Bug
> Components: Documentation
> Reporter: John Sisson
> Priority: Trivial
>
> 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).
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Updated: (DERBY-60) Document system schemas including SYSIBM
Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-60?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kathey Marsden updated DERBY-60:
--------------------------------
Summary: Document system schemas including SYSIBM (was: Documentation refers to SYSIBM system schema)
Changing title to better reflect the user request.
> Document system schemas including SYSIBM
> ----------------------------------------
>
> Key: DERBY-60
> URL: https://issues.apache.org/jira/browse/DERBY-60
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Reporter: John Sisson
> Priority: Trivial
>
> 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).
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-60) Documentation refers to SYSIBM system schema
Posted by "John Sisson (JIRA)" <de...@db.apache.org>.
[ http://nagoya.apache.org/jira/browse/DERBY-60?page=comments#action_55331 ]
John Sisson commented on DERBY-60:
----------------------------------
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.
> Documentation refers to SYSIBM system schema
> --------------------------------------------
>
> Key: DERBY-60
> URL: http://nagoya.apache.org/jira/browse/DERBY-60
> Project: Derby
> Type: Bug
> Components: Documentation
> Reporter: John Sisson
> Priority: Trivial
>
> 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).
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://nagoya.apache.org/jira/secure/Administrators.jspa
-
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira