cancel
Showing results for 
Search instead for 
Did you mean: 

Check tables size of Java schema

Former Member
0 Kudos

Hi,

I have a problem with the DB (MAXDB) size growth in a dual stack. I can find the size of the tables for ABAP schema from using GUI. Now I need to find the largest and greatest growth tables from java schema.

I found in one of the thread to use the following

DB59

- Add you J2EE schema (SAP<SID>DB)

- execute program RSADAT6M

but I am not able to add java schema and to execute the above program.

I am looking for a solution to find the largest and greatest growth tables from java schema.

Thanks and regards,

sen

Accepted Solutions (0)

Answers (1)

Answers (1)

lbreddemann
Active Contributor
0 Kudos

> I found in one of the thread to use the following

>

> DB59

> - Add you J2EE schema (SAP<SID>DB)

> - execute program RSADAT6M

>

> but I am not able to add java schema and to execute the above program.

Why can't you do that?

It's the way it's meant to be done...

Do you get any error messages?

> I am looking for a solution to find the largest and greatest growth tables from java schema.

There isn't any prebuild way for that, except the one mentioned above.

Storing data growth information, monitoring database instances, etc. is exactly what the CCMS is made for.

So why don't you just use it?

regards,

Lars

Former Member
0 Kudos

Hi Lars,

Thanks for the reply, I was following the above details but i can't find the way to add the JAVA schema SAP<SID>DB under DB59.

It will be very helpful if you can give me some more info.

Regards,

Senpai

lbreddemann
Active Contributor
0 Kudos

> Thanks for the reply, I was following the above details but i can't find the way to add the JAVA schema SAP<SID>DB under DB59.

>

> It will be very helpful if you can give me some more info.

DB59 -> Integrate Database -> enter DB Connection Name and check "MaxDB".

After that you have to enter:

Database name

Server

DBMUser and Password (that's CONTROL in SAP databases).

and finally

Standard Database User

That's where you enter the SAP<SID>DB.

That's it.

Former Member
0 Kudos

Hi Lars,

It works thanks a lot for your help

Regards,

Senpai