How to create Mirror logs in Sybase ASE on SAP

195 Views

Hello

We have recently installed SAP ECC6 with EHP6 on Sybase ASE 15.7.0.012 on Windows , Later upgraded Sybase ASE to 15.7.0.021.

During installation we have created 4 database files each has 100 GB size and two transaction log files has 15GB each.

Through Dump database & dump transaction command we took database & transaction log file backup successfully.

Please let me know

1.how to configure Mirror logs ( copy of transaction log files ).

2.What could be the correct size to define transaction log file & data file?

3. How to check free space of transaction log file.

Using sp_helpdb <SID> command

data<SID>_1 100352.0 MB data only

Nov 20 2012 1:45PM 30878144

data<SID>_2 100352.0 MB data only

Nov 20 2012 1:45PM 64880720

data<SID>_3 100352.0 MB data only

Nov 20 2012 1:45PM 102359040

data<SID>_4 100352.0 MB data only

Nov 20 2012 1:45PM 102359040

log<SID>_1 15360.0 MB log only

Nov 20 2012 1:45PM not applicable

log<SID>_2 15360.0 MB log only

Nov 20 2012 1:45PM not applicable

Free size shows "not applicable" , Is this correct? or I need to do any configuration / settings.

3. After Sybase ASE upgraded to 15.7.0.021 version , I am unable to see server configuration parameters except application functionality in dbacockpit.

Please help me.

Thanks , Murali