|
|
-
|
|
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......
|
|
-
|
|
A quick method to use for executing a script on Linux start.
After all the other processes are started by the init command at boot time, the script is run on Red Hat based systems:
/etc/rc.d/rc.local
Add any extra script\commands references to this file.
See Also
db2start at st......
|
|
-
|
|
By default , when creating a new DB2 database , the Log path is on the same drive as the data files.
To change the log path , configure the NEWLOGPATH database parameter
db2 update db cfg for MYDB using NEWLOGPATH /newpath/
See Also
OLTP performance checklist
Republished with author's......
|
|
-
|
|
When a DB2 database starts the total memory required for the bufferpools must be available.
If this memory is not available when a database starts, the database manager will only start with system buffer pools (one for each page size) with a minimal size of 16 pages, and an SQL1478W (SQLSTATE0162......
|
|
-
|
|
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......
|
|