|
|
-
|
|
$working_dir/$logfile
echo "operatation began `date`" $working_dir/$logfile
for i in `db2 list db directory | grep 'Database name' | awk '{print $4}'`;
do
echo "==============================" $working_dir/$logfile ;
echo "getting :DB AUTH,USER AUTH,PLAN AUTH for: $i" $working_dir/$logfil......
|
|
-
|
|
I completed a DB2 backup on server1 with the command:
db2 backup db sample online include logs
Backup successful. The timestamp for this backup image is : 20120106215500
There was a requirement to RESTORE this database from TSM onto Server2.I logged on to Server2 and checked I could view t......
|
|
-
|
|
Executing a t-sql statement with a convert function
convert(datetime, my_date_column) ,
threw an arithmetical overflow error with the message :
Message
Arithmetic overflow error converting expression to data type datetime. [SQLSTATE 22003] (Error 8115) The statement has......
|
|
-
|
|
Network card teaming or NIC teaming are networking terms describing methods of combining multiple parallel network connections . The main purposes are 1) increasing throughput beyond a single connection and 2) redundancy.
The three main teaming configurations
Network Fault Tolerance (NFT)
1) ......
|
|
-
|
|
Sometimes end users interchange the terms : C2 auditing and Traces. They server different purposes.
c2 auditing records all attempts (successfull and failed) on objects and statements. Typically a SQL Server DBA will use a c2 audit to monitor security compliance .
A trace will will monitor an even......
|
|
-
|
|
While troubleshooting a DB2 performance problem for Websphere Portal 6.1.0 using DB2 9.5 Enterprise Edition , one of the DB2 tuning recommendations from the Portal Tuning guide was to set MAXFILOP = 512 or higher
MAXFILOP is the Maximum database files open per application configuration para......
|
|
-
|
|
I was creating a Powershell script for a SQL Server checkout procedure after a reboot , and used the state_desc column in sys.databases view to report on the database status.
The descriptions, courtesy of BOL are:
ONLINE - Database is available for access
RESTORING – One or more files are......
|
|
-
|
|
The Environment Variable DB2_RR_TO_RS enables\disables the Repeatable Read attribute. I's enabled for DB2 performance purposes
DB2 registry parameter DB2_RR_TO_RS is used to:
Set a default isolation level for user tables to Read Stability (RS) isolation level. The RS level is not dissimilar to......
|
|
-
|
|
To make the T-SQL function DATEADD more dynamic use variables. The example below, accepts an input parameter, in this case “4”.
All events older than 4 months from now will be deleted.
DECLARE @months int
SET @months = 4
DELETE FROM [Events] WHERE [EventDate]
Republished from http://www......
|
|
-
|
|
When executing a DB2 backup command, an error message appeared
db2 backup db MyDB online use TSM include logs
SQL2033N An error occurred while accessing TSM during the processing of a
database utility. TSM reason code: "106".
Accoring to the ibm infocentre
The specified file is being u......
|
|