cancel
Showing results for 
Search instead for 
Did you mean: 

sybase ASE 15.7

Former Member
0 Kudos

Dear Gurus,

I'm new to sybase, I've just installed an ERP  6 EHP 7 on sybase ASE 15.7, I don't know how to start managing it, cannot find any documents that describe the architecture shortly, also I need to know how to manage it either using command line prompt or GUI, for the sake of backup for example.

Thanks in advance

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

Dear M Medhat,

Have a look at the Getting Started Guide , link is on the starting page of the SAP on Sybase .

( direct link http://scn.sap.com/docs/DOC-29524 )

It provides lots of links to relevant documents for a variety of DBA tasks. (amongst other backup and restore)

The command line tool to use is isql of course.

With kind regards

Tilman Model-Bosch

Former Member
0 Kudos

Hello Tilman,

I did read the document you've sent, it just discusses some of the features of the new ASE, While it does not mention how to connect or what commands to use for backup.

My inquiry simply : how to connect using the isql, what commands to run to take the backup.

Thanks in advance

0 Kudos

Dear Mr Medhat,

More detailed instruction may get found in these SAP notes (referenced in the Getting  Started Guide)

1588316 - SYB: Configure automatic database and log backups

1585981 - SYB: Ensuring Recoverability for Sybase ASE

1611715 - SYB: How to restore a Sybase ASE database server (Windows)

1618817 - SYB: How to restore a Sybase ASE database server (UNIX)

If your job is to administer Sybase ASE for a SAP Business Suite System , I suggest to also consider SAP training course ADM540

Lot of  the basics of Sybase ASe are discussed therein.

HTH

Tilman Model-Bosch

Former Member
0 Kudos

Hi Ahmed,

for windows:

Login with <SID>adm, open command prompt and type below command.

cmd:>isql -Usapsa -S<SID> -X  click enter

password: master password

1>dump database <SID> to "path\filename.dmp" (ex: "f:\backup\bkp.dmp" )

2>go

for AIX or Linux:

login to root and switch to <SID>adm and and type below command

Abc#  isql -Usapsa -S<SID> -X

password: master password

1>dump database <SID> to "/mount point/filename.dmp" (ex: "/backup/bkp.dmp" )

2>go

Regards,

Bhaskar

Former Member
0 Kudos

Thank you all for cooperation.

Bhaskar, is this backup efficient for a full restore or I need to do something else?

Former Member
0 Kudos

Hi Ahmed,

This backup is sufficient for restore.  After restore you need to bring DB online with below command.

1>ONLINE DATABASE <SID>

2>go

Regards,

Bhaskar

Former Member
0 Kudos

Hi Bhaskar,

Any suggestion if getting following error while executing isql -Usapsa -S<SID> -X in RHEL 6 system ?

isql: command not found

Thanks & Regards,

Hitesh Pathak

former_member188958
Active Contributor
0 Kudos

Sounds like your PATH environment variable doesn't include the sybase directories.  Try

running the SYBASE.csh or SYBASE.sh scripts found in the sybase home directory.

-bret

0 Kudos

Hi Hitesh,

Try to login with user :-SYB<SID>

password:-**********

This will permit you to enter sybase.

Answers (0)