Important Sybase commands

Here you can find helpful commands for Sybase ASE. This collection of important Sybase commands are commonly used by database administrators. Here i will share my script repository with you. Basic Sybase commands, how to create devices and databases. create device disk init name = ‚data_001′,physname=’/<path>/data_001.dat‘, size= ‚256M‘, directio=’true‘ extent device disk resize name=data_001, size=’256M‘   create database … weiterlesen

Sybase: Backup your Server Configuration

Hello, why backup your Sybase server configuration? It is worth, when you have all settings before an disaster outage. The Sybase configuration is corrupt, your Sybase service do not start and you can not find the Sybase configuration file in your filesystem backup. Then it would be worth, to have a copy of all your … weiterlesen

Hints and Tips for Backup / Dump Sybase Databases

Today i will provide some usefull hints and considerations for doing Sybase database backups. This article gives you only additional informations, suggestions and experiences what would be nice to have when you must recover a Sybase database. Please contact the Sybase Infocenter for backup and recover strategies. The following prerequisites are important for a successfully Sybase database restore: Create … weiterlesen

run SSH Commands with Powershell

Now you can implement a Powershell function to run SSH Commands on AIX and Linux. Collect Data and create HTML reports. Monitor systems, create events and notify yourself with email when thresholds raises. Powershell will do your work and enjoy your Admin Life. You can use it for the following tasks: Get DB2Diag.log Get all DB2 … weiterlesen

DB2 Runstats only on Tables with a high change rate

Maintain your DB2 Data regularly! If the online reorg and auto runstats hamper your daily workload scheduler this script after your nightly ETL load or when application performance is not relevant. Up to date DB2 Table Statistics and a well stored data pages = better performance and fewer IO An easy way to archive this is to … weiterlesen

run DB2 Commands with Powershell

Leverage the power of Powershell to run DB2 commands on a DB2 System running on AIX, Linux or Windows. Start BACKUP DATABASE commands Run table and index reorg and collect statistics Monitor DB2 Transaction Log and Manage Tablespaces Manipulate data with select – update – insert or delete Schedule scripts on Windows VM with Task Scheduler. … weiterlesen

Social media & sharing icons powered by UltimatelySocial