Tablespace VSAM dataset creation timestamp

Bharath Nunepalli

Tablespace VSAM dataset creation timestamp

Hi all,

When a tablespace is created with DEFINE NO, underlying VSAM dataset will not be created immediately. It'll be created when data is loaded in to the table.

One way of finding the timestamp for VSAM dataset creation is to look for ICTYPE='C' entry for the tablespace in SYSCOPY.

Does any other Db2 catalog table record the timestamp of tablespace VSAM dataset creation?


Bharath Nunepalli,

Senior DB2 DBA.

Jack Campbell

RE: Tablespace VSAM dataset creation timestamp
(in response to Bharath Nunepalli)

Try running LISTCAT for the underlying VSAM LDS, look for CREATION, convert Julian to Gregorian date

 

CLUSTER ------- <VSAM CLUSTER NAME>
     IN-CAT --- AUSERCAT.DBP1                                    
     HISTORY                                                     
       DATASET-OWNER----SYSADM1     CREATION--------2020.166     
       RELEASE----------------2     EXPIRATION------0000.000     

HTH

Jack

Roy Boxwell

Tablespace VSAM dataset creation timestamp
(in response to Bharath Nunepalli)
Not that I know of in Db2...CREATEDTS is when you ran the DDL of course...

Roy Boxwell
SOFTWARE ENGINEERING GmbH and SEGUS Inc.
-Product Development-
Vagedesstrasse 19
40479 Dusseldorf/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 https://www.seg.de/corporate/rechtliche-hinweise/datenschutz

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

On 19 Jun 2020, at 17:13, Bharath Nunepalli <[login to unmask email]> wrote:



Hi all,

When a tablespace is created with DEFINE NO, underlying VSAM dataset will not be created immediately. It'll be created when data is loaded in to the table.

One way of finding the timestamp for VSAM dataset creation is to look for ICTYPE='C' entry for the tablespace in SYSCOPY.

Does any other Db2 catalog table record the timestamp of tablespace VSAM dataset creation?


Bharath Nunepalli,

Senior DB2 DBA.

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

Bharath Nunepalli

RE: Tablespace VSAM dataset creation timestamp
(in response to Jack Campbell)

Jack,
I'm aware of LISTCAT.

I'm just curious whether VSAM dataset creation timestamp info is available in Db2 catalog tables also, besides SYSCOPY.


Bharath Nunepalli,

Senior DB2 DBA.

Bharath Nunepalli

RE: Tablespace VSAM dataset creation timestamp
(in response to Roy Boxwell)

CREATEDTS in SYSTABLESPACE provides the tablespace creation time, but not the VSAM dataset creation time.
TIMESTAMP column in SYSCOPY provides that info for the entry ICTYPE='C'

I want to know whether this info is recorded in any other Db2 catalog table or not.

 

Bharath Nunepalli,

Senior DB2 DBA.

alain pary

RE: Tablespace VSAM dataset creation timestamp
(in response to Bharath Nunepalli)

Hello, 

You can make the action to create physically the VSAM. and check with a log product , if some catalog tables are updated during this time slot.  

regards 

Alain 

J&#248;rn Thyssen

RE: Tablespace VSAM dataset creation timestamp
(in response to alain pary)

I see the following changes:

  • Insert on SYSCOPY (the row for creation of the VSAM cluster)
  • Insert on SYSTABLESPACESTATS (initialization of RTS)
  • Update on SYSTABLEPART (initialization columns SPACE and RBA_FORMAT)


In Reply to alain pary:

Hello, 

You can make the action to create physically the VSAM. and check with a log product , if some catalog tables are updated during this time slot.  

regards 

Alain 



 

Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email] • W: www.rocketsoftware.com 

2020 IBM Champion.

Views are personal. 

Bharath Nunepalli

RE: Tablespace VSAM dataset creation timestamp
(in response to Jørn Thyssen)

in SYSCOPY, we can for sure say that the timestamp is for VSAM creation based on ICTYPE='C'

In SYSTABLESPACESTATS, I don't think we can say for sure that the UPDATESTATSTIME is the timestamp is for VSAM creation


Bharath Nunepalli,

Senior DB2 DBA.