Database exception table (DBET) log record register information

Sumit Sharma

Database exception table (DBET) log record register information

As per the IBM manuals, Database exception table (DBET) log records hold information about RESTRICTED status, SYSCOPY recovery information etc. 

Can someone provide more information on this. Like how is this information stored, can we read information stored in this table/register?

There is not much information available in manuals about Database exception table (DBET) register.

I could only find this link which has very little information :https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/admin/src/tpc/db2z_exceptiontablerecord.html 

Thanks in advance.

Roy Boxwell

Database exception table (DBET) log record register information
(in response to Sumit Sharma)
The DBET is an in memory structure so you need a cross memory, APF authorized assembler program to “access” it... If this scares you a little then perhaps just doing a –DIS DB(*) SP(*) LIMIT(*) and then using REXX is a quicker way?



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: Sumit Sharma [mailto:[login to unmask email]
Sent: Wednesday, September 4, 2019 2:29 PM
To: [login to unmask email]
Subject: [DB2-L] - Database exception table (DBET) log record register information



As per the IBM manuals, Database exception table (DBET) log records hold information about RESTRICTED status, SYSCOPY recovery information etc.

Can someone provide more information on this. Like how is this information stored, can we read information stored in this table/register?

There is not much information available in manuals about Database exception table (DBET) register.

I could only find this link which has very little information :https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/admin/src/tpc/db2z_exceptiontablerecord.html

Thanks in advance.



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

Attachments

  • smime.p7s (5.1k)

Roy Boxwell

Database exception table (DBET) log record register information
(in response to Sumit Sharma)
Here’s my list of current DBET status’s that you can use:



01 DBET-STATUS PIC X(05).

88 DBET-RESTRICTED VALUE

'ACHKP' 'CHKP ' 'COPY ' 'DBETE' 'DEFER' 'GRECP' 'INDBT'

'LPL ' 'LSTOP' 'OPENF' 'PRO ' 'PSRCP' 'PSRBD' 'RBDP '

'RBDP*' 'RECP ' 'RECP*' 'REFP ' 'RELDP' 'REORP' 'REST '

'RESTP' 'RO ' 'RREPL' 'STOP ' 'STOPE' 'STOPP' 'UT '

'UTRO ' 'UTRW ' 'UTUT ' 'WEPR '.

88 DBET-ADVISORY VALUE

'ARBDP' 'AREO*' 'AREOR' 'AREST' 'AUXW ' 'ICOPY'.



And yes it is COBOL....



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: Sumit Sharma [mailto:[login to unmask email]
Sent: Wednesday, September 4, 2019 2:29 PM
To: [login to unmask email]
Subject: [DB2-L] - Database exception table (DBET) log record register information



As per the IBM manuals, Database exception table (DBET) log records hold information about RESTRICTED status, SYSCOPY recovery information etc.

Can someone provide more information on this. Like how is this information stored, can we read information stored in this table/register?

There is not much information available in manuals about Database exception table (DBET) register.

I could only find this link which has very little information :https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/admin/src/tpc/db2z_exceptiontablerecord.html

Thanks in advance.



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

Attachments

  • smime.p7s (5.1k)

Sumit Sharma

RE: Database exception table (DBET) log record register information
(in response to Roy Boxwell)

Hi Roy,

Thanks for you response. I am actually looking for information on image copy of special tables like SYSCOPY. 

Manual says that it stores information regarding image copies of special table spaces. Can we somehow read those image copy entries ? 

Thanks.

steen rasmussen

Database exception table (DBET) log record register information
(in response to Sumit Sharma)
Instead of doing a -DIS DB(*) SPACE(*) LIMIT(*), you could add RESTRICT to limit the amount of output.
Steen Rasmussen
On Wednesday, September 4, 2019, 09:33:39 AM EDT, Sumit Sharma <[login to unmask email]> wrote:


Hi Roy,

Thanks for you response. I am actually looking for information on image copy of special tables like SYSCOPY. 

Manual says that it stores information regarding image copies of special table spaces. Can we somehow read those image copy entries ? 

Thanks.

Site Links: View post online   View mailing list online   Start new thread via email   Unsubscribe from this mailing list   Manage your subscription  

This email has been sent to: [login to unmask email]
Discover the best cloning tool on the market. Try BCV5 & the new BCV5 Masking Tool.
ESAi also has powerful solutions for Buffer Pool Tuning, Log Analysis, TDM, & more.
http://www.ESAIGroup.com/idug



Use of this email content is governed by the terms of service at:
http://www.idug.org/p/cm/ld/fid=2

steen rasmussen

Database exception table (DBET) log record register information
(in response to Sumit Sharma)
Instead of doing a -DIS DB(*) SPACE(*) LIMIT(*), you could add RESTRICT to limit the amount of output.
Steen Rasmussen
On Wednesday, September 4, 2019, 09:33:39 AM EDT, Sumit Sharma <[login to unmask email]> wrote:


Hi Roy,

Thanks for you response. I am actually looking for information on image copy of special tables like SYSCOPY. 

Manual says that it stores information regarding image copies of special table spaces. Can we somehow read those image copy entries ? 

Thanks.

Site Links: View post online   View mailing list online   Start new thread via email   Unsubscribe from this mailing list   Manage your subscription  

This email has been sent to: [login to unmask email]
Discover the best cloning tool on the market. Try BCV5 & the new BCV5 Masking Tool.
ESAi also has powerful solutions for Buffer Pool Tuning, Log Analysis, TDM, & more.
http://www.ESAIGroup.com/idug



Use of this email content is governed by the terms of service at:
http://www.idug.org/p/cm/ld/fid=2

Roy Boxwell

Database exception table (DBET) log record register information
(in response to Sumit Sharma)
That is not stored in the dbet - database exception table. Image Copies are not an exception!

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 4 Sep 2019, at 15:33, Sumit Sharma <[login to unmask email]> wrote:
>
> Hi Roy,
>
> Thanks for you response. I am actually looking for information on image copy of special tables like SYSCOPY.
>
> Manual says that it stores information regarding image copies of special table spaces. Can we somehow read those image copy entries ?
>
> Thanks.
>
>
> Site Links: View post online View mailing list online Start new thread via email Unsubscribe from this mailing list Manage your subscription
>
> This email has been sent to: [login to unmask email]
> Discover the best cloning tool on the market. Try BCV5 & the new BCV5 Masking Tool.
> ESAi also has powerful solutions for Buffer Pool Tuning, Log Analysis, TDM, & more.
> http://www.ESAIGroup.com/idug
>
>
> Use of this email content is governed by the terms of service at:
> http://www.idug.org/p/cm/ld/fid=2
>
Attachments

  • smime.p7s (3.9k)

Sumit Sharma

RE: Database exception table (DBET) log record register information
(in response to Roy Boxwell)

I am wondering where Db2 will store image copy dataset information for syscopy table. Any idea?

David Baldon

Database exception table (DBET) log record register information
(in response to Sumit Sharma)
It’s stored in the DB2 log. Use the DSN1LOGP utility to print record type x’0004’. If you have access to IDUG archives you can check out my 2016 session A8, What’s Log Got To Do, Got To Do With It? It isn’t just about SYSCOPY in the log but it is covered enough to get you started.

...David

From: Sumit Sharma <[login to unmask email]>
Sent: Wednesday, September 4, 2019 12:02 PM
To: [login to unmask email]
Subject: [EXTERNAL] [DB2-L] - RE: Database exception table (DBET) log record register information


I am wondering where Db2 will store image copy dataset information for syscopy table. Any idea?

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

Chris Tee

Database exception table (DBET) log record register information
(in response to Sumit Sharma)
Sumit

It's stored in the log.

regards

Chris

________________________________
From: Sumit Sharma <[login to unmask email]>
Sent: 04 September 2019 18:01
To: [login to unmask email] <[login to unmask email]>
Subject: [DB2-L] - RE: Database exception table (DBET) log record register information


I am wondering where Db2 will store image copy dataset information for syscopy table. Any idea?

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