Personal tools
You are here: Home
Navigation
Log in


Forgot your password?
 

Search results

Did you not find what you were looking for? Try the Advanced Search for more precise search options.

392 items matching your criteria. RSS Feed
How to extract and display the partitioning/distribution map [1%] by Perallis, 2009-07-23 10:39
db2gmap
How to find out which columns make up the partitioning key of a partitioned table [1%] by Perallis, 2009-07-23 10:11
syscat.columns - PARTKEYSEQ
Shell script to rebuild an entire database - part 1. [1%] by Perallis, 2009-07-13 10:23
This should be run in the in the source database server. ItÅ› created a script called: <db name>.rebuld_onTarget.ksh with the necessary commands to rebuild the ...
Shell script to rebuild an entire database - part 2. [1%] by Perallis, 2009-07-13 10:22
This script should be put in the same path as the script provided in: "Shell script to rebuild an entire database - part 1. "
DB29.5 Advantages over DB29.1 [1%] by Perallis, 2009-07-08 14:13
Case Insensitive, Shirink of Tablespaces, Threads
Backup includes database logs in backup images by default on DB2 9.5 [1%] by Perallis, 2009-07-07 13:36
How to convert table spaces to use automatic storage on DB2 9.7 [1%] by Perallis, 2009-07-03 10:10
ALTER TABLESPACE <TBSNAME> MANAGED BY AUTOMATIC STORAGE
ALTER COLUMN SET DATA TYPE support all compatible types on DB2 9.7 [1%] by Perallis, 2009-07-03 09:36
varchar(20) to varchar(10), integer to smallint, ...
How to rename columns on DB2 9.7 [1%] by Perallis, 2009-07-02 10:54
using the ALTER TABLE statement
DB2 9.7 [1%] by Perallis, 2009-07-02 10:50
New features and functionality
Timestamp Auto Update on DB2 v9.5 [1%] by Perallis, 2009-09-29 09:59
Now DB2 can automatically update the timestamp in a row whenever it is inserted or changed. You can enable this on timestamp columns when creating or altering ...
How to use date functions on DB2 [1%] by Perallis, 2009-05-30 20:07
dayname, dayofwwek, month, monthname
Governor Errors - GOV0102W "SQLMONSS" [1%] by Perallis, 2009-05-29 15:23
WARNING (15060) GOV0102W "SQLMONSS" warning: SQLCODE = "1626"
Clean up DB2 backup images from TSM [1%] by Perallis, 2009-05-22 16:48
This script deletes backup images from TSM. The numbers of backups to keep in TSM Server is given in a command line as parameter when the script is executed. ...
How to select null values as 0 values [1%] by Perallis, 2009-05-22 16:28
using coalesce function
How to know the number of partitons and ranges from partitioned tables [1%] by Perallis, 2009-05-21 15:54
SYSCAT.DATAPARTITIONS
How change the default date format in DB2 Databases [1%] by Perallis, 2009-05-18 11:33
How to use db2move [1%] by Perallis, 2011-11-16 13:57
import, export, load
Can not rollback to save point [1%] by Perallis, 2009-05-08 14:49
db2 UPDATE COMMAND OPTIONS USING c off
SQL0440N - Delete Errors [1%] by Perallis, 2009-05-08 12:08
referential constraint corruption
How to use DB2 Federation [1%] by Perallis, 2009-05-07 10:03
wrapper -> server -> user mapping -> nickname
DBA experiences [1%] by Perallis, 2010-07-23 03:28
How long have you been working as a DBA ?
How to reset snapshot monitors on DB2 [1%] by Perallis, 2009-04-29 12:05
How to enable asynchronous I/O (AIO) support on Linux for DB2 9.1 [1%] by Perallis, 2009-04-27 17:29
setting DB2LINUXAIO variable to true
How to calculate the Percentage of Overflows over Rows Read [1%] by Perallis, 2009-04-24 15:40
DB2 for LUW V9.7 Announced [1%] by Perallis, 2011-08-02 18:34
IBM announced DB2 "Cobra", the next release of DB2 for Linux, UNIX and Windows (LUW), V9.7 on April 22.
How to ignore case sensitive search on DB2 [1%] by Perallis, 2009-04-24 16:09
using the upper or lower functions
How to check what views and tables are inoperative [1%] by Perallis, 2009-04-14 09:45
syscat.tables - status
How to rebuild an entire database [1%] by Perallis, 2010-03-03 11:36
When you cannot recover your database for any reason, you need to rebuild your database
Mysql [1%] by Perallis, 2012-05-24 12:47
Security Awareness
Would you like your company to implement gamification into your security awareness program?





Polls