J2ee Schema on WAS

[Former Member]

How can i check the tables and their respective sizes of the j2ee schema in WAS?

We have 640 SR1 with XI installed. and I was doing some archiving and ran into a question from functional folks saying the Adpater engine XML need to be archived as well!

Anyone know how to look at tables in j2ee schema?

thanks

tony

[Former Member]

You can try brspace -f dbshow -c tbinfo

If you post the particular database you're using there are DB specific ways of getting at the info also (.i.e OEM in Oracle, Enterprise Manager in SS, DBM for SAPDB)

[Former Member]

my db is oracle. how can see the j2ee schema in oracle, pls let me know.

[Former Member]

Hi Tony,

I'll assume you're on 9i.

1) as ora<SID>

sqlplus '/ as sysdba'

2) Figure out who your schema owner is:

select username from dba_users;

--It's 1 of 2 schemas in there. Post your results here and I can tell you which 1 it is.

3) This query assumes you have collected statistics for you tables:

select table_name, bytes, blocks from dba_tables where owner = '<SCHEMA>' order by table_name;

<SCHEMA> is the schema owner obtained from step 2.

You can also spool the report to save it to a file. You can use the sqlplus col comand to format the columns of the output...

[Former Member]

hi somckit,

the username in DB are as follows:

USERNAME

-

---

SYS

SYSTEM

OUTLN

DBSNMP

OPS$XSDADM

SAPEXI

SAPXSDDB

OPS$ORAXSD

PERFSTAT

i executed the SQL provided by you but it doesn't give me the j2ee schema. I would think j2ee table to be owned by j2ee_*

thx

tony

[Former Member]

Example output:

SQL*Plus: Release 9.2.0.5.0 - Production on Fri Jul 8 10:27:38 2005

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to:

Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit Production

With the Partitioning option

JServer Release 9.2.0.5.0 - Production

SQL> select username from dba_users;

USERNAME

-

---

SYS

SYSTEM

OUTLN

DBSNMP

OPS$ORASID

OPS$SIDADM

SAPSID

SAPSIDDB

8 rows selected.

--Your J2EE schema owner is the SAP<SID>DB id.

SQL> select table_name, blocks, (blocks * 8192) bytes from dba_tables where owner = 'SAPSIDDB' and rownum < 10 order by blocks desc;

TABLE_NAME BLOCKS BYTES

-

---

-

---

-

---

BC_DDDBRTX 244 1998848

BC_DDDBTABLERT 65 532480

BC_JMSTOPIC 20 163840

BC_COMPVERS 13 106496

BC_DDDBRTH 5 40960

BC_JMSTOPICSUB 5 40960

BC_JMSQUEUE 5 40960

BC_CVERS 0 0

BC_JMSDMSGQ 0 0

9 rows selected.

--Remove the order by clause to see more rows

--If you get no data then you'll have to gather statistics

exec dbms_stats.gather_schema_stats('SAPSIDDB');

You should be gathering statistics for your tables anyways...

[Former Member]

hi

thanks for your reply. I was able to get 9 rows as well.

but this still doesn't answer my question. The j2ee schema is part of the database. By doing a select for the 'SAPSIDDB' we are saying that j2ee schema owner is also 'SAPSIDDB'. This means that j2ee schema and ABAP schema are owned by 'SAPSIDDB'.

But how do i know which are the j2ee schema tables. the reason for knowing this is the following:

in XI, i am able to delete XML msgs from the Adapter Engine on the java side but they don't get deleted from ABAP side. I can see them in 'IDX5' but in the URL

http://<hostname>:j2ee_port/MessagingSystem/reorgdb.jsp

i am able to delete the msgs from j2ee schema.

So i am confused of how the database is working.

Do you know i can use something like a Enterprise Manager for connecting to oracle database from my machine to a server. is this possible. Maybe i am able to see two schemas this way.

thanks

tony

[Former Member]

"but this still doesn't answer my question. The j2ee schema is part of the database. By doing a select for the 'SAPSIDDB' we are saying that j2ee schema owner is also 'SAPSIDDB'. This means that j2ee schema and ABAP schema are owned by 'SAPSIDDB'.

But how do i know which are the j2ee schema tables. the reason for knowing this is the following:

in XI, i am able to delete XML msgs from the Adapter Engine on the java side but they don't get deleted from ABAP side. I can see them in 'IDX5' but in the URL

http://<hostname>:j2ee_port/MessagingSystem/reorgdb.jsp

i am able to delete the msgs from j2ee schema.

So i am confused of how the database is working."

The ABAP schema owner is SAPSID the J2EE schema owner is SAPSIDDB.

In XI the J2EE schema is really only used during the development phase. The XI runtime is all in the ABAP engine. Your Integration Engine pipeline (LTM) is all in your ABAP engine. I hope that clears some of this up. If you need more XI specifif info you can post in the XI forum also...

[Former Member]

hi Somckit,

thanks for your reply. This clears things up!!