db2 12 dfor z/os - catmaiont 500; function level 100; missing TS?

Chris Hoelscher

db2 12 dfor z/os - catmaiont 500; function level 100; missing TS?
I am upgrading to db2 12
I ran JTC rc=0
I attempted to build my DSN1COPY jcl based on the post-catmaint catalog
DBT3S.DSNDBC.DSNDB06.SYSTSADH..... doesn't seem to exist, but it's in the catalog

Are sometablespaces defined but not created during catmaint 500?
Is a space of zero a good determinate as to whether they physically exist?

Thank You,
Chris Hoelscher| Lead Database Administrator | IBM Global Technical Services| T 502.476.2538 or 502.407.7266

Michael Hannan

RE: db2 12 dfor z/os - catmaiont 500; function level 100; missing TS?
(in response to Chris Hoelscher)

Chris,
 

From the SQL Manual:

"SYSTSADH     SYSAUDITPOLICIES_H     —       Not used."

So we see table name and Not Used. I would probably try to SELECT from it, to see if it is "there" yet, if SELECTs can be run.

I sort of get your point though about Space of 0. I guess you are saying the dataset is not there.

Michael Hannan,
DB2 Application Performance Specialist
CPT Global Ltd

Edited By:
Michael Hannan[Organization Members] @ Feb 13, 2020 - 11:09 PM (Europe/Berlin)
Michael Hannan[Organization Members] @ Feb 13, 2020 - 11:11 PM (Europe/Berlin)
Michael Hannan[Organization Members] @ Feb 13, 2020 - 11:12 PM (Europe/Berlin)

steen rasmussen

db2 12 dfor z/os - catmaiont 500; function level 100; missing TS?
(in response to Michael Hannan)
There are a lot of _H tables - getting ready for autonomic auditing using system time temporal tables

Steen

Sent from my iPhone

> On Feb 13, 2020, at 5:04 PM, Michael Hannan <[login to unmask email]> wrote:
>
> Chris,
>
>
> From the SQL Manual:
>
> "SYSTSADH SYSAUDITPOLICIES_H — Not used."
>
> So we see table name and Not Used. I would probably try to SELECT from it, to see if it is "there" yet.
>
> Michael Hannan,
> DB2 Application Performance Specialist
> CPT Global Ltd
>
>
> 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]
> Try BCV5, the BCV5 Masking Tool, & XDM a rapid Refresh/Clone/TDM Suite for Db2 z & distributed.
> DBARS -Audit,record,& block Db2 accesses to sensitive data real-time, NO audit trace or log required
> 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
>

James Campbell

RE: db2 12 dfor z/os - catmaiont 500; function level 100; missing TS?
(in response to steen rasmussen)

The _H tablespaces are all DEFINE NO.  When rows are inserted, the clusters (no indexes) will be created.  The Technical Overview says "actual system-period data versioning enablement is to be done by the user."

Word of warning.  The tablespaces are not included in DSNTIJIC.  LISTDEF and COPY both handle them if the clusters don't exist.  I have raised a case asking why they are not included. 

James Campbell

In Reply to steen rasmussen:

There are a lot of _H tables - getting ready for autonomic auditing using system time temporal tables

Steen

Sent from my iPhone

> On Feb 13, 2020, at 5:04 PM, Michael Hannan <[login to unmask email]> wrote:
>
> Chris,
>
>
> From the SQL Manual:
>
> "SYSTSADH SYSAUDITPOLICIES_H — Not used."
>
> So we see table name and Not Used. I would probably try to SELECT from it, to see if it is "there" yet.
>
> Michael Hannan,
> DB2 Application Performance Specialist
> CPT Global Ltd
>
>
> 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]
> Try BCV5, the BCV5 Masking Tool, & XDM a rapid Refresh/Clone/TDM Suite for Db2 z & distributed.
> DBARS -Audit,record,& block Db2 accesses to sensitive data real-time, NO audit trace or log required
> 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
>