implicitly created object enhancement

For costumers with strong naming convention in object creation, it would be useful to define a template, which will be used to create implicit objects.

In our case, we are affected by implicit created LOB tables of PbG tablespaces:

Base objects:

CREATE
 TABLESPACE STKEH25
	IN DTKEH
	USING STOGROUP DEKED201
	PRIQTY -1
	SECQTY -1
	ERASE NO
	FREEPAGE 0
	PCTFREE 0
	GBPCACHE CHANGED
	COMPRESS YES
	TRACKMOD YES
	LOGGED
	DSSIZE 64 G
	SEGSIZE 32
	MAXPARTITIONS 32
	BUFFERPOOL BP32K
	LOCKSIZE ROW
	LOCKMAX SYSTEM
	CLOSE NO
	CCSID EBCDIC
	MAXROWS 255
	INSERT ALGORITHM 0
;

 CREATE TABLE
   KET.TKEH25
	(
	ID   BIGINT NOT NULL
   ,SOME_TEXT   CLOB(2000 K) NOT NULL
	 INLINE LENGTH 25000
	 FOR SBCS DATA
	,
	 CONSTRAINT PK_TKEH25
	 PRIMARY KEY
	 (
	  ID
	 )
	)
	 IN DTKEH.STKEH25
	 WITH RESTRICT ON DROP
	 CCSID EBCDIC
	 NOT VOLATILE
	 APPEND NO
	 NO KEY LABEL
 ;

Created Lob objects for part 1:

 CREATE
   LOB TABLESPACE STKEH251
	 IN DTKEH
	 USING STOGROUP DEKED201
	 PRIQTY -1
	 SECQTY -1
	 ERASE NO
	 GBPCACHE CHANGED
	 COMPRESS YES
	 LOGGED
	 DSSIZE 8 G
	 BUFFERPOOL BP32K
	 LOCKSIZE LOB
	 LOCKMAX 0
	 CLOSE NO
 ;

 CREATE AUXILIARY TABLE
	 KET.TKEH251
	 IN DTKEH.STKEH251
	 STORES KET.TKEH25
	 APPEND NO
	 COLUMN SOME_TEXT
	 PART 1
 ;

If base tb grows and a further part is allocated, also a new LOB TS and LOB TB will be created, which does not fit our naming convention:

DB: DTKEH
TS: DTKEH.STKEH25
TB: KET.TKEH25
LOBTS Part1: DTKEH.STKEH251
Lob Part1: KET.TKEH251

In our case, completely random

Tablespaces:
 
DTKEH.LZ8TIZXS
DTKEH.LZ8YFRMH
DTKEH.LZ8ZOEJS
DTKEH.LZ83MHU0
DTKEH.LZ88SJZN
DTKEH.L1TBY7U4
DTKEH.L1TXXBEY
DTKEH.L3DG8YO2
DTKEH.L3DLN8CG
DTKEH.L4DJFU1T
DTKEH.L51T1KCP
 
Tables:
 
KET.TKEH2GEGENZ8TI3P6A
KET.TKEH2GEGENZ8YF2B3Y
KET.TKEH2GEGENZ8ZOHZDA
KET.TKEH2GEGENZ83MMO0A
KET.TKEH2GEGENZ88STCYX
KET.TKEH2GEGEN1TBY9S5B
KET.TKEH2GEGEN1TXXJI8L
KET.TKEH2GEGEN3DG859WL
KET.TKEH2GEGEN3DLNX2HB
KET.TKEH2GEGEN4DJF0RD0
KET.TKEH2GEGEN51T1TGRB

A suggestion would be to introduce a new TS and TB creation parameter for new objects, containing variables which will be taken to create new objects:

&TABLE.

&TABLESPACE.

&PART.

Thomas