OnDemand User Group

Support Forums => MP Server => Topic started by: tabuhr on May 16, 2011, 09:53:05 AM

Title: Looking for data in DB2 tables
Post by: tabuhr on May 16, 2011, 09:53:05 AM

If I want to know what application groups are included in each group, what internal DB2 tables, would I find this data?

Title: Re: Looking for data in DB2 tables
Post by: Michel de Kraker on May 16, 2011, 12:24:39 PM

Hi,

In the application group, tab storage , advanced you see on top of the screen your db2 table name.
In db2 you can query :

select * from <instanceowner>.db2 tablename

example:

select * from root.YDK1

with describe table root.YDK1 you can see all the fields

Kind regards,

Michel.

Title: Re: Looking for data in DB2 tables
Post by: Alessandro Perucchi on May 16, 2011, 10:47:39 PM

Hello,

just a precision from the post of Michel, you can only do that (the "select" and the "describe table") if you have at least done a load of a document in this application group, otherwise CMOD won't even create the table.

Cheers,
Alessandro