Bytes - DB2 Database answers - Page 17

Lock-waits don't get logged ... but
Basic DB2 transaction diagnosis question
Rollforward after online backup
IDUG 2004 - Europe Hosts Industry Leading Vendors
date format in snapshots
development center build fails
SQLException on ResultSet.next
v8.1 Alternate FP7 installation quesiton
Database release level a.00
Where has Fixpack 6 gone ?
Missing dll
serial equivalent in DB2
SQL help
SYSPROC.SYSINSTALLOBJECTS not found in one DB but exist in another DB in the same instance
DB2 version without connection
V7.2, Linux - Join between multiple DB
Replacing a function referenced in a view
Avoiding Table Scan on Update with correlated subselect
collect sub-element statistics
Does IBMJava2-SDK-1.4.2-0.0 work with DB2 8.2?
snapshot on all db partitions
LOAD via a Stored Procedure
DB2 hangs...(7.2)
Ruined my dear db2
Deadlocking in Java program
qmf - alternative query columns
No double quote in UDB Export DEL file
Adding a generated column
INT. Entertainment Company in S. California needs Data Warehouse Specialist
Database Physical Location in UDB 8.1
Accessing DB2 database via Java?
Cannot create view using jdbc
SPs from Triggers in V8.2 - Performance?
Using "load" to migrate a database to db2
DB2 ver 5.2 and windows 2003 server
Build java stored procedure error
High Execution Time--Low CPU time for statements
DB2 Locking Scheme Problem.
updating table from temp table
SQL Question
CCSID problem on iDB2DataAdapter
Opening more than 1 table via the iDB2DataAdapter
Openings in Chennai for DB2 DBA Professionals
Opening for TPF/ALCS Professionals
Need DB2/AS400 consultant in Silicon Valley
Need DB2/AS400 consultant in Silicon Valley
Any tool to monitor db2diag.log?
Any tool to monitor db2diag.log?
RUNSTATS from SQL for UDB
backup log on DB2 6 to TSM
How to delete tables completely?
load needs more than 1 second per table for empty tables
Alter column from NOT NULL to NULL
Temporary Space during LOAD
Is there a way to add new item in health indicator.
Syantax support
db2sql92 segmentation fault
DB2 8.1, Copy Stored Proc's from one db to another...how?
Embedded SQL and Multithreading Question on 8.1.5
restore to another machine fialed
restore database to another server failed
date formatting to use in stored procedures
casting and padding problem
Installation : An Error Has Occured. DER!
INSTALL HELP.....AIX 4.3.3
What is the overhead for the backup compress option ?
DB2 Clob Serach case insensitive
help! install DB2 On Redhat9 Segmentation Fault
Net Search Extender Problems
Is Stinger downloadable yet?
Two New Versions of the Perl DBD::DB2 Driver Released
Very slow delete using GUI
DB2 V8.1 + W2K: Connection to local DB with domain user not possible
IBM Support for DB2 V8 FP4
How to avoid hash loops
IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager Express Edition v1.3.2 Win, IBM Tivoli System Automati
IBM DB2 ODBC-driver for download
EXPORT problem
Running a HADR script outside of the HADR Wizard
DB2 Catalog tables poster?
ERROR [40003] [IBM][CLI Driver] SQL30081N A communication error has been detected. Communic
How to delete sequences
DB2 UDB LUW: values current groups?
DB2 Connect install problem
DB2 8.2 (FP7 upgrade)
Change schema name
export IBM UDB (7.2) database into DB2 Mainframe
Needing db2 udb version 6.5 or 7.x for windows (desesperately)
V8 DPF feature and instance creation
IDTHTOIN
Client connection crash and Rollback..
UDB Gui Tools
Clustering two instances on one server
DB8.1 - FP7 trouble ...
DB2 Replication having slow apply (update) at the target server
RI drop performance gains issue
combine db2uext2.cdisk & db2uext2.ctsm together?
SQLStatistics driver bug?
Question Regarding Auto Increment Field
Opinion on most stable release
tablespace container design
How to backup and restore from tape device
accessing multiple schemas -- 390 & cobol
DB2 8.1.5 SQL1224N Error
URGENT SQL help
How can I force DB2 to advance to next logical log?
Is there a restriction for an index creation?
using a stored procedure to compare tables
Tablespace Offline / Corrupt Quandry
Temporary table performance problem on UDB 8 on Linux
Cant find sequences...
How to get specified between dates
"where not in " doesn't work
Problem with redirected restore
budgeting for a new database?
DB2 UDB configured to run at least near optimally at what percentage of sites?
Anything newer than DB2 version 5 client
Calling COBOL sub-routines from Stored procedures written in SQL
Switch from Oracle to DB2
Finally: SQL procedure tracing
DB2 equiv. to setDefaultFixedString [oracle]
COM.ibm.db2.jdbc.app.DB2Driver.<clinit>(Unknown Source)
MLN: alter bufferpool on subset of MLNs
DB2 Replication and updates
Client Access screen does not respond, system request no problem
quick question: Stinger and FP7 the same?
Creating Function refering to sequence
Converting Stored Process to other DBMS?
Disappointed with IBM's new APAR search engine
SQL2000 linked server with new 5.3 Client Tools
SQL how to
How do I get DB2 to know I have a C compiler?
New DB2 responsibilities
DB2 1.2 - Plea for help
HOW TO TRACK RECOVERY?
user defined function
uninstall cube views code ???
Control Center access across firewall
Tablespaces on backup image (UDB v8.1)
questions on udf_mem_sz.
"Package Cache Overflow" in db2diag.log?
Database Log-file
DB2-PHP Memory problem
Dynamic SQL - "MERGE INTO......"
SQL -2650 when running Capture
Upgrade AIX
Create concatenated string from a result set using SQL
IDUG 2004 Europe 11-14 October 2004 Prague, Czech Republic
i18n'ed Character Set in DBMS and tables
db2start : error ... libcxa.so.1
Numerous Very Small Log Files
FP7 size on linux
VIRTUALIZATION ENGINE CONSOLE A RUNTIME 1.1 - IBM (3 CDs), WEBSPHERE BUSINESS INTEGRATION CONNECT ADVANCED v4.2.2 - IBM, other 16,000 more CDs, [ no dongles, no activations, etc ... needed ! ]
confusion with number of processors using ESE
Loading data from a .DAT file
Doubt About Unix server Authentication
DB2 data locked away forever?
remote access on the same instance
used pages increase after deleting and loading again
db2licm
DB2 8 + DB2 7, Can they co-exist??
Data Warehouse Specialist - S. California
howto keep two db2 in sync ?
CCA3061N error connecting to new databased only
Using a response file to restore a UDB v7.2 server on a new box
Extremely slow Administrative Server
Client connection fails with SQL0973N Not enough storage in MON_HEAP_SZ
DB2 UDB 64-bits
Moving from AIX to Windows
SQLCODE error when trying to access temporary table
update transmogrifies to insert/delete
Size of indexes in a particular tablespace?
Redirected Restore
catalog cache heap question
recursive queries
db2cctr will not initialize if XP SP2 is installed
Please HELP .. instance crash ver 8.2
V8.1 FP7
query
DB2 UDB LUW: (c1,c2) = ('10000','01/16/2004'): OK ( c1,c2) >= ('10000','01/16/2004'): NOK
Sorting
How many memory for the connect gateway with 10.000 connect users
db2iupdt
Bind Needed for remote remote PC Access to DB2 for OS/390
SP problem: SQL0727N with type "1". and SQLCODE "-551", SQLSTATE "42501"
Stinger server vs. FP6 admin client compatibility
db2advis in DB2 Version 8 Fixpax 7
more thoughts on 8.2
problem converting DOUBLE to CHAR
fyi load csv file from windows
connect UDB V8 client to 390 V6 instance
URGENT - DB2 Client 8.1.2?
bufferpool content
Db2 v5.2 on NT4 crashed
DB2 8.1 ESE Win32 installation problem
8.2 maintenance wizard ??
Snapshot Missing Dynamic SQL Total Execution Time
current user id
DB2 connection Pooling
federation problems
federation problems
Db2 load API options
debugger options not showing up in develpment centre
DB2 DLFM
sqlj.install_jar problem on both Solaris and Linux
DB2 Stored Procedures and Dynamic SQL returning a Result Set
db2expln and federated
db2 vs oracle
Beef with 8.1 Information Center
Create database from a client
Backup and Export
Backup Performance
Anybody Using Power4 or Power5 platforms?
Determine Database Name or Instance Name from SQL in DB2
debugging options don't show up for SQL stored procedures
LEFT OUTER JOIN's possible in DB2?
SQLCODE -817
How to uninstall DB2 Connect v. 7?
DB2 SQL Procedural Language Outside Procedure
db2cctr - trap under Win XP SP2
Using Transactions to Insert Data to Db2 Database
slow connections with DB2DataSource
unexpected result from COALESCE
Need Updated List of DB2 CLI PATCH2 Keyword Values
db2_all : escape * ' ( " in ksh
Identity column Equivalent for DB2?
DB2 V8 Fixpack 7 (akaV8.2)
Not more than 5 Threads
application status question
SQL Server inked server to as400 - for the love of god please help.
DB2 V8 FP7 problem
DB2 UDB Error Message
DB2 ContentManager Windows Programming App. Search Method
nested select question
as400 and sql via ODBC
PHP - DB2 weird error while refreshing page
Java Stored procedures 8.1.6
PASSING A COLUMNS NAME TO TABLE FUNCTION
DB2 V7 z/OS and ODBC CLI optimization
Check temporary table existing
Search Criteria for Windows Programming
load with "allow read access" gives -911 on UDB v8 FP 5 on AIX
query timeout
Huge estimated cost for a simple delete statement with cascade
Snapshot function?
Deletes way slower on AIX, two questions
DB2 READLIMIT parameter : where is it documented ?
list database partition......
DB2 8.01 - need help with deadlock problem (Event Monitor Log Attached)
Proc1 result set with proc2
DB2 v8 performance improvement for Stored Proc resolution
db2 function error! help
Direct Access Without Index ?
DBA command
db2diag.log not writing
Catalog Cache vs. Buffer Pool for SYSCATSPACE
Catalog Cache vs. Buffer Pool for SYSCATSPACE
order by issue
Intermittant user authentication error
Bind Error while using ALIAS on VIEW with other owner (DB2 OS/390)
SQL0407N occurs when binding files from older version (DB2 v7.2 @ OS/2)
DB2 UDB 8.1 Exam 700
Catalog Cache Overflow
Runstats manipulation
Setup for MQSeries functions
Statement event monitor doesnt report statement text
Latest version number on Windows?
problem using java packages in jdbc stored procedures
SET QUERY OPTIMIZATION in UDF
Scratchpad in SQL UDF
db2licd stopping
iODBC vs unixODBC ?
Stored Procedure
Stored procedure question
EEE partitions process performance are different
Dynamic SQL in UDF
db2eventlog.000
SQL0444 received when executing a stored procedure
static and dynamic SQL
DB2 Runtime Client Lite Installation Problems
Prefetchers
Log arhiving Frequency (Rule of thumb)
Solaris kernel parm sd_max_throttle
OK, Based on the few responses I got, TSM is not a problem in other shops? Really?
Java UDF problem
DB2 v8 32 bit on Solaris 64 bit
db2 fixpak overwriting symbolic link
looking for db2 expert 8.1 win2003 or win2000
backup/restore nTs data
Thanks!
Locale issue with db2
how to set/configure ip for DB2 on windows for remote JDBC
FULL OUTER JOIN
Oracle to DB2 Migration issues
Severe memory problem with V8
Linked DB2 table in MSAccess 2000 shows #Deleted on every record
How to change a column name.
Reading sql script - newbe question
Use of 'LIKE' in SQL 'WHERE' statement in Batch COBOL program
encryption data with replication
JDBC Error
migrate DB2 table to MS SQL server with GIF fields
DB2 V7.2 fixpak 12 / UTF-8 db doing extra Unicode -> UTF-8 conversion on client?
Issues with Index, Full Scans instead
CA issues million dollar challenge to open source community
Passing data from one stored procedure to another
Insert is slow are there tweaks?
Obese Table
TSM Troubles
can no longer view APARS
ROWID Equivalent
connection error from .net to as400 db2 database
ODBC from Linux
sql update from stage tables with two column keys db2 V8
Compile tool for procedure builder in windows
Cannot create an instance after deinstall DB2. Was told the instance already exists
Logging speed.
Perl and DB2 Stored Procedures
UDB8.2 - Debugging SQL Procedures
about the system temporary tablespace
Need to improve my stored procedure , your comments are welcome!!
DB2MOVE problem between AIX and Windows
Many Direct Writes to SYSCATSPACE, and each very slow.
problem setting up a client
applname in db2 govenor cfg
Online migration of a DB2 table across tablespaces
db2fmp process
Corrupted connections using DB2 Gateway
Coarsification of colums: not generated colums but row-value constructors in DB2 UDB
sqlurlog question
Getting IBMdadb2 error : Access Denied when configuring linked server in sql2000
Tivoli - News groups?
Backup db to TSM only use one session
TIMESTAMPs and WHERE
HELP - Need to connect to DB2 database on AIX from NT server. Also AS/400 from NT Server
set integrity and testing DATE format
Can I use a sub query to define the contents of the FROM clause of a query?
Nested SP:s and result sets
Cursor Not In Prepared State
looking for a sql editor
Help with group by
limiting number of rows returned in a cursor select
Creating a sequence alias
UPDATE problem
/job/ DB2 UDB warehouse manager (former Visual Warehouse)...
Single table restore
911 deadlock
Partitioning In DB2
some health indicator questions
JOINS
DB2 on Network Mounted Filesystems (Linux) ...
reorg using system temporary table space for table in tablespaceswith variable page size
create table .... not logged initially error or not?
LOCKTIMEOUT
Performance problem on Linux
DB2 UDB LUW: Upgrade all type-1 in indices to type-2, check (afterwards)
Trigger error ....
backup consideration
How to fix an extremely slow restore
MS SQL stored proc., linked server, DB2, incomplete txfrs
SYSCAT.ROUTINES VALID column
Concurrent I/O on Aix: When?
how to release locks when the application ends with error
Very important table (partition) design question: DB2 UDB EEE V8.1 on AIX 5.2
db2diag error
Application heap size
DB2 on Windows or Linux ?
How can I know to which column a null value has been assigned? (SQL0407N)
C Stored Procedure error SQL0444N
db2 replication
SQL SP ....
update statement
Copying data between databases
Why SQL2036N error (path not valid) when Load utility uses SMB networkdrive as source ?
Odd query hang
SQL Question, Stored Procedure
Instead of Trigger results into SQL1424N
Video extender - Java samples?
db2look question
generated by default or as always
Debugging Stored Procedures
Client Configuration Information
JDBC: How to determine an invalid connection
SQL-procedure-statement ....
OUTER JOIN problem
Mass copy data from db2 in OS/390 to udb db2 running NT
SQL join/UNIQUE question?
Arnold Schwarzenegger loses Recall Vote and returns to full-time body building, only to finish 2nd in Mr. Galaxy to Pat Paulsen.
stored procs in cobol?
DB2 Admin client failing
LOB Locator Limit Exceeded
installing DB2 on Linux
Arnold Schwarzenegger Commits Suicide
Adminclient ...
lock escalation question
IBM DB2 Personal Connect
Creating Aliases across Databeses in an Instance
Problem with procedure ...
Delay between SQL statements in DB2
NSE index updating problem
DB2 Admin client failing
Why does FETCH FIRST slow down query?
lock conversion U-Locks
Indexing mode "autoselect"
CLI problem
SQL6048N/DBI1281E on SuSE 9, doesn't go away after reinstall
Monitoring changes in a database
How many extents does a BLOB need?
How to change to an older JDBC driver
db2diag.log message ....
Uninstall UDB8.1 on windows
merge statements and triggers
copying data from one database to another database
Bind files from NT to 400.
configuring java stored procedure so only 1 sp call processed at a time
Websites ....
Help needed : How to Execute a string SQL statement with DB2
Websites ....
SQL stored procedure on z/OS ....
XML Extender and DAD issue...
Java Stored procedure
DB2 8.1 rtc and MacOs X
DB2 Replication: Change Aggregate Table
update a database
Assistance with Auditing Checklist for IBM DB2
ConnectionString ado.net and iseries
DB2 Crash in the weekend
External UDFs & Embedded SQL
Federated DB, access to remote sequence
db2 first admins
Back with the same DB2/PHP problem
Looking for a development tool
UDFs (written in C)
Error message help
cannot do DB2 operation even though logged in with administrative privileges
Defragmentation and Performance
LOB Locators and DB2CLI
Easier Object changing in Stinger ?
DB2 on OS/390 - Administrative API ??
Alternatives for "OUTER JOIN"
stored procedure
DB2 XML Extender: Error while dxxGenXML()
SQL stored procedure on UDB 8.1.3 ....
Direct reads & In memory Database
Migration toolkit question ....
Error message cause HELP
Quest disappearing HELP EMERGENCY
how to remove the row lock from admin side
Cursor in UDF
SessionId on DB2/AS400 ?
C++ on DB2 express
Table scans for larger rowcounts?
File Permissions for system administor on AIX for DB2 UDB
Java Stored procedures cannot get updated class file recognised
User permissions for the DB2 UDB sysadmin user id on AIX.
Question related to "CREATE TABLE AS SELECT" in DB2
how to connect db2 client to server
restore question
DB2 Mainframe JOB
Unable to create char columns > 254
failure recovery in a cluster?
Shared Library problems on Solaris
X Row locks causing Lock-waits
DBI DB2 Federated
DB2 8.1 and AWE
RTFM, but which one?
Can you have more than one Java Stored Procedure in a Class
Java / C SP migration help
db2fm produces two error messages per second forever...
Do you use Job Scheduling?
Db2 partitions in V4.0.1
DB2 Procedures & Cursors
Transact -SQL in SYBASE ....
SYBASE to DB2 ....
Last committed transaction
Odd Stored Procedure Behavior
Urgent Questions regarding Index usage & VIEWs, sorting, etc.
SQL0444N when calling a stored procedure
SQL0418N error: Untyped parameter markers cannot be used in some cases???
Tuning CLI/ODBC application
SQLJ Vs JDBC ....
db2 + php screwy messages -- HELP, please!
Printing with UDB WSE v8 and Win2000
Num query fields affects num rows
db2set running every 10 seconds
Data compression i DB2
UserExit succeeded manully but failed when loaded automatically by DB2
CURRENT SQLID in CLP ....
Character delimiter ....
SQL0818N Timestamp conflict occurred
Compiling db2uext2.cdisk with Cygwin gcc
xml input into temp table.
Use of MQTs
Deadlock on runstats / reorgchk
CLOSE_CURSORS_AT_COMMIT ....
Inserts And Updates Using An UR-Connection
Returning exceptions from a SP called from a Trigger...
Select from different server
IBM Distributed Debugger ....
Query performance
rebalancing containers
Upcoming OCIUG Meeting & Querix Full Day Workshop -- Updated Agenda
administration server not active udb 7.1 windows 2000
"SQLSTATE" not valid in the context where it is used.
How to reduce dirty page steals?
Command Center script saving ? V7 / V8 changed behaviour
New blog
Transferring Data from Sql Server 2000 to IBM db2 udb
db2icrt is not of the right version
Meaning of direct_writes in tablespace snapshot
Generated DB2 tablespace with datafile
Problem using Control Center to create database from backup
Handling invalid database connections from connection pools
Instance crash on db2 v 8.1.5
Backup and Restore DB
Simple SQLj question ....
After Reorg space is not reclaimed
Returning user defined datatype from stored function.
JDBC Connection on AIX and DB2 7.2.4
Invoke LOAD command?
Stand by server
Sorting primary key
strange "Log Full"
memory error with sqleAddEntryToResync
SQLJ stored procedure ....
How to implement CA Erwin change management?
URGENT HELP - Fixpack 6
what's "share-nothing archtecture"?
Health Center UDB V8.1.4 for Windows start problems
Sync. remote DB
STORED PROCEDURE SETUP???
Errors in first stored procedure
Help - Dynamic Table
INSTEAD OF INSERT ON
INSTEAD OF INSERT trigger
How to do an variant select in a stored procedure?
Incomplete recovery with lost of data
Performance of SQL
cpu time high
DB2 V8.1 System Tables Diagram
index hit
DB2 date format issue
Restoring Backup image problem
javax.sql package for DataSource interface ....
sqlcode=-843/SQL0843N why ....
DataSource interface ....
Returning multiple result sets
how to compare two tables difference
SQL1224N.....SQLSTATE=55032 Problem.
Multiple counts using grouping, ordering, and joins