Portal - Tablespaces

[andrewscott9]

Hi,

I have only been in a Basis role for a few months, so please bear with me.

I can see all the table spaces and their associated datafiles and sizes using DB02

for all the ABAP stack systems.

However, I need to see the same results for the Portal JAVA base systems. I know there

is no SAP GUI for these systems so I can't use DB02.

I'm presuming there are some SQL statements which will show me the same thing?

Can anyone help me out?

Thanks

Andy

[Former Member · Accepted solution]

Hi Andy,

Just to add regarding Java tables, there is tool which will be like SE16 where we can manage Java tables.

[http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/b0c8e229-7322-2b10-f5b3-e6cefa0405fc?QuickLink=index&overridelayout=true]

Regards,

Venkata S Pagolu

[nicholas_chang]

Hi Andy,

BRTOOLS is another good tools to monitor and check the db size, datafiles and tablespaces.

Cheers,

Nicholas Chang

[andrewscott9]

Many thanks for all the suggestions.

It is much appreciated

Thanks

Andy

[Former Member]

Hi Andy,

Use DBACOCKPIT for Java Stack systems to have a similar look and feel of DB2 in ABAP stack. Connect your java stack database to your Solution Manager system.

Follow this procedure for configuring it.

Note 1261329 - DBA Cockpit: Oracle as a remote database

Br,

Venky

[andrewscott9]

Thankyou very much Venky. Much appreciated

[former_member184473]

Hello Andy,

You can query the dba_data_files:

select * from dba_data_files where tablespace_name='<tablespace_name>';

Regards,

Eduardo Rezende

[andrewscott9]

Thanks mate, much appreciated