documentation generator for DB2

[jezemine]

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

[james_dey]

On 3 Apr, 07:04, "jezemine" <[e-mail]:

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?

[james_dey]

On 3 Apr, 07:04, "jezemine" <[e-mail]:

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

[james_dey]

On 3 Apr, 13:27, [e-mail] wrote:

On 3 Apr, 07:04, "jezemine" <[e-mail]:

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.

[jezemine]

On Apr 3, 5:46 am, [e-mail] 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.

[Jan M. Nelken]

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

[Jesse]

On Apr 3, 10:48 am, "Jan M. Nelken" <[e-mail]>
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 [e-mail]. 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.

[Jesse]

btw, there are examples for invoking SqlSpec against DB2 here:

http://www.elsasoft.org/sqlspec.htm#_Toc163125354

[Jan M. Nelken]

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

[krystie.hammer]

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" <[e-mail]:

On Apr 3, 5:46 am, [e-mail] 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.

[Jesse]

On Apr 3, 9:59 pm, "Jan M. Nelken" <[e-mail]>
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