Sybase Wiki
(Redirected from Main Page)
Disclaimer :: This Sybase Wiki is neither sponsored by nor in any way affiliated with Sybase,Inc. In any case, neither the authors nor Sybase, Inc assumes any responsibility for errors in the wiki postings, nor do they have any liblilties for damages resulting from the use of wiki postings. This Sybase Wiki is only for sharing purpose. The opinions expressed here represent our own and not those of my any past and present employer, and Sybase Inc.
Note : This wiki is in the process of setup. Please share yours suggestions & thoughts : sybanva@gmail.com
Hello, Welcome to Sybase Wiki!
Sybase Adaptive Server Enterprise (ASE)
ASE Basic
- How can we start the sybase server?
- How can we shutdown the Sybase ASE server?
- How to log in Sybase ASE server ?
- What are system required databases for Sybase ASE 12.X & 15.x?
- How to check the Sybase Server Name
- Top ten table usage wise in a database?
- Nice difference between Sybase and Oracle - Sybase outperforms Oracle.
- How to check the Version of Sybase Server Running?
- New Features in Sybase ASE 15.x ?
- How can you trace your path of error log,SYBASE ASE Server name,Back up Server name etc?
- How to start adaptive server in single-user mode?
Installation/Configuration/Upgradation/Migration
- How can we perform the ESD upgrade for a Sybase ASE Server?
- Configuring Auditing in the Sybase ASE?
- Configuring the DBCC DB in Sybase ASE?
- How can we configure java in ASE later ASEv15.0.3 ?
- How can we perform upgrade from 12.5 to 15.x ?
- How can we enable remote ASE server access?
- Which are most frequently used configuration parameter ?
- What is interface file and how can it interpret?
Devices & Database
- How to initialize database device ?
- Which System table is updated, whenever a new database is created ?
- What is dsync and its imporatace ?
- What is directio and its imporatance ?
- How to drop devices ?
- What is deafault device and how to make new default device ?
- Global and Local Indexes ?
- How can increase size of device ?
- What is database options ?
Login/User Management (DB Security)
Backup & Recovery (DB Dump & Load)
- How to take stripped back up in SYBASE ASE?
- How to take stripped compresed back up in SYBASE ASE?
- If tempdb is getting fill?
- If tempdb is completley filled up?
- Refreshing the UAT data server?
- bcp
- Tables which we need to take bcp out on daily basis
Memory/Data Caches
Update Stats/Reorg/Optidiag
Engines and MultiProcessing
Sort Order/Char sets/ Langauges
Performance and Tuning
- What are the basics of performance tuning?
- Scenarios considered for performance tuning?
- Performance Tuning - Scenario Based Part 1?
- Performance Tuning - Scenario Based Part 2?
- Blocking in the Sybase Dataserver
- How can we check for the long running trans?
- How can we print Deadlock information in errorlog?
- If user database log is completely full?
- How can we take striped & compressed backup in ASE?
- What is the local and global indexes?
Day-to-Day Administration
- How can we see the sql text?
- Steps for checking Health of Dataserver?
- How can we check the Sybase services up and running fine?
- How can we change the sort order of a sybase server?
Developer Area
- What is the difference between syskeys and sysconstraints?
- What is the difference between login and user?
- What are the local and global indexes
- New SQL functionality in Sybase 15.7 version
Miscellaneous
- What are MDA Tables?
- How can we use MDA Tables?
- Daily maint Jobs for A Database
- Weekly Maint Jobs for a Database
- Global and Local Indexes
Sybase Replication Server (RS)
- How to check Replication threads are up?
- How can we configur the Rep Agent?
- How can we check that Rep Agent is up andRunning?
- How can we check that Replication Is up and working fine ?
- How can we configure table level Replication?
- How can we mark a table for Replication?
- How can we make sure that Statble queues are free?
- How can we Configure Warm Standby Setup for ASE-ASE Pair?
Sybase IQ Server (ASIQ)
Monitoring Unix Shell Script
Essential Unix Commands for DBA/Developers
- awk
- getopts
- pushd, popd and cd -
- cat
- cd
- chmod
- chown
- chgrp
- cp
- dd
- du
- df
- file
- ln
- ls
- mkdir
- mount
- mv
- pwd
- rm
- rmdir
- size
- tee
- touch
- type
- umask
- bc
- cal
- date
- find
- grep
- locate
- whatis
- whereis
- which
- ifconfig
- netstat
- nslookup
- ping
- rlogin
- ssh
- alias
- echo
- expr
- sleep
- awk
- basename banner basename
- cut
- dirname
- head
- less
- more
- paste
- sort
- tail
- vi
- wc
- clear
- exit
- history
- id
- su
- sudo
- uptime
- tput
- uname
- wall
- who
- whoami
- chroot
- cron
- kill
- pgrep
- pkill
- ps
- pstree
- top