sap sybase space issue

[Former Member]

Hi friends,

i am facing space issue. out database is sybase. Its in vmware. I have knowledge in orace .where archive files stored etc but i am new to sybase database. my sybase folder is filled almost 97% and i want to clear archive logs etc but i have no idea what files i have to remove etc please guide me regarding on this i am attaching the screen shots of sm21 logs and vmware memory related screen for your reference please help me.

Best regards,

venkat

[Johan_sapbasis]

Hi Nanjundiah,

First things first you screenshot has too many screens therefore not legible.

Secondly can you see in DBACOKCPIT what is full?

1. Run tcode /ndbacockpit

2. Click on Database SID tab

3. Click on the Space tab and select what you want to see. filesystems/devices/databases check free space on all of these.

This could also depend on which level of DBA cockpit correction notes you have implemented.

Please advise with a bit more detail.

Kind Regards,

johan

[former_member142598]

Hello Venkat,

Sybooks manuals are good reference. The best way to alter Sybase database spaces is using DBACockpit. We advise folks to use DBACockpit for database maintance and ATM. Can you please try to log on DBA Cockpit to alter database space?

Also binding user tempdbs to sapsa, SAPSR3 are good idea too.

Do you have access to SMP? If yes, there are a couple of KBAs for you.  I will paste another KBA on education for you here. KBA 2135202

KBA 1836607, 2006899 are for DBA cockpit.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/00a022d1-dce2-2e10-e687-f4903ed95...

Hope this helps,

Gek