Db2 12 docu error

Roy Boxwell

Db2 12 docu error
Hi!



Just looking at the Db2 12 docu and I see a nasty inconsistency in the
SYSPACKDEP description:




Column name

Data type

Description

Use


BNAME

VARCHAR(128)
NOT NULL

The name of an object that a package depends on.

If BTYPE is B or C, the value is the name of the table on which the period
is defined.

G


BQUALIFIER

VARCHAR(128)
NOT NULL

The value of the column depends on the type of object:

* If BNAME identifies a table space (BTYPE is R), the value is the
name of its database.

* If BNAME identifies a table on which a period is defined (BTYPE is
B or C), the value is the qualifier of that table.

* If BNAME identifies user-defined function, a cast function, a
stored procedure, or a sequence (BTYPE is F, O, or Q), the value is the
schema name.

* If BNAME identifies a role, the value is blank.

* Otherwise, the value is the schema of BNAME.

G


BTYPE

CHAR(1)
NOT NULL

Type of object identified by BNAME and BQUALIFIER:

A

Alias

E

INSTEAD OF trigger

F

User-defined function or cast function

H

Global variable

G

Global temporary table

I

Index

M

Materialized query table

O

Stored procedure

P

Partitioned table space if it is defined as LARGE or with the DSSIZE parm

Q

Sequence object

R

Table space

S

Synonym

T

Table

U

Distinct type

V

View

W

SYSTEM_TIME period

Z

BUSINESS_TIME period

0 (zero)

Sequence alias

G


COPYID



INTEGER
NULLABLE



The copy ID







It mentions BTYPE B/C which are not listed in BTYPE... I tried opening this
as a comment/issue on the IBM web site but their website disqus is obviously
dead as I get just apache errors from it...

Though Listserv was a good place to mention this and see if an IBMer reading
it can forward it to the doc dept!





Roy Boxwell

SOFTWARE ENGINEERING GmbH and SEGUS Inc.
-Product Development-

Heinrichstrasse 83-85
40239 Duesseldorf/Germany
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: <mailto:[login to unmask email]> [login to unmask email]
Web http://www.seg.de http://www.seg.de

https://www.seg.de/corporate/rechtliche-hinweise/datenschutz Link zur
Datenschutzerklärung


Software Engineering GmbH
Amtsgericht Düsseldorf, HRB 37894
Geschäftsführung: Gerhard Schubert, Ulf Heinrich



Attachments

  • smime.p7s (5.1k)

Michael Hannan

RE: Db2 12 docu error
(in response to Roy Boxwell)

Ha ha, manuals are known to have little problems at times. The definition can be found in the V11 manual. I guess when inserting value A, then B and C were accidentally erased:

B BUSINESS_TIME
C SYSTEM_TIME

 

Michael Hannan,
DB2 Application Performance Specialist
CPT Global Ltd

Roy Boxwell

Db2 12 docu error
(in response to Michael Hannan)
Aha! Not in my Db2 11 or 12 ones – I guess they deleted the lines in error and I downloaded the latest and greatest...



Roy Boxwell

SOFTWARE ENGINEERING GmbH and SEGUS Inc.
-Product Development-

Heinrichstrasse 83-85
40239 Duesseldorf/Germany
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: <mailto:[login to unmask email]> [login to unmask email]
Web http://www.seg.de http://www.seg.de

https://www.seg.de/corporate/rechtliche-hinweise/datenschutz Link zur Datenschutzerklärung


Software Engineering GmbH
Amtsgericht Düsseldorf, HRB 37894
Geschäftsführung: Gerhard Schubert, Ulf Heinrich



From: Michael Hannan [mailto:[login to unmask email]
Sent: Wednesday, September 11, 2019 12:13 PM
To: [login to unmask email]
Subject: [DB2-L] - RE: Db2 12 docu error



Ha ha, manuals are known to have little problems at times. The definition can be found in the V11 manual. I guess when inserting value A, then B and C were accidentally erased:

B BUSINESS_TIME
C SYSTEM_TIME



Michael Hannan,
DB2 Application Performance Specialist
CPT Global Ltd



-----End Original Message-----

Attachments

  • smime.p7s (5.1k)

Karen Wilkins

RE: Db2 12 docu error
(in response to Roy Boxwell)

Good spot... I'll see if I can raise it internally.

Paul McWilliams

RE: Db2 12 docu error
(in response to Roy Boxwell)

Hi Roy,

I will look into this issue. Also, you can always send any future Db2 for z/OS documentation feedback to [login to unmask email], but I will work on this issue. I will let you know what I find out.

Thanks!


Paul A. McWilliams

Db2 for z/OS Technical Writer IBM Silicon Valley Laboratory

Knowledge CenterDoc PDFs | Doc feedback | Db2 for z/OS News from the Lab

Paul McWilliams

RE: Db2 12 docu error
(in response to Roy Boxwell)

Hi again,

Here is what we learned: BTYPE='B' and 'C' were replaced long ago by 'W' and 'Z', but the references in the descriptions of the related BNAME and BQUALIFIER columns were overlooked when the BTYPE description corrected. We are fixing that now.


I'm uncertain why you were not able to submit a DISQUS comment, but another reader was able to submit a comment about your issue there, and I was able to reply, so it is working somewhat.

Thanks again!

 


Paul A. McWilliams

Db2 for z/OS Technical Writer IBM Silicon Valley Laboratory

Knowledge CenterDoc PDFs | Doc feedback | Db2 for z/OS News from the Lab

Roy Boxwell

Db2 12 docu error
(in response to Paul McWilliams)
Super thanks! I think the DISQUS issue is more to do with Firefox 69.0 as in Opera I was able to at least reach the login screen...



Roy Boxwell

SOFTWARE ENGINEERING GmbH and SEGUS Inc.
-Product Development-

Heinrichstrasse 83-85
40239 Duesseldorf/Germany
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: <mailto:[login to unmask email]> [login to unmask email]
Web http://www.seg.de http://www.seg.de

https://www.seg.de/corporate/rechtliche-hinweise/datenschutz Link zur Datenschutzerklärung


Software Engineering GmbH
Amtsgericht Düsseldorf, HRB 37894
Geschäftsführung: Gerhard Schubert, Ulf Heinrich



From: Paul McWilliams [mailto:[login to unmask email]
Sent: Wednesday, September 11, 2019 10:54 PM
To: [login to unmask email]
Subject: [DB2-L] - RE: Db2 12 docu error



Hi again,

Here is what we learned: BTYPE='B' and 'C' were replaced long ago by 'W' and 'Z', but the references in the descriptions of the related BNAME and BQUALIFIER columns were overlooked when the BTYPE description corrected. We are fixing that now.


I'm uncertain why you were not able to submit a DISQUS comment, but another reader was able to submit a comment about your issue there, and I was able to reply, so it is working somewhat.

Thanks again!



_____

Paul A. McWilliams

Db2 for z/OS Technical Writer IBM Silicon Valley Laboratory

Knowledge Center http://ibm.biz/ibmkc-db2zos | Doc PDFs http://ibm.biz/db2z12docs | Doc feedback <mailto:[login to unmask email]> | Db2 for z/OS News from the Lab https://www.ibm.com/developerworks/community/groups/community/db2znews



-----End Original Message-----

Attachments

  • smime.p7s (5.1k)

Roy Boxwell

Db2 12 docu error
(in response to Roy Boxwell)
Firefox has problems...



I get just



Bad Request

Your browser sent a request that this server could not understand.
Size of a request header field exceeds server limit.

_____

IBM_HTTP_Server at www-01.ibm.com Port 443





As a message when I click on the DISQUS login and it dies.



Then I managed to “reset all cookies from IBM” and now I can login to DISQUS ! ! ! ! Hoorah!!! The week is saved and it is not yet even Friday!



Roy Boxwell

SOFTWARE ENGINEERING GmbH and SEGUS Inc.
-Product Development-

Heinrichstrasse 83-85
40239 Duesseldorf/Germany
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: <mailto:[login to unmask email]> [login to unmask email]
Web http://www.seg.de http://www.seg.de

https://www.seg.de/corporate/rechtliche-hinweise/datenschutz Link zur Datenschutzerklärung


Software Engineering GmbH
Amtsgericht Düsseldorf, HRB 37894
Geschäftsführung: Gerhard Schubert, Ulf Heinrich



From: Boxwell, Roy [mailto:[login to unmask email]
Sent: Thursday, September 12, 2019 7:13 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: Db2 12 docu error



Super thanks! I think the DISQUS issue is more to do with Firefox 69.0 as in Opera I was able to at least reach the login screen...



Roy Boxwell

SOFTWARE ENGINEERING GmbH and SEGUS Inc.
-Product Development-

Heinrichstrasse 83-85
40239 Duesseldorf/Germany
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: <mailto:[login to unmask email]> [login to unmask email]
Web http://www.seg.de http://www.seg.de

https://www.seg.de/corporate/rechtliche-hinweise/datenschutz Link zur Datenschutzerklärung


Software Engineering GmbH
Amtsgericht Düsseldorf, HRB 37894
Geschäftsführung: Gerhard Schubert, Ulf Heinrich



From: Paul McWilliams [mailto:[login to unmask email]
Sent: Wednesday, September 11, 2019 10:54 PM
To: [login to unmask email] <mailto:[login to unmask email]>
Subject: [DB2-L] - RE: Db2 12 docu error



Hi again,

Here is what we learned: BTYPE='B' and 'C' were replaced long ago by 'W' and 'Z', but the references in the descriptions of the related BNAME and BQUALIFIER columns were overlooked when the BTYPE description corrected. We are fixing that now.


I'm uncertain why you were not able to submit a DISQUS comment, but another reader was able to submit a comment about your issue there, and I was able to reply, so it is working somewhat.

Thanks again!



_____

Paul A. McWilliams

Db2 for z/OS Technical Writer IBM Silicon Valley Laboratory

Knowledge Center http://ibm.biz/ibmkc-db2zos | Doc PDFs http://ibm.biz/db2z12docs | Doc feedback <mailto:[login to unmask email]> | Db2 for z/OS News from the Lab https://www.ibm.com/developerworks/community/groups/community/db2znews



-----End Original Message-----

Attachments

  • smime.p7s (5.1k)

James Campbell

Db2 12 docu error
(in response to Roy Boxwell)
At the bottom of every page in the IBM Knowledge Center is a "Feedback" link. Not just Db2
pages, but every page.

It works. I have found that some of the 'send us feedback' email addresses in manuals are
no longer active - whereas the KC Feedback link is.

If you see a discrepancy / error / broken link - report it. I have found the Db2 writers
especially helpful. Might even get a proper write up on DRDA Fast Load :-)

James Campbell

On 11 Sep 2019 at 6:09, Boxwell, Roy wrote:

> Hi!
>
>
>
> Just looking at the Db2 12 docu and I see a nasty inconsistency in the
> SYSPACKDEP description:
>
>


---
This email has been checked for viruses by AVG.
https://www.avg.com

Roy Boxwell

Db2 12 docu error
(in response to James Campbell)
I have also used that in the past... still trying to get “searching” back to where it was a couple of years ago...

Roy Boxwell
SOFTWARE ENGINEERING GmbH and SEGUS Inc.
-Product Development-
Heinrichstrasse 83-85
40239 Düsseldorf/Germany
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: [login to unmask email]
http://www.seg.de
Link zur Datenschutzerklärung

Software Engineering GmbH
Amtsgericht Düsseldorf, HRB 37894
Geschäftsführung: Gerhard Schubert, Ulf Heinrich

> On 14 Sep 2019, at 06:40, James Campbell <[login to unmask email]> wrote:
>
> At the bottom of every page in the IBM Knowledge Center is a "Feedback" link. Not just Db2
> pages, but every page.
>
> It works. I have found that some of the 'send us feedback' email addresses in manuals are
> no longer active - whereas the KC Feedback link is.
>
> If you see a discrepancy / error / broken link - report it. I have found the Db2 writers
> especially helpful. Might even get a proper write up on DRDA Fast Load :-)
>
> James Campbell
>
>> On 11 Sep 2019 at 6:09, Boxwell, Roy wrote:
>>
>> Hi!
>>
>>
>>
>> Just looking at the Db2 12 docu and I see a nasty inconsistency in the
>> SYSPACKDEP description:
>>
>>
>
>
> ---
> This email has been checked for viruses by AVG.
> https://www.avg.com
>
> -----End Original Message-----
>
Attachments

  • smime.p7s (3.9k)

Daniel Luksetich

Db2 12 docu error
(in response to James Campbell)
Are you interested in DRDA fast load. I have tested it and can write up
something on it.
Dan

+--------------------------------------+------------------------------------
-----------------------+
| Daniel L Luksetich          | IBM Certified Advanced Database
Administrator – |
| IBM GOLD Consultant | Db2 10.1 for Linux UNIX and
Windows |
| IDUG Content Committee Past-Chairman | IBM Certified Database Adminstrator
– Db2 11 DBA for z/OS |
| IDUG DB2-L Administrator | IBM Certified System Administrator
– Db2 11 for z/OS |
| URL: https://db2expert.com | IBM Certified Application Developer
– Db2 11 for z/OS |
+--------------------------------------+------------------------------------
-----------------------+


-----Original Message-----
From: James Campbell <[login to unmask email]>
Sent: Friday, September 13, 2019 11:35 PM
To: [login to unmask email]
Subject: [DB2-L] - RE: Db2 12 docu error

At the bottom of every page in the IBM Knowledge Center is a "Feedback"
link. Not just Db2 pages, but every page.

It works. I have found that some of the 'send us feedback' email addresses
in manuals are no longer active - whereas the KC Feedback link is.

If you see a discrepancy / error / broken link - report it. I have found
the Db2 writers especially helpful. Might even get a proper write up on
DRDA Fast Load :-)

James Campbell

On 11 Sep 2019 at 6:09, Boxwell, Roy wrote:

> Hi!
>
>
>
> Just looking at the Db2 12 docu and I see a nasty inconsistency in the
> SYSPACKDEP description:
>
>


---
This email has been checked for viruses by AVG.
https://www.avg.com

-----End Original Message-----