By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,115 Members | 898 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,115 IT Pros & Developers. It's quick & easy.

documentation generator for DB2

P: n/a
Just a quick note to let you all know about a shareware app I wrote
called SqlSpec that will generate documentation for any DB2 8.2 (and
up) database.

In addition to DB2, it also supports SQL Server, Oracle, MySQL, Sybase
ASE, PostgreSQL, Analysis Server, and MS Access. This encompasses
pretty much 100% of the DBMS on the market today.

It's available here: http://www.elsasoft.org

There are samples here, including one for DB2: http://www.elsasoft.org/samples.htm

Thanks,
Jesse

Apr 3 '07 #1
Share this Question
Share on Google+
10 Replies


P: n/a
On 3 Apr, 07:04, "jezemine" <nos...@elsasoft.orgwrote:
Just a quick note to let you all know about a shareware app I wrote
called SqlSpec that will generate documentation for any DB2 8.2 (and
up) database.

In addition to DB2, it also supports SQL Server, Oracle, MySQL, Sybase
ASE, PostgreSQL, Analysis Server, and MS Access. This encompasses
pretty much 100% of the DBMS on the market today.

It's available here:http://www.elsasoft.org

There are samples here, including one for DB2:http://www.elsasoft.org/samples.htm

Thanks,
Jesse
The output looks nice, but I don't know how to connect to DB2 using
your tool.

It's asking for an OLEDB connection string (which is an unusual method
of connecting to DB2) and requires some setup. Is it not possible to
connect via ODBC?
Can you give an example as to what kind of OLEDB connection string
it's expecting?

Apr 3 '07 #2

P: n/a
On 3 Apr, 07:04, "jezemine" <nos...@elsasoft.orgwrote:
Just a quick note to let you all know about a shareware app I wrote
called SqlSpec that will generate documentation for any DB2 8.2 (and
up) database.

In addition to DB2, it also supports SQL Server, Oracle, MySQL, Sybase
ASE, PostgreSQL, Analysis Server, and MS Access. This encompasses
pretty much 100% of the DBMS on the market today.

It's available here:http://www.elsasoft.org

There are samples here, including one for DB2:http://www.elsasoft.org/samples.htm

Thanks,
Jesse
Ok, It seems that the OLEDB provider is all set up for me in DB2 9.
I've tried it with
provider=IBMDADB2;DSN=<database>;UID=<username>;PW D=<password>;Default
Schema=<schema>.

It's got to the "Fetch tables" bit and my CPU on my windows box has
been maxed out at 100% for the last 5 minutes. I'm not convinced that
the Default Schema bit is working. How can I tell? The reason why I
say that is that I have a lot of schemas on my dev box but not a lot
of tables in the schema that I've pointed it to.

Ta,
J

Apr 3 '07 #3

P: n/a
On 3 Apr, 13:27, james_...@hotmail.com wrote:
On 3 Apr, 07:04, "jezemine" <nos...@elsasoft.orgwrote:
Just a quick note to let you all know about a shareware app I wrote
called SqlSpec that will generate documentation for any DB2 8.2 (and
up) database.
In addition to DB2, it also supports SQL Server, Oracle, MySQL, Sybase
ASE, PostgreSQL, Analysis Server, and MS Access. This encompasses
pretty much 100% of the DBMS on the market today.
It's available here:http://www.elsasoft.org
There are samples here, including one for DB2:http://www.elsasoft.org/samples.htm
Thanks,
Jesse

Ok, It seems that the OLEDB provider is all set up for me in DB2 9.
I've tried it with
provider=IBMDADB2;DSN=<database>;UID=<username>;PW D=<password>;Default
Schema=<schema>.

It's got to the "Fetch tables" bit and my CPU on my windows box has
been maxed out at 100% for the last 5 minutes. I'm not convinced that
the Default Schema bit is working. How can I tell? The reason why I
say that is that I have a lot of schemas on my dev box but not a lot
of tables in the schema that I've pointed it to.

Ta,
J
Ok, I like your tool apart from the fact that I don't seem to be able
to select a specific schema which is a major drawback. Looking at the
sql which the tool is using to query the system catalog it doesn't
seem to be schema specific. This is a pity. I'd buy it otherwise.

Apr 3 '07 #4

P: n/a
On Apr 3, 5:46 am, james_...@hotmail.com wrote:
Ok, I like your tool apart from the fact that I don't seem to be able
to select a specific schema which is a major drawback. Looking at the
sql which the tool is using to query the system catalog it doesn't
seem to be schema specific. This is a pity. I'd buy it otherwise.
Thanks for the feedback - I'll add this feature for DB2 and post back
here when it's done.

Apr 3 '07 #5

P: n/a
jezemine wrote:
Just a quick note to let you all know about a shareware app I wrote
called SqlSpec that will generate documentation for any DB2 8.2 (and
up) database.
My first attempt:

4/3/2007 13:46:12
Executing query to:
provider=IBMDADB2;DSN=SAMPLE;UID=xxxxxxxx;PWD=yyyy yyyy;DefaultSchema=zzzzzzzz
---------------------------------------------------------------
Error occurred. If you think this error is caused by a bug, copy
everthing you see here and send it to sq*****@elsasoft.org. If
you can, also attach a SQL script to generate the database that
reproduces this bug, it will help us reproduce the issue. Thanks!
SqlSpec v3.6.0
4/3/2007 13:46:13
---------------------------------------------------------------
Could not load file or assembly 'System.EnterpriseServices.Wrapper.dll'
or one of its dependencies. The system cannot find the file specified.

System.IO.FileNotFoundException

System.EnterpriseServices

at System.EnterpriseServices.ContextUtil.get_IsInTran saction()
at System.Data.Common.ADP.IsSysTxEqualSysEsTransactio n()
at System.Data.Common.ADP.NeedManualEnlistment()
at System.Data.OleDb.OleDbConnection.Open()
at af.c()
at ad.b(String A_0)
at ad.v()

---------------------------------------------------------------
Could not load file or assembly 'System.EnterpriseServices.Wrapper.dll'
or one of its dependencies. The system cannot find the file specified.
Jan M. Nelken
Apr 3 '07 #6

P: n/a
On Apr 3, 10:48 am, "Jan M. Nelken" <Unknown.U...@Invalid.Domain>
wrote:
jezemine wrote:
Just a quick note to let you all know about a shareware app I wrote
called SqlSpec that will generate documentation for any DB2 8.2 (and
up) database.

My first attempt:

4/3/2007 13:46:12
Executing query to:
provider=IBMDADB2;DSN=SAMPLE;UID=xxxxxxxx;PWD=yyyy yyyy;DefaultSchema=zzzzzzzz
---------------------------------------------------------------
Error occurred. If you think this error is caused by a bug, copy
everthing you see here and send it to sqls...@elsasoft.org. If
you can, also attach a SQL script to generate the database that
reproduces this bug, it will help us reproduce the issue. Thanks!
SqlSpec v3.6.0
4/3/2007 13:46:13
---------------------------------------------------------------
Could not load file or assembly 'System.EnterpriseServices.Wrapper.dll'
or one of its dependencies. The system cannot find the file specified.

System.IO.FileNotFoundException

System.EnterpriseServices

at System.EnterpriseServices.ContextUtil.get_IsInTran saction()
at System.Data.Common.ADP.IsSysTxEqualSysEsTransactio n()
at System.Data.Common.ADP.NeedManualEnlistment()
at System.Data.OleDb.OleDbConnection.Open()
at af.c()
at ad.b(String A_0)
at ad.v()

---------------------------------------------------------------
Could not load file or assembly 'System.EnterpriseServices.Wrapper.dll'
or one of its dependencies. The system cannot find the file specified.

Jan M. Nelken
Can you try the solution posted in this thread:

http://forums.microsoft.com/MSDN/Sho...88468&SiteID=1

It looks like your installation of the .NET framework may be messed up
somehow, as that dll is part of the framework.

Apr 3 '07 #7

P: n/a
btw, there are examples for invoking SqlSpec against DB2 here:

http://www.elsasoft.org/sqlspec.htm#_Toc163125354
Apr 4 '07 #8

P: n/a
Jesse wrote:
>
Can you try the solution posted in this thread:

http://forums.microsoft.com/MSDN/Sho...88468&SiteID=1

It looks like your installation of the .NET framework may be messed up
somehow, as that dll is part of the framework.
You were correct - uninstalling and reinstalling .Net cured this problem.

What you mean by Index size of -4 kb?

Jan M. Nelken
Apr 4 '07 #9

P: n/a
James,

I have implemented a new feature that allows you to limit the schemas
documented by SqlSpec on the command line, using the /DB2S switch.
Here's an example:

::
:: document only objects in the JESSE and JAMES schemas
:: just provide a list of the schemas you want to document, separated
by colons.
::
Sqlspec.exe /DB2S JESSE:JAMES /DB2
"Provider=IBMDADB2;Database=SAMPLE;Hostname=SUMMER ;Protocol=TCPIP;Port=50000;Uid=username;Pwd=passwo rd"

So far this feature is only available in the cmd line interface, not
in the GUI. You can try out the new build (3.6.1) here:
http://www.elsasoft.org/sqlspec.zip

Let me know how it goes - I'm happy to answer any other questions or
comments you have.

Jesse

On Apr 3, 10:11 am, "jezemine" <nos...@elsasoft.orgwrote:
On Apr 3, 5:46 am, james_...@hotmail.com wrote:
Ok, I like your tool apart from the fact that I don't seem to be able
to select a specific schema which is a major drawback. Looking at the
sql which the tool is using to query the system catalog it doesn't
seem to be schema specific. This is a pity. I'd buy it otherwise.

Thanks for the feedback - I'll add this feature for DB2 and post back
here when it's done.

Apr 4 '07 #10

P: n/a
On Apr 3, 9:59 pm, "Jan M. Nelken" <Unknown.U...@Invalid.Domain>
wrote:
Jesse wrote:
Can you try the solution posted in this thread:
http://forums.microsoft.com/MSDN/Sho...88468&SiteID=1
It looks like your installation of the .NET framework may be messed up
somehow, as that dll is part of the framework.

You were correct - uninstalling and reinstalling .Net cured this problem.

What you mean by Index size of -4 kb?

Jan M. Nelken
That happens if statistics haven't been gathered on the index, because
SYSCAT.INDEXES.NLEAF returns -1 in that case. I overlooked that
little issue! thanks for pointing it out, I'll fix it in the next
drop.

Jesse

Apr 4 '07 #11

This discussion thread is closed

Replies have been disabled for this discussion.