topic Re: Read DBTABLOG table in Application Development and Automation Discussions

Read DBTABLOG table

Former Member — Fri, 27 Feb 2009 07:14:26 GMT

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

Re: Read DBTABLOG table

Former Member — Fri, 27 Feb 2009 07:17:38 GMT

hi,

do as follows:

select logdata from DBTABLOG where logdata = sy-datum

and TABNAME = give the table name.

thanks,

anupama.

Re: Read DBTABLOG table

Former Member — Fri, 27 Feb 2009 07:18:12 GMT

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

Re: Read DBTABLOG table

Former Member — Fri, 27 Feb 2009 07:21:15 GMT

Hi,

READ table DBTABLOG with key LOGDATE.

Regards,

jaya

Re: Read DBTABLOG table

Former Member — Fri, 27 Feb 2009 07:29:12 GMT

USE FM : DBLOG_READ ...

for more info search SCN ...

Re: Read DBTABLOG table

Former Member — Fri, 27 Feb 2009 07:33:29 GMT

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.