Hi,
I have a problem with the NumericString (N) attributes.
I want 64-bit Oracle tablespace monitor, for this I created a. mdl receiving information of an Oracle table. TABLESPACE_SIZE column shows the tablespace size in bits and TABLESPACE_USED_SIZE column shows the occupation of the tablespace in bits.
I need to get the percentage of tablespace used for this purpose I have defined a new attribute called PERCENT. The .mdl is validated correctly, but TEP does not show any data in column PERCENT.
Can anyone help? What is happening?
I attached screenshot of TEP.
The. MDL is:
//APPL EMREP102
//NAME MGMT$DB_TABLESPACES_ALL K 300
//SOURCE ODBC EMREP102 user=xxxxxx pswd=xxxxxx
//SQL Select * from SYSMAN.MGMT$DB_TABLESPACES_ALL
//ATTRIBUTES
HOST_NAME D 256
SNAPSHOT_GUID D 16
TARGET_NAME D 256 Key Atomic
TARGET_TYPE D 64
TARGET_GUID D 16
COLLECTION_TIMESTAMP D 20 Key Atomic
IS_CURRENT D 4
TABLESPACE_NAME D 32 Key Atomic
CONTENTS D 12
STATUS D 12
EXTENT_MANAGEMENT D 12
ALLOCATION_TYPE D 12
LOGGING D 12
TABLESPACE_SIZE N 16
INITIAL_EXT_SIZE N 16
NEXT_EXTENT N 16
INCREMENT_BY N 16
MAX_EXTENTS N 16
TABLESPACE_USED_SIZE N 16
PERCENT N 16 (TABLESPACE_USED_SIZE % TABLESPACE_SIZE)
SEGMENT_SPACE_MANAGEMENT D 8
BLOCK_SIZE N 16
MIN_EXTENTS N 16
MIN_EXTLEN N 16
BIGFILE D 4
C:\IBM\ITM\TMAITM6>kumpcon validate EMREP102.mdl
KUMPS001I ROOTBUNDLE:Console input accepted.
KUMPV025I ROOTBUNDLE:Processing input metafile C:\IBM\ITM\TMAITM6\metafiles\EMREP102.mdl
KUMPV026I ROOTBUNDLE:Processing record 0001 -> //APPL EMREP102
KUMPV148I ROOTBUNDLE:Note: APPL names starting with letters A-M are designated for Best Practices and Business Partner UA solutions.
KUMPV026I ROOTBUNDLE:Processing record 0002 -> //NAME MGMT$DB_TABLESPACES_ALL K 300
KUMPV026I ROOTBUNDLE:Processing record 0003 -> //SOURCE ODBC EMREP102 user=systivoli pswd=systivoli
KUMPV026I ROOTBUNDLE:Processing record 0004 -> //SQL Select * from SYSMAN.MGMT$DB_TABLESPACES_ALL
KUMPV026I ROOTBUNDLE:Processing record 0005 -> //ATTRIBUTES
KUMPV026I ROOTBUNDLE:Processing record 0006 -> HOST_NAME D 256
KUMPV026I ROOTBUNDLE:Processing record 0007 -> SNAPSHOT_GUID D 16
KUMPV026I ROOTBUNDLE:Processing record 0008 -> TARGET_NAME D 256 Key Atomic
KUMPV026I ROOTBUNDLE:Processing record 0009 -> TARGET_TYPE D 64
KUMPV026I ROOTBUNDLE:Processing record 0010 -> TARGET_GUID D 16
KUMPV026I ROOTBUNDLE:Processing record 0011 -> COLLECTION_TIMESTAMP D 20 Key Atomic
KUMPV026I ROOTBUNDLE:Processing record 0012 -> IS_CURRENT D 4
KUMPV026I ROOTBUNDLE:Processing record 0013 -> TABLESPACE_NAME D 32 Key Atomic
KUMPV026I ROOTBUNDLE:Processing record 0014 -> CONTENTS D 12
KUMPV026I ROOTBUNDLE:Processing record 0015 -> STATUS D 12
KUMPV026I ROOTBUNDLE:Processing record 0016 -> EXTENT_MANAGEMENT D 12
KUMPV026I ROOTBUNDLE:Processing record 0017 -> ALLOCATION_TYPE D 12
KUMPV026I ROOTBUNDLE:Processing record 0018 -> LOGGING D 12
KUMPV026I ROOTBUNDLE:Processing record 0019 -> TABLESPACE_SIZE N 16
KUMPV026I ROOTBUNDLE:Processing record 0020 -> INITIAL_EXT_SIZE N 16
KUMPV026I ROOTBUNDLE:Processing record 0021 -> NEXT_EXTENT N 16
KUMPV026I ROOTBUNDLE:Processing record 0022 -> INCREMENT_BY N 16
KUMPV026I ROOTBUNDLE:Processing record 0023 -> MAX_EXTENTS N 16
KUMPV026I ROOTBUNDLE:Processing record 0024 -> TABLESPACE_USED_SIZE N 16
KUMPV026I ROOTBUNDLE:Processing record 0025 -> PERCENT N 16 (TABLESPACE_USED_SIZE % TABLESPACE_SIZE)
KUMPV026I ROOTBUNDLE:Processing record 0026 -> SEGMENT_SPACE_MANAGEMENT D 8
KUMPV026I ROOTBUNDLE:Processing record 0027 -> BLOCK_SIZE N 16
KUMPV026I ROOTBUNDLE:Processing record 0028 -> MIN_EXTENTS N 16
KUMPV026I ROOTBUNDLE:Processing record 0029 -> MIN_EXTLEN N 16
KUMPV026I ROOTBUNDLE:Processing record 0030 -> BIGFILE D 4
KUMPV000I ROOTBUNDLE:Validation completed successfully
KUMPV090I ROOTBUNDLE:Application metafile validation report saved in file C:\IBM\ITM\TMAITM6\metafiles\EMREP102.rpt.
KUMPS065I ROOTBUNDLE:Do you wish to Import or Refresh this metafile? <Import/Refresh/Cancel>
Import
KUMPS084I ROOTBUNDLE:Selecting ODBC DP based on metafile type
KUMPS079W ROOTBUNDLE:Import successful. An APPL name with the same first 3 characters has previously been used by another metafile.
