Read DBTABLOG table

[Former Member]

Hi Folks,

I want to read DBTABLOG table, basically want to extract data of field LOGDATA.

So please let me know how I can read this field.

Regards,

Amey

[Former Member]

hi,

do as follows:

select logdata from DBTABLOG where logdata = sy-datum

and TABNAME = give the table name.

thanks,

anupama.

[Former Member]

I guess there is FM for this check with APPlog* in SE37, my system is not working so sorry for asking you to check

[Former Member]

Hi,

READ table DBTABLOG with key LOGDATE.

Regards,

jaya

[Former Member]

USE FM : DBLOG_READ ...

for more info search SCN ...

[Former Member]

Hi,

By using this...

db2 "select SUBSTR(TBSPACE,1,10) AS TABLESPACE, sum(CARD) as CARD, sum(NPAGES) as NPAGES, sum(FPAGES) as FPAGES from syscat.tables where TBSPACEID = 14 group by TBSPACE"

Thanks,

Neelima.