Skip to Content
avatar image
Former Member

sap sybase space issue

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

Untitled.png (534.1 kB)
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Jun 08, 2015 at 09:35 AM

    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


    DBACockpit.jpg (18.5 kB)
    Add comment
    10|10000 characters needed characters exceeded

  • Jun 04, 2015 at 08:05 AM

    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-f4903ed95a54?QuickLink=index&…

    Hope this helps,

    Gek

    Add comment
    10|10000 characters needed characters exceeded