DB2 & UDB email list listserv db2-l

September 2005

ADM1823E The active log is full
(30 Sep 2005 22:28:35)
DB2 Agent Expiry
(30 Sep 2005 22:16:8)
Help Needed on sleep command in stored procedures
(30 Sep 2005 22:13:34)
ODBC connection to DB2 database
(30 Sep 2005 22:2:36)
DB2 v8 -OS upgrade RHES-HELP
(30 Sep 2005 15:29:38)
Heap size problem
(30 Sep 2005 14:3:5)
changing the schema
(30 Sep 2005 13:46:7)
Join
(30 Sep 2005 10:20:30)
Copying schema
(30 Sep 2005 9:51:50)
Anyone anywhere ever make a heterogeneous join work from SQL*Server to IBM DB2/UDB?
(30 Sep 2005 8:54:45)
Re: Configration files
(30 Sep 2005 3:24:17)
Weird Export Behavior
(29 Sep 2005 18:4:53)
Calling procedure multiple times from Trigger
(29 Sep 2005 13:39:0)
disk full msg
(29 Sep 2005 13:27:4)
'nmake' is not recognized as an internal or external command, ope rable program or batch file.
(29 Sep 2005 12:4:51)
Help needed coding standards of UDB
(29 Sep 2005 10:10:10)
Migration Strategy
(29 Sep 2005 10:4:42)
Help needed on UDB coding standards
(29 Sep 2005 9:54:38)
Coding standards in UDB pdf help needed
(29 Sep 2005 8:28:35)
COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] CLI0116E Invalidtransaction state. SQLSTATE=25000
(29 Sep 2005 7:53:52)
Restrict values in an INTEGER column.
(29 Sep 2005 6:33:41)
Create database in subdirectory on Windows
(29 Sep 2005 5:9:59)
DB2 Connect to OS/390
(28 Sep 2005 20:8:51)
ODBC/Gateway to OS/390
(28 Sep 2005 16:30:37)
Error while executing the query
(28 Sep 2005 12:39:31)
int value
(28 Sep 2005 10:24:11)
DB2 equivalent for Oracle Collection types
(28 Sep 2005 10:19:29)
db2 recovery
(28 Sep 2005 6:18:19)
does it mean BAD SQL?
(28 Sep 2005 2:25:50)
Reason code: "9". SQLSTATE=42724
(28 Sep 2005 2:13:13)
Memory leaks between SQL*Server and UDB with IBM OLE DB driver
(27 Sep 2005 21:3:10)
Tablespace id change
(27 Sep 2005 20:6:34)
DB2 Version 8 for the OS/390
(27 Sep 2005 16:7:12)
Writing db2 procedures in cobol
(27 Sep 2005 16:2:22)
Compressed Backups
(27 Sep 2005 15:46:24)
DB in Backup pending state
(27 Sep 2005 12:36:15)
Once again: DB2 scheduler
(27 Sep 2005 11:30:39)
Failing to connect
(27 Sep 2005 11:1:54)
initcap
(27 Sep 2005 10:41:23)
Timestamp
(27 Sep 2005 7:43:32)
Lowering High Water Mark
(27 Sep 2005 0:23:58)
DR on db2
(27 Sep 2005 0:21:23)
DB2 Configuration Advisor
(26 Sep 2005 18:28:59)
bind -best practices
(26 Sep 2005 17:17:48)
Scripts on DB2 for Mainframes
(26 Sep 2005 9:6:16)
varchar
(25 Sep 2005 23:3:14)
Can anyone suggest a good book for DB2 administration
(25 Sep 2005 14:19:44)
LISTOWNER- EMAIL SHIELDING
(24 Sep 2005 13:0:2)
CURRENT TIMESTAMP help
(23 Sep 2005 23:29:17)
"SQL0968C". The file system is full
(23 Sep 2005 20:24:57)
SQLSTATE 58005
(23 Sep 2005 20:24:23)
sql question
(23 Sep 2005 19:30:32)
z/os question
(23 Sep 2005 17:50:29)
iSeries DB2 8 migration to DB2 Windows 2003
(23 Sep 2005 15:38:11)
Restoring backup from one version to another version
(23 Sep 2005 13:13:14)
DB2 Control Center Won't Start
(23 Sep 2005 11:55:15)
Cursors RESULTset values
(23 Sep 2005 11:53:51)
Codeset..
(23 Sep 2005 11:35:26)
Oracle scripts conversion in db2
(23 Sep 2005 11:31:26)
PUT_LINE
(23 Sep 2005 8:28:22)
Backup and recovery for DB2 Z/OS version 1.5 onwards
(22 Sep 2005 12:4:32)
AUTOMATIC STORAGE
(22 Sep 2005 11:29:55)
generation PDM Files in Z/OS
(22 Sep 2005 10:47:56)
What does this mean ...
(22 Sep 2005 9:30:11)
Does CHAR(CURRENT_DT,ISO) works in Db2 for zOS
(22 Sep 2005 8:14:28)
How to alter the Primary key?
(22 Sep 2005 5:50:50)
To get a value at 10000th postion
(22 Sep 2005 5:45:15)
Case Statement
(21 Sep 2005 14:43:22)
MQT with refresh immediate SQL20058N
(21 Sep 2005 14:12:57)
Re:To get a value at 10000th postion
(21 Sep 2005 14:2:50)
internal error codes
(21 Sep 2005 13:30:21)
Objectstar
(21 Sep 2005 12:53:8)
DB2 Tool
(21 Sep 2005 10:27:9)
oracle book
(21 Sep 2005 10:4:13)
DB2 connect and backup
(21 Sep 2005 0:23:28)
DB2 UDB for Windows: Scheduler
(20 Sep 2005 20:19:35)
Please help with DB2 crash
(20 Sep 2005 20:13:8)
Re: Primary-Contingency Setup
(20 Sep 2005 17:41:40)
Excessive Connect Time from Windows DB2 Client to AIX DB2 Server
(20 Sep 2005 17:26:46)
Re: A question on DB2 performance tuning..
(20 Sep 2005 10:30:2)
.NET app exhausts max connections on DB2 Connect Server
(19 Sep 2005 22:30:54)
LOAD Utility Error DB2
(19 Sep 2005 19:21:53)
Copying and Renaming a database to another server
(19 Sep 2005 18:41:32)
Restoring a Linux backup to a Windows server
(19 Sep 2005 18:28:12)
H.A.D.R. ~ remote access error
(19 Sep 2005 17:17:28)
creating tablespaces
(19 Sep 2005 16:20:59)
migrating logical volume from volume group to other
(19 Sep 2005 15:58:48)
db2syscs.exe performence problem
(19 Sep 2005 15:40:2)
starting an instance on a Solaris server
(19 Sep 2005 15:12:18)
What Is COLLECTION ID
(19 Sep 2005 14:32:58)
Re: [Maybe Spam] Re: System Deployment
(19 Sep 2005 12:31:14)
Varray equivalent in db2?
(19 Sep 2005 10:9:45)
runtime error 3712 in db2
(19 Sep 2005 5:40:19)
Re: Freeing a package or plan
(19 Sep 2005 5:27:33)
performance
(18 Sep 2005 18:49:21)
Replication
(17 Sep 2005 17:53:8)
Re: [Maybe Spam] DML operation monitoring
(16 Sep 2005 15:21:0)
DML operation monitoring
(16 Sep 2005 14:27:37)
tsm audit
(16 Sep 2005 13:7:30)
User defined types in DB2
(16 Sep 2005 11:51:29)
DB2 8.2
(16 Sep 2005 11:40:3)
Re: Spam:Urgent Help Needed!
(16 Sep 2005 9:57:47)
Urgent Help Needed!
(16 Sep 2005 9:15:54)
Lock Description from a snapshot for locks
(15 Sep 2005 20:59:19)
How to sort db2 tables
(15 Sep 2005 19:56:51)
DB2 V8 FP6 vs DB2 V8 FP9a
(15 Sep 2005 17:20:5)
DDL
(15 Sep 2005 16:58:28)
SQL0964C The transaction log for the database is full. SQLSTATE =57011
(15 Sep 2005 14:58:18)
equivalent of rownum in DB2
(15 Sep 2005 14:3:57)
Command Line Error
(15 Sep 2005 13:52:3)
UUID generator for AS/400
(15 Sep 2005 12:14:21)
System Deployment
(15 Sep 2005 12:9:22)
SQL1042C problem
(15 Sep 2005 10:56:6)
DB2MOVE UTILITY
(15 Sep 2005 0:18:42)
Need some SQL Guidance for exiting a script if an error is encountered
(15 Sep 2005 0:5:6)
does HADR require both primary and standby servers to share the same logpath?
(14 Sep 2005 23:59:15)
Stored Procedure issue - using a parameter to capture column name for update
(14 Sep 2005 21:7:58)
DB2 V8 implementation performance problems.
(14 Sep 2005 20:18:36)
DB2 Connect Client
(14 Sep 2005 14:46:14)
userexit, windows
(14 Sep 2005 14:25:26)
Problem with System Temporary Tablespace!
(14 Sep 2005 11:37:27)
Re: Store only month & year of a date]
(14 Sep 2005 11:26:25)
Store only month & year of a date
(13 Sep 2005 19:38:40)
Static Variable in a Function
(13 Sep 2005 18:27:56)
SQL2310N while RUNSTATS
(13 Sep 2005 18:25:49)
help with INSERT please
(13 Sep 2005 15:26:18)
TABLESPACE
(13 Sep 2005 12:41:9)
anybody having sample question for DB2 UDB 700 certification
(13 Sep 2005 11:55:4)
Database link
(13 Sep 2005 11:19:30)
Error while starting db2
(13 Sep 2005 11:15:54)
BufferPool memory allocation failed
(13 Sep 2005 8:6:5)
Single Quote
(13 Sep 2005 5:44:1)
Using a ver 8 client for ver 7.2 databsaes
(12 Sep 2005 20:18:5)
Re: db2 hadr
(12 Sep 2005 19:47:19)
Re: Does db2 have a %TYPE operator?
(12 Sep 2005 18:9:25)
Job Scheduler.... Task center VS CRON/WInodows task center
(12 Sep 2005 15:31:2)
Re: [Maybe Spam] Job Scheduler.... Task center VS CRON/WInodows t ask center
(12 Sep 2005 14:5:46)
How to Move the Database Tables from one DB2 Database to Another DB2 Databse
(12 Sep 2005 12:54:39)
LOAD Problem using bcp out file
(12 Sep 2005 12:48:9)
Querry to retrieve a Java function in UDB
(12 Sep 2005 11:13:22)
LEVEL: Error in db2dasdiag.log
(12 Sep 2005 4:39:30)
Date functions in DB2
(10 Sep 2005 11:42:15)
db2 error, urgent !!!!
(9 Sep 2005 22:45:1)
Why I can not use "WITH UR" at the end of view - Appreciate your help
(9 Sep 2005 18:43:56)
reorging indexes
(9 Sep 2005 17:17:14)
Fenced users in db2
(9 Sep 2005 16:17:58)
app_ctl_heap_sz, applheapsz, urgent !
(9 Sep 2005 15:57:4)
How to ACCEPT values from User!
(9 Sep 2005 14:10:35)
restoring backup from earlier version of database
(9 Sep 2005 12:0:9)
Wrapped Functions!
(9 Sep 2005 11:46:37)
FIXPACK 10
(9 Sep 2005 11:40:11)
physical size
(9 Sep 2005 8:49:55)
Running statistics and Reorgs on an entire database.
(8 Sep 2005 23:40:55)
Changing the bufferpool
(8 Sep 2005 23:10:51)
Create Database Through Script!
(8 Sep 2005 22:47:57)
Indexed fields contain nulls?
(8 Sep 2005 20:20:26)
Email
(8 Sep 2005 12:45:32)
plb problem
(8 Sep 2005 11:44:48)
load z/os jcl
(8 Sep 2005 5:40:58)
Re: NOT LOGGED INITIALLY example!
(7 Sep 2005 19:46:7)
Calling functions inside Stored Procedure
(7 Sep 2005 18:55:57)
Empty Table off Records!
(7 Sep 2005 17:38:6)
truncate a table
(7 Sep 2005 14:27:33)
error in package, Oracle
(7 Sep 2005 14:13:27)
can not access a table after a load
(7 Sep 2005 13:45:32)
Re: can not access a table after a load..resolved
(7 Sep 2005 13:5:19)
Current SQL
(6 Sep 2005 17:28:45)
DB2 Rollforward Pending Flag
(6 Sep 2005 16:14:21)
Table lock, ungent !!!
(6 Sep 2005 16:8:21)
How to calculate the size and capacity of DB2 UDB?
(6 Sep 2005 12:48:23)
Temporary Substitution Variables!
(6 Sep 2005 11:31:43)
udb Stored Proc Query
(6 Sep 2005 11:5:32)
error while REORGanizing
(6 Sep 2005 6:29:52)
Database design website and ebooks ...
(6 Sep 2005 5:57:58)
Getting Day Name
(6 Sep 2005 5:37:29)
Table Partitioning ??
(5 Sep 2005 15:35:7)
** Unavailable Resource error **
(5 Sep 2005 13:58:42)
Calling Script from Script!
(5 Sep 2005 12:57:5)
bind error.
(5 Sep 2005 11:27:39)
job scheduling
(2 Sep 2005 18:18:2)
Remote Connect to DB2
(2 Sep 2005 16:46:49)
mdutility error
(2 Sep 2005 16:36:34)
Licensed Processors
(2 Sep 2005 16:31:25)
SP is taking too much time after RUNSTATS.
(2 Sep 2005 15:44:4)
New table function
(2 Sep 2005 14:56:36)
DB2 Maintenance Differences
(2 Sep 2005 13:22:13)
create a plan on db2
(2 Sep 2005 12:5:15)
Task Center not launching anymore
(2 Sep 2005 8:25:16)
Dates
(2 Sep 2005 6:26:37)
DB2 "unaligned access" messages
(2 Sep 2005 4:37:19)
Transferring numeric data fr SQl Server to DB2
(1 Sep 2005 21:46:4)
TABLES IN CHECK PENDING WHILE DOIGN DB@MOVEW
(1 Sep 2005 18:39:9)
Health Center Notifications
(1 Sep 2005 17:54:31)
Restore
(1 Sep 2005 17:32:10)
Problem with load !!
(1 Sep 2005 14:52:46)
Timestamp Data Type!
(1 Sep 2005 11:33:38)
comparing 2 tables of same structure
(1 Sep 2005 4:43:58)
Does a rebalance of a tablespace lower the High Water mark?
(1 Sep 2005 1:4:51)
db2 lazydba home page