Content Server - Which SQL statements are running?

[Former Member]

Hi sap lovers! Does anyone aware of which sql statements being run on the maxDB part when, e.g saving a document (or retrieving a document) (on the ABAP part) within our DMS landscape?

And at the whole, Is It possible to monitor sqls running on MAXDB, like we can see in ST04

-> Oracle Session

Regards,

Vladimir

[markus_doehr2 · Accepted solution]

You can find that out doing the following:

- on any ABAP system start DB59

- enter the data to connec to the content server database

- doubleclick on the made entry so you get in "DB50 for remote databases"

- switch on the command monitor

- then use the task manager and press on "running commands"

Markus

[Former Member · Accepted solution]

Dear Markus,

we are working on the oracle DB, and Content Server as of Document Management System.

In DB59 I have failed with setting remote MAXDB, all test sais following:

"no_client_software"

In fact I thought, there exist some OS maxdb utils, to solve the subject.

Regards,

Vladimir

[Former Member · Accepted solution]

Hi,

use sapnote 649814 to install the MaxDb Client Software on the applicationserver. After you installed the client software it should be possible to use DB59 on an Oracle system to connect a MaxDB Content Server.

Regards, Christiane

[Former Member · Accepted solution]

thanks, I'll try