sapstar reset in sybase ase

[Former Member]

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*.

[sukhdev_kaloor]

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

[JanStallkamp]

Hi.

The graphical dbisql is one way to connect to Sybase ASE, another one is using the isql command running in the terminal. You can use any of the database users created during installation. The SAP-system is running as user 'SAPSR3', the super user is the 'sapsa'.

The user <sid>adm is an operating system user, not a database user.

Regards,

Jan

[sukhdev_kaloor]

Thx Jan,

Is there any graphical console for database management other than going thru SAP transactions.

Similar to MSSQL enterprise manager or Db2 control center does sybase have any option?. Do we need to download and install anything additional.

Thx,

Dev

[Former Member]

Hi Sukhdev,

Yes we do have sybase control center.

Path,

/sybase/SID/shared/sybcentral600/scjview.sh

I think this has already been mentioned in the other questions.

[sukhdev_kaloor]

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