database administration alert

[Former Member]

Hi

here i am posting the issue as below:

BR970W Database administration alert - level: WARNING, type: CRITICAL_SEGS, object: (table) SAPR3./BMC/YGR_AVAILAB, value: 640 K

as i checked with SAPDBA -f, i am getting an error

a - Tablespace: PSAPYBMCD

b - Log checks: no

c - Free space and fragmentation of all tablespaces

d - Check free space of objects in all tablespaces

e - Check free space of objects in tablespace PSAPYBMCD

f - Alter tablespace PSAPYBMCD add data/temp file

g - Drop tablespace PSAPYBMCD

h - Display all tablespaces and data/temp files

r - Display raw device drivers in /dev

q - Return

Please select ==> f

SAPDBA: Error getting file system space information of

'/oracle/sid/sapdata7'.

(Such entry does not exist.)

Press <return> to continue ...

as i checked.............

bdf | grep /oracle/sid

/oracle/SID/sapdata1

so my Q is how to change the filesystem to /oracle/SID/sapdata1 from sapdata7.

sap : 4.6c

oracle : 9.2.0.8.0

os : hp-ux

so can anyone help me in changing the filesystem path?

Thanks in advances

[Former Member · Accepted solution]

Hi,

It seems that environment variable SAPDATA<n> are not comfiture properly?

But why don’t use brspace?

e.g. +brspace –f tsextend -t PSAPYBMCD -f SAPDATA1 -s <size>+

Nahum

[Former Member · Accepted solution]

Thanks,

i chedked brspace not found

still any other alternate to

[Former Member · Accepted solution]

brspace is part of BRTools 6.40, you should download BRTools 6.40 from Market Place

You probably use old BR*Tools, 6.20?

Nahum

[former_member204746 · Accepted solution]

what are your environement parameters? if you have SAPDATA1 and others, delete SAPDATA7.