Tablespace for PSA table

[Former Member]

How to find the PSA table belongs to which Tablespace in DB02?

[Former Member · Accepted solution]

Hi Saurabh,

The PSA tablespaces are PSAPODSD and PSAPODSI.

Attributes of PSA tables can be maintained using DB storage parameters while defining transfer rules (<Extras> menu, 'Maintain database storage parameter' function).

You can check the size of the tablespace(s) in DB02, the PSA tablespace is typically named PSAPODS* (please verify). If you are looking at individual PSA table, check its technical attributes in SE11 (table type) to get the tablespace.

Thanks

CK

PSAPODS*

[Former Member · Accepted solution]

Hi Chitrarth,

I got the PSA table name from RSA1, verified it in SE11; it exists.

In DB02 -> Current Sizes -> which Tablespace should be selected for our PSA table?

[Former Member · Accepted solution]

Hi,

Go to se11 and put your PSA Table name and then display, in the display screen there is a techincal attributes (table type), in that you can find tablespace name.

thanks

CK

null

[Former Member · Accepted solution]

Hi,

I cannot find PSAPODS as tablespace, which is applicable for 2004s

I am using version 3.5

[Former Member · Accepted solution]

No PSAPODSD is applicable in BW 3.x also.

Check with your BASIS guys as well.

Also , if you just intend to know details about your PSA Table, use SE14 where you can see all DB parameters and change them if needed.

Thanks

CK

Message was edited by:

Chitrarth Kastwar