Sybase default log mode

[Former Member]

Hi All,

What is the default Transaction log mode in Sybase+SAP,

How to change log mode?

Please help.

Regards,

Karthik.

[former_member187136]

Karthik,

You can check from the below option after logging into the database through isql.

1>sp_helpdb <SID>

2>go

1> sp_helpdb saptools

     go

You can also change the mode by changing the dboption

1>use master

2>go

1>sp_dboption [dbname, optname, optvalue [, dockpt]]

2>go

List of available dboptions:

database_options

------------------------

abort tran on log full

allow nulls by default

allow wide dol rows

async log service

auto identity

dbo use only

ddl in tran

delayed commit

deferred table allocation

enforce dump tran sequence

full logging for all

full logging for alter table

full logging for reorg rebuild

full logging for select into

identity in nonunique index

no chkpt on recovery

no free space acctg

read only

scratch database

select into/bulkcopy/pllsort

single user

trunc log on chkpt

trunc. log on chkpt.

unique auto_identity index

Example:

1>sp_dboption <SID>,"trunc log on chkpt",true

2>go

Regards

Kiran K Adharapuram