DB2 & UDB email list listserv db2-l

March 2005

SQL1131N
(31 Mar 2005 21:54:21)
DB2 z/OS SMS vs DMS
(31 Mar 2005 20:28:8)
Exception Handling on DB2 (udb) for Z/OS
(31 Mar 2005 17:46:12)
like in db2
(31 Mar 2005 17:13:15)
EMPTY TABLES..
(31 Mar 2005 16:7:24)
How to reset logretain and user exit to off and required step
(31 Mar 2005 13:26:16)
SQL0289N Unable to allocate new pages in table space "USERSPACE1
(31 Mar 2005 10:12:8)
Script for Listing All Constraints for a Table (DB2 Version 7 - O S 390)
(31 Mar 2005 8:27:43)
Pruning db2diag.log
(30 Mar 2005 21:34:1)
log switch
(30 Mar 2005 20:41:19)
Connection timeout ??
(30 Mar 2005 20:16:41)
database not response
(30 Mar 2005 16:34:39)
Access Vs DB2
(30 Mar 2005 12:20:40)
DB2 and LDAP(IBM Tivoli Directory Server5.2)
(29 Mar 2005 23:6:13)
MS Access and DB2
(29 Mar 2005 18:37:36)
db2 user privileges
(29 Mar 2005 17:11:26)
another diaglog error
(29 Mar 2005 16:52:51)
Disable Constraints in DB2 Version 7 - OS390
(29 Mar 2005 15:55:9)
Indexed Views
(29 Mar 2005 14:55:24)
SQL10007N !!!
(29 Mar 2005 14:53:45)
UDB - list history backup all for
(29 Mar 2005 12:46:23)
Application taking a while to display data
(29 Mar 2005 12:41:22)
DB2 Limitations
(29 Mar 2005 12:35:44)
DB2 CCSID code page
(29 Mar 2005 11:0:36)
error in diag log
(29 Mar 2005 7:33:9)
lock intent
(28 Mar 2005 22:28:34)
Package 'P0218310' of database 'ESMRDW2P' failed to revalidate.
(28 Mar 2005 18:55:21)
DB2 UDB Position Available.
(28 Mar 2005 18:49:19)
Preventing use of MS Access, and other similar tools, with DB2
(28 Mar 2005 18:32:42)
Control Center Not Opening
(28 Mar 2005 14:9:49)
Include Logs statement
(28 Mar 2005 13:52:43)
connecting to remote machine
(28 Mar 2005 11:45:34)
LISTOWNER- EMAIL SHIELDING
(26 Mar 2005 14:0:2)
Is there any way to find the databases????????????
(26 Mar 2005 5:21:46)
Preserve dbm cfg and catalog info while doing a redirect restore
(25 Mar 2005 22:13:34)
List of changes for a specified time frame
(25 Mar 2005 21:38:42)
different method of calculating table size
(25 Mar 2005 11:38:3)
Will Filer Upgrade Affect DB2?
(25 Mar 2005 0:16:46)
Here's how you calculate the table size in byets
(24 Mar 2005 23:40:6)
DB2 SQL Statement Tuning Guide.
(24 Mar 2005 23:37:5)
Version 8 db2diag.log
(24 Mar 2005 20:33:38)
RUNSTATS
(24 Mar 2005 19:9:38)
DeadLock?
(24 Mar 2005 17:5:7)
Upgrade 32bit to 64bit
(24 Mar 2005 16:37:35)
Text Extenders
(24 Mar 2005 15:12:28)
Increase in connections
(24 Mar 2005 15:3:57)
restore the database from an online backup image to a new database after droping previous one????????
(24 Mar 2005 11:9:45)
Help on Platinum
(24 Mar 2005 9:23:56)
a report query problem
(24 Mar 2005 9:22:43)
DB2DIAG.LOG error
(23 Mar 2005 21:39:8)
getting sqlstate from within a trigger
(23 Mar 2005 18:0:11)
When is Z lock released
(23 Mar 2005 15:58:57)
Problem to call a stored procedure from PHP
(23 Mar 2005 15:30:55)
DB2 Date Format
(23 Mar 2005 14:41:0)
Network Connection
(23 Mar 2005 13:57:33)
Connection to Linux DB2 thru ODBC.
(23 Mar 2005 12:17:48)
need help on DB2 - UDF and trigger (receiving SQLCODE "-4306")
(23 Mar 2005 10:16:49)
Rename the database?
(23 Mar 2005 8:48:9)
porting tool
(23 Mar 2005 4:52:21)
Calculate the width of a future table
(23 Mar 2005 2:35:18)
Create Instance
(23 Mar 2005 1:33:12)
SCHEMA and OWNER name
(22 Mar 2005 19:56:40)
Tool for ER diagram automation
(22 Mar 2005 14:10:34)
DB2 Client Connection
(22 Mar 2005 13:12:35)
insert statement in UDF
(22 Mar 2005 11:40:56)
CHAR vs VARCHAR in UDB
(21 Mar 2005 16:46:40)
Using long tablespaces for indexes
(21 Mar 2005 15:21:29)
question
(21 Mar 2005 14:55:38)
Partitioning in DB2
(21 Mar 2005 12:57:58)
DB2 server gets stopped
(21 Mar 2005 12:43:0)
Cluster Index
(18 Mar 2005 18:14:37)
check whether a table is empty or not
(18 Mar 2005 14:20:43)
Db2
(18 Mar 2005 14:1:51)
Transaction Logs
(18 Mar 2005 13:3:45)
Re: Oracle's ROWID (Delete Duplicates)
(18 Mar 2005 12:14:13)
Oracle's ROWID
(18 Mar 2005 12:12:11)
Order by sub-select
(18 Mar 2005 10:22:1)
Convert from Server to client
(18 Mar 2005 5:51:29)
DB2 tool?
(18 Mar 2005 5:49:50)
Creating view
(18 Mar 2005 5:43:56)
Associate Tblspace with Database
(18 Mar 2005 5:38:14)
Clients
(17 Mar 2005 19:10:21)
Re-Framing the Question - Is there any way to find the databases without connecting to the database??????????
(17 Mar 2005 15:4:5)
DB2 replication facility
(17 Mar 2005 12:32:41)
Instance not starting
(17 Mar 2005 12:29:45)
Cost charged for Mainframe usage per MIPS
(17 Mar 2005 10:13:50)
Remote Database
(16 Mar 2005 22:12:22)
Re: bad SQL query
(16 Mar 2005 19:21:21)
Error while inserting into BLOB,CLOB columns
(16 Mar 2005 18:26:44)
Redistribution of Data
(16 Mar 2005 16:10:28)
Question on PCKCACHESZ tuning
(16 Mar 2005 13:31:30)
Catch Result Sets of a Stored Procedure From Embedded SQL
(16 Mar 2005 7:25:44)
SQL 0904 reason type 13, on iSeries V5R3
(16 Mar 2005 6:3:28)
Informix Conversion to UDB DB2 question
(16 Mar 2005 1:51:58)
SQL0440N ??
(15 Mar 2005 19:24:24)
Is there any way to find the databases without connecting to the database??????????
(15 Mar 2005 14:18:39)
Unable to Query Sycat tables throught the client ( USerid is db2inst1)
(15 Mar 2005 14:3:4)
Cant connect to DB
(15 Mar 2005 13:55:0)
Julian Date
(15 Mar 2005 13:31:29)
Any better way to observe sql execution time?
(15 Mar 2005 13:3:32)
Move databases from one instance to another
(15 Mar 2005 4:10:10)
DB2 migration
(14 Mar 2005 19:36:14)
db2 logging
(14 Mar 2005 19:34:34)
Scaling partitions
(14 Mar 2005 19:17:21)
SQL stuffs
(14 Mar 2005 15:3:11)
View Compilation
(14 Mar 2005 13:51:5)
Restore DB from a compressed file
(14 Mar 2005 13:49:12)
Problem in restoring the DB
(14 Mar 2005 13:41:24)
Use db2move and change the schema name when we import into the target database. Is this possible ?
(14 Mar 2005 13:31:3)
DB2 error : SQL0752N
(13 Mar 2005 3:21:22)
Moving large amounts of data
(13 Mar 2005 3:10:58)
swap space is 32 GB but it's over 90% used
(11 Mar 2005 18:42:13)
Re: [SPAM] - RE: [SPAM] - Update on big volumes - Number of numbers in MIME From exceeds maximum threshold - Number of numbers in MIME From exceeds maximum threshold
(11 Mar 2005 18:0:28)
Re: [SPAM] - Update on big volumes - Number of numbers in MIME From exceeds maximum threshold
(11 Mar 2005 17:51:14)
Select Current Date
(11 Mar 2005 17:2:59)
rexx code
(11 Mar 2005 16:26:32)
formatting numbers
(11 Mar 2005 14:32:51)
Update on big volumes
(11 Mar 2005 12:20:16)
Problem in restoration of DB
(11 Mar 2005 11:25:33)
Any equivalent of hints in db2??
(11 Mar 2005 10:20:59)
Re: [SPAM] - Stored Procedure - Bayesian Filter detected spam
(11 Mar 2005 9:30:46)
Stored procedure
(10 Mar 2005 20:32:20)
Alternate way to drop a table
(10 Mar 2005 15:30:28)
create function
(10 Mar 2005 15:2:33)
Alter table.
(10 Mar 2005 14:54:21)
Format Date
()
Reclaiming DMS container space
()
replacing strings using SQL on DB2
()
DB2 online backup in LTO tapes
()
Delimiter to be specified in Load utility in DB2.
()
Export & import of all tables in DB2
()
Unable to open db2cmd window
()
Re: [SPAM] - UDB - LOAD and LOAD QUERY question - Bayesian Filter detected spam
()
Alter system tablespace
()
UDB - LOAD and LOAD QUERY question
()
DB2 8.2
()
SQL Function for Getting numeric values character column
()
MQT on iSeries V5R3
()
Reorg increases size of tablespace
()
SAS and DB2
()
Federeated password
()
DB2 Access Control on AIX...
()
Alternate fixpacks
()
Info on 702 certification
()
PROBLEM WITH LOAD UTILITY
()
Query on Fixpacks
()
deadlock and timeout solution?
()
Problem: db2 connect to my_db_alias user aUser using password
()
Re: File system full
()
RE Connection URL
()
RE HOW CAN I FIND THE PLAN RELATED TO MY PACKAGE?
()
Connection URL
()
HOW CAN I FIND THE PLAN RELATED TO MY PACKAGE?
()
Row size in DB2
()
Re: RE Federated Database
()
Task Center -Scheduler
(4 Mar 2005 14:13:5)
Federated Database
(4 Mar 2005 13:53:9)
migrating clob data.
(4 Mar 2005 11:13:0)
Create temp tablespace with page size 16k
(4 Mar 2005 10:13:28)
Restore a database from one system to another?
(4 Mar 2005 4:10:48)
Error creating tablespace
(4 Mar 2005 3:35:19)
Online Reorg space requirement question.
(3 Mar 2005 21:58:51)
Error "-289" during reorg
(3 Mar 2005 20:23:25)
system temporary tablespace
(3 Mar 2005 20:4:55)
SQL scrpit to identify 10 worst SQL for DB2 8.1 AIX 5.2
(3 Mar 2005 18:51:44)
Dynamic SQL Snapshot
(3 Mar 2005 18:13:54)
SNAPSHOT
(3 Mar 2005 18:10:11)
about db2 list application
(3 Mar 2005 11:36:36)
License issue
(3 Mar 2005 0:17:41)
CLI0108E Communication link failure. SQLSTATE=40003
(2 Mar 2005 22:1:17)
changing optimization class on static sql
(2 Mar 2005 20:45:16)
Application Id
(2 Mar 2005 19:45:53)
gcc Compiler on AIX
(2 Mar 2005 18:14:57)
Update Syntax Help
(2 Mar 2005 16:57:13)
db2loggr error
(2 Mar 2005 15:50:52)
Query
(2 Mar 2005 15:19:4)
Recursive calls in DB2 v8.2
(2 Mar 2005 13:27:40)
Finding SQL
(2 Mar 2005 12:58:15)
Exporting all the tables in a Schema
(1 Mar 2005 22:51:40)
Re: db2look command
(1 Mar 2005 22:27:1)
logsecond alternative?
(1 Mar 2005 21:34:49)
Is codepage only an issue when using db2@connect ?
(1 Mar 2005 18:39:3)
Re: help with query
(1 Mar 2005 16:55:52)
Trimming the result of SQL query
(1 Mar 2005 15:40:14)
finding the routine name associated with a particular package??
(1 Mar 2005 14:52:38)
Multiple Instances of DB2 and Database Xfer with IXF format?
(1 Mar 2005 12:56:30)
Challeging Question:Database application process slow down.
(1 Mar 2005 12:55:27)
Re: help with
(1 Mar 2005 7:50:53)
Procedure taking too much time to complete and generating .csv file
(1 Mar 2005 7:45:1)
Creating copy of a table in DB2
(1 Mar 2005 7:42:25)
db2 lazydba home page