Skip to Content
avatar image
Former Member

sapstar reset in sybase ase

Hi All,

FYI.

In order to delete sap* from USR02

isql -Usapsa -SSID -w2000

Password:

1> use SID

2> go

1> select top 1 * from SAPSR3.USR02

2>go

1>select * from SAPSR3.USR02 where BNAME='SAP*'

2>go

1> delete from SAPSR3.USR02 where BNAME='SAP*'

2> go

We can now go ahead restart the sap system for the recreation of sap*.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jul 17, 2012 at 12:42 PM

    How do you connect to isql in windows?.

    We have installed the system using sapinst but unable to find any programs in start menu.

    dbisql.exe is available in the bin folder.If i execute the same i get the isql gui console.But how do you login ? can we use <sid>adm to login?.

    Thanks

    dev

    Add comment
    10|10000 characters needed characters exceeded

    • hi,

      Even in windows its available. During installation with sapinst nothing comes in the start menu programs. These are independent .exe files which can be used to start the control center.

      "\Sybase\SED\Shared\Sybase Central 6.0.0\win64"

      regards,

      dev