help on import & export statement in moni table

[Former Member]

hi,

thanks poornanand mandalika , serdar simsekler for providing help on moni table.

now here is same more research on cluster data

1. can we convert the import and export statement to simple select statement to extract data from moni table, thing is that i want to write report which extract data from moni as how import and export does?

2. we have different cluster id such as DD,HK,... etc can you tell what this id means and how data store in cluster table.

thanks,

john

[Former Member]

hi,

thanks poornanand mandalika , serdar simsekler for providing help on moni table.

now here is same more research on cluster data

1. can we convert the import and export statement to simple select statement to extract data from moni table, thing is that i want to write report which extract data from moni as how import and export does?

2. we have different cluster id such as DD,HK,... etc can you tell what this id means and how data store in cluster table.

thanks,

john

[Former Member]

Hi,

Take a look at . See if it helps.

Regards

[Former Member]

Hello John,

Here are the answers:

1. No. You cannot use a simple SELECT statement on a cluster database. I mean, you will not get anything meaningful out of doing so (though it is syntactically possible).

2. The two-character ID that you are talking about is a way of segregating the related information in a (any)

cluster table. You would have to specify that, because it is a mandatory part of the syntax for the IMPORT statement.

Coming to understanding the way data is stored, when the data was entered into the cluster table, it would have been done through an EXPORT statement. You will need to find out where that EXPORT statement was issued, and use the similar structure for the data recepients in the IMPORT statement.

In a way, you can say that a cluster table can store data of any format(line-type) unlike an ordinary database table which has a particular structure , as defined in the data-dictionary (SE11). And this data is actually stored in the LRAW field of the table in a compressed format.

For more information on MONI and Cluster tables, please search the forum for these keywords. there have been quite a lot of discussions in the past on these topics.

Regards,

Anand Mandalika.

[Former Member]

BTW, why is this topic not marked as a question ?