Tech tips…
Posts tagged ‘sybase’
“The transaction log in database tempdb is almost full. Your transaction
is being suspended until space is made available in the log.”
If you are getting this error message you can extend tempdb running the following commands:
disk init name ="extra_tempdb", physname ="/opt/sybase/data/extra_tempdb", vdevno=8, size=512000
alter database tempdb on extra_tempdb = 500
alter database tempdb log on extra_tempdb = 500
When SYBASE get started, the following call is made:
startserver -f RUN_MYINSTANCE
RUN_MYINSTANCE is located in $SYBASE_HOME/install.
1/ edit RUN_MYINSTANCE and add the following line, where the switches are:
-psa
2/ run startserver -f RUN_MYINSTANCE
During the boot phase you will see something like, e.g:
New SSO password for sa:uvwxyz
You can also see this message in Sybase logs.
3/ edit RUN_MYINSTANCE and remove the line you added in step 1/, so you do not reset it next time.
4/Set your own password:
isql -Usa -SMYINSTANCE (using ‘uvwxyz’ password)
>sp_password “uvwxyz”,”my_own_password”
>go
Default value : 25
$isql -Usa -SMYINSTANCE
>sp_configure ‘user connections’, 100
No reboot is required since this option is dynamic.
Changing the value of ‘number of user connections’ to ‘100′ increases the amount of memory ASE uses by 17740 K.
sp_configure – set db parameters
sp_dboption – set db options
sp_displaylogin – Show login details
sp_help object_name – Object definitions
sp_helpdb dbname – db info
sp_helpdevice - device info
sp_helpindex - index per table info
sp_helpprotect userid – Privileges info
sp_helpsegment – Monitor db sizing
sp_helptext stord_proc – Show stored procs code
sp_helpuser userid - User info
sp_spaceused – db sizing
sp_who userid – Users logged in info
Slashdot