|
|
-
|
|
This post explains how to list Event Log Messages with Powershell Get-EventLog , on multiple servers and output the results to a HTML file.
It is only one extra step to send an email attachment.
This example iterates through a list of servers and returns Error messages from the System Event Log g......
|
|
-
|
|
A DB2 Incremental Restore recovery strategy requires:
a) The full backup image
b) 0 or more incremental backup
c) The days logs
The db2ckrst utility parses the history file and allows you to source the relevant backup images.
Method 1 - Automatic Restore of Incremental Back......
|
|
-
|
|
A useful command for DB2 DBAs is the LIST UTILITIES command.
It displays the list of active utilities.
Examples of usage include : BACKUPS, RESTORES, performance issue, progress of RUNSTATS
[db2usr1@server1 ~]$ db2 list utilities show detail
ID = 36708
Type ......
|
|
-
|
|
This article describes some methods of checking DB2 is running on a Linux Server
Method 1
Log onto the server and execute db2start as the instance owner. If the instance is running you’ll see , something like:
02/10/2012 23:36:14 0 0 SQL1026N The database manager is already active......
|
|
-
|
|
To copy a table from another SQL Server Instance is easy. Create a Linked Server on the destination server and reference the Linked Server in the SELECT statement.
1) Create linked server
/****** Object: LinkedServer [SERVER1\SQL_SERVER_INSTANCE_1] Script Date: 02/02/2012 09:29:33 ******/
EX......
|
|
-
|
|
You can look up any error message from the command line with "db2 ? sqlxxxx" (where xxxx is the SQLCODE with no sign and leading 0 to make it 4 digits long)
You can also use db2 “? SQLxxxx” | more
The Linux command – more – allows paging of text one screen at a time
An......
|
|
-
|
|
This article explains how to send an email through Powershell.
Very useful if you have a requirement to automate your scripts and send notifications .
The example is calling the SmtpClient Class , which is part of the .Net Framework.
You can call a Function – which makes your scripting ......
|
|
-
|
|
During a large ETL process from a staging table , UPDATE was creating an error on a CONVERT.
Msg 245, Sev 16, State 1, Line 17 : Conversion failed when converting the nvarchar value '??u? ? ? ?AA???????????W?????????a??????K???????????????????1217' to data type int. [SQLSTATE 22018]
It was......
|
|
-
|
|
I received the following error , when attempting to connect to a DB2 database
db2 connect to MYDB
SQL1036C An I/O error occurred while accessing the database. SQLSTATE=58030
#Checked in the db2diag.log file
ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found."
DIA8411C A fil......
|
|
-
|
|
Generate SQL Server INSERT statements with Excel Concatenate.
A developer requested access to a Production database. The details were to COPY and PASTE from a Excel spreadsheet into Access , which then updated SQL Server. Upon asking him , why he used this method , he said “It’s the w......
|
|