View Full Version : answers
- tablespace query
- need a query...
- Db2 Min Value with Char field.
- Access plan question
- Client side alternate server
- Just Upgraded - Problems...
- How to Find which SQL Statement is executing
- DB2 - Move data from an AS400 to an AIX system
- COBOL User Groups Newsletters - Call for Articles
- query help
- query help
- Using application data in query
- Compilation for different fixpaks
- Slow prepare times for inserts
- how to set idle time out
- JDEdwards date
- Has anybody worked on Q replication trouble starting the capture
- JDBC Timezone conversion
- WITH TYPEINTS
- High Water mark in db2
- Easy & safe deletion of inconsistent rows
- Question of DB2 Connect gateway
- FYI, DB2 FP13 (or should I say 11) instructions are incorrect
- Avoid data conversion in DB2
- Confused about the archive parameters
- Password Security Policy in DB2
- Setting up a linked server in MS SQL using IBM OLE DB PRovider for DB2
- Need to know which indexes need to be rebuilt and command to do so.
- Queries against a table
- Insert statement taking a long time to complete.
- (CORRECTION!) DB2 XQUERY can't serialize unicode string??? STATE 2200W
- BLOB NOT LOGGED
- DB2 XQUERY can't serialize unicode string??? STATE 2200W
- DB2 SQL1822 error code 408
- AIX queue_depth for SAN hdisks for DB2 file-dms containers
- Assistance with DB2 Query
- New to Db2 Stored Proc
- Using as in a cursor
- LOAD with UPDATE
- SQL0901N on CONNECT
- DELETE causing performance issues
- Time is running out to register for IDUG 2006 - Europe
- IS NOT DISTINCT FROM ?
- DB2 authentication
- Domestic Alternative To Offshore Outsourcing (Mainframe)
- Update with join statement not working in DB2
- configure PHP with IBM-DB2
- Visual Explain - Estimated Processing Time: Not Available - how come????
- how to get the last generated value of an identity column for a given table ?
- When execute dynamic generated multiple OPENQUERY statements (which linkes to DB2) in SQLServer, I always got SQL1040N The maximum number of applications is already connected to the database. SQLSTATE=57030.
- db2load remote database
- isolation level
- Lock mode converting from NS to X, when will this happen?
- Is this legal db2 sql ???
- dynamic cursor name?
- Session tables in triggers. Is it planned?
- Index not used only on a particular environment
- cursor in procedure
- Default Allowed Access for RUNSTATS?
- db2 connect server fixpack 13 on Microsoft Cluster
- Restore utility ignores USER clause?
- Restore utility ignores USER clause?
- Authentication Question
- Difference between DB2 UDB V8 Fix Pak 7 and V8 UDB Fix Pak 12
- DB2 ODBC Connection Expiration
- DB2 HADR software
- Problem relating to running Stored Procedures
- Db2 Hadr ???
- Question regarding CLI array Insert
- 9.1 db2look against 8.2 database
- DB2 arithemtic division
- Regarding Replication DB2 UDB
- Cannot uninstall DB2 in UBUNTU
- DB2 Audio extender start fail
- db2audit fails to create audit.log
- DB2 with MQ(XML) Functions, MQ Listener
- currency format
- A question of DB2 authentication
- When will LOAD utility check consistaint
- Which storage should be using for Enterprise Applications?
- DB2 - XML and Spatial data in same column - can't alter table once created - PLEASE HELP
- error mapping file SQL0966N SQLSTATE=57013
- DB2 SQL Query export to flat files as a function of data on each record
- code
- Very slow INSERTs - URGENT
- Yellowfin Reporting Release 3 OLAP Connectivity
- How to call the C stored procedure in SQL stored procedure in DB2
- Regarding db2 udb Replication
- Regarding Replication in DB2 UDB
- connect db2 with tomcat 5.0
- LOAD utility followup
- MDC+partitioning+compression
- column types in DB2 vs. other DBMS
- select from table function where argument is a result set
- db2app.dll and AIX
- AS400/DB2 table view compatibility
- db2 database returns ebcdic
- How do I get DDL for a UDF?
- Where could I get the fixpack for DB2 on EM64T?
- Exam 703
- DB2 on NetApp Filer
- db2 load performance
- OT : Carriage return
- MS Accesss 2003 ODBC to DB2 - BIGINT doesn't work ?
- JDBC Driver Versions
- Visual Explain for DB2, no access plan
- DB2 per ODBC ansprechen
- Help regarding INDEX
- plz help urgent
- Help W/ Auditing Unix Db2
- Locks held from snapshot on db and on locks is totally different
- Instance Crash
- Install Application Development Client for DB2 V7 in AIX 4.3
- Locks maintained on Command Editor (DB2UDB V8) despite autocommit on
- DB2MOVE QUESTIONS
- Reduce High water mark
- dynamic sql snapshot vs static sql snapshot
- How to give database drop privelege to a user/group on Windows?
- How to give database creation privelege to a user on Windows?
- Make group an owner of db2 objects
- GRANT statement gives authorization id not valid error
- DB2 UDF as module (was:DB2 UDF timeout)
- z/OS UDB 8.1 and Functions vs Stored Procedures
- DB2 backup and connection timeout
- Regarding Replication in DB2 UDB
- Retrieving table SQL text
- DB2 Foreign Key Indices
- question on lock list
- IDUG 2006 - Europe DB2 Conference: Early registration savings end 14 September!
- DB2 UDF timeout
- urgent : stored procedure not accepting data string more than 1024 bytes
- DB2 SQL Procedure Multi User Env.
- I have no blog
- db2 trigger and foreign key constraint perfomace issue
- DB2 Export file type
- Does DB2 v 8.1 need UPDATE to get a pessimistic lock?
- db2_mmap vs create tablespace no file system cache option (concurrent i/o)
- error for eplain
- Nested ResultSets : Invalid operation: result set closed
- Cannot restore after Veritas Netbackup restores
- Subselect Row Restrictions
- DWB and Views
- Upgrading SQL replication from v8 to v9
- begin atomic for call in while fetching rows from cursor
- Why is SYSCAT.TABLES.TABLEID not unique?
- How I can delete rows in one table with foreign keys
- Problem with DB2_USE_ALTERNATE_PAGE_CLEANING
- SQL0101N The statement is too long or too complex.
- create nickname
- How long to restore a sime large DB?
- Problem with dynamic sql in the procedure
- db2updv8: Fail to create routine SYSPROC.DB2LK_DEP_OF
- Choosing primary key / Unique Index
- snapshot_dyn_sql
- DB2 SQL1084C grief
- DB2 cross-platform RESTORE, tools for backup transformation?
- Oracle PRAGMA AUTONOUMOUS_TRANSACTION equivalent in DB2?
- Question about prefetchsize, containers and extensize
- Block comments in DB2 Command center
- stored procedure not accepting data string more than 1024 bytes
- Update with foreing key and primary key
- Seemingly Successful Inplace Reorg returns -1 Completion Status
- Perl DBD DB2
- MAX(SUM(SAL))not working
- Can we issue the "force applications" command from within a sql call?
- Clients Unable to access Server
- SELECT statement from within a Stored Procedure without INTO
- how to do sorting of double byte Japanese characters in db2
- UDB V8.2 : Append value to a column while loading using Method L
- Navigator Slow on ALTER
- Stolen Agent Question
- DWB and SQL Stored Procedures
- DWB and compare
- Adding new column to a table
- New White paper on DWB developers Work Bench V8 & V9 universal rdbms client
- db2start and db2stop commands giving problems
- Unable to debug a DB2 Procedure
- db2fmp
- BACKUP TO SAMBA NETWORK DRIVE FAILS BUT THE FIRST TIME
- backup to samba network drive fails the second time but not the first !
- How do I get the help
- What are good questions for a DBA?
- how to capture rows affected via merge command?
- Storage usage for Enterprise Applications
- Cursor - how does it behave
- Domino DECS-DB2-ODBC vers AS 400 - Saisie mot de passe obligatoire
- Before Trigger and UDFs (table)
- Unique Index or PK ?
- Creating Tablespaces : Best Practices
- Error SQLCODE "-811", SQLSTATE "21000"
- DDL statements of Tablespaces and Bufferpools
- DDL statements of Tablespaces and Bufferpools
- new DB2 data type
- CREATE FUNCTION with COBOL doesn't work!!
- Need to export table to an Excel file
- db2 version 9 license
- Accidentally Remove Transaction Log
- shredded XML into DB2
- a strange sql
- Can't run Visual Explain
- DB2 v9.1 jdbc xml sample
- Insert Query
- Tablespace in RESTORE PENDING state
- Reg:Last committed transaction
- i want to know how to send an email notification from db2
- XMLfile transform to DB2
- Question rgarding the Column encription
- What is this referring to in the Administration Guide: Performance
- DB2 Length Script
- Finding Duplicate Records
- list schemas
- DB2 Java stored procedure call
- SQL0980C A disk error occurred SQLState=58005
- Date Check in DB2 UDB urgent
- Regarding DB2 700 exam.
- Cant get DECLARE to work for sproc
- Can DB2 run on z/OS without DRDA access?
- Can DB2 can exist/run on z/OS without DRDA available for clients?
- I can't run strored procedure in Command Editor DB2
- Trigger Usage?
- Using MERGE to change a field value when there is no match
- create procedure problem - db2 8.2.3 (DPF) on AIX - help?
- very different costs for select and update - why?
- Writing data into a text file using Stored Procedure
- db2 8.1 for solaris 64 bit for AMD
- initialize both DB2 and Microsoft Visual Studio environments with asingle command
- Updating Eclipse components on DWB : should I ?
- DWB Not Starting on Linux (OpenSUSE 10.1)
- Default Date format using CAST in Stored Proc
- HA for DB2
- HA for DB2
- problem wih get routine statement
- Problems when run one procedure in DB2
- Growing SYSCATSPACE
- DDL Triggers
- CREATE TRIGGER -> writing to file???
- [DB2 AIV Extenders] Concurrent products?
- Create Database privilege at an instance for user/group
- SQL3525N on import/export in stored procedure
- DDL Triggers
- Conversion Julian date to Gregorian date on DB2 load
- db2 resources
- SQL4301 RC=0
- How update one row with timestamp diferent
- IBM DB2 LUW online reorg
- Password lost - how to change it.
- auto increment primary key val into XML attribute
- Importing an Access DB
- function workingdays problem
- How to determine which database a db2fmp process is running against?
- QUERY: grouping history of cash dispensers
- can I connect to DB2 using windows authentication?
- Insert CLOB data (XML file)
- DB2 exam 701 practise questions
- DB2 UDB SQL Stored Procedure.
- Update tables with primary key
- LIST HISTORY BACKUP Status
- Size of a Backup in DB2 UDB v8
- Primary Key Vs Unique Index in DB2
- Is it necessary to rebind JDBC Type 4 packages when installing a new Fix Pack
- Replication performance - how to measure it ?
- How to install ibm db2 icc
- programming code for Make your wish
- BP: blocked vs non-blocked
- Costly UPDATE to MQT base table
- JDBC batch inserts seem very slow.
- Backup with logs included
- Howto: Emergency SHUTOFF all monitoring & stats collections?!
- db2 incremental backup
- Is Java 1.3.1 compatible with DB2 v8.1 ?
- Toad for DB2
- IBMDBDB2 OLEDB provider does not appear to like case
- SYSPROC.ADMIN_CMD
- Getting SQLERRMC into DB2 for LUW Stored Procedure
- recovery time is bigger than current time
- Marketplace Announcment: "Yellowfin Reporting" Version 3 rollout
- interesting index design question.
- TABLE function, OUTER JOINS, and SQL0206N
- Any Perl / DB2 knowledgeable people out there?
- low overhead select to determine current server load
- Where does DB2 get it's CLASSPATH in a UNIX install?
- Calling a Stored Procedure from a BEFORE UPDATE Trigger
- Large partitioned table issue
- Bufferpool Hit Ratio
- Informatica ETL developer needed with PL/SQL for 3 months CTH in southern CA
- connect to db2 server with odbc
- How-to create indexes on temporary tables in DB2? Very Urgent.
- SQL1337N The service "db2inst1" was not found.
- lock with force
- delete lock problem
- Entry point sqlouerr in DB2SYS.dll not found
- SQL DTS to DB2
- Error while updating Instance
- BUG DB2 V8 FP12 Stored Proc Parameters - NULL value is case sensitive
- about multiple fact tables and star schema
- Seeking DB/2 professionals in the Columbus, Ohio area
- Transition to DB2ExpressC Edition
- Search capability in the DB2 V8.2 Information Center has been improved.
- Urgent Help :Query
- What is ONLINE BACKUP intended for ? Is it fake feature ?
- How to find out ?
- Transferring files from PC to AIX-DB2
- UDB 8.1 Win Fixpak 12
- UDB 8.1 Win Fixpak 12
- Online backup to restore onto another system (or for disaster recovery): how to?
- Restore V8 Fixpack 12 To Version 9
- Can't browse stored procedure in Navigator
- db2 store procedures Question
- Reliable timeron and Query Patroller
- DB2 AS400 Snapshot
- Simple SQL question
- Changing the Data Type of a Column(From SmallInt to Decmial)
- Reading ASC files in DB2 UDB - Urgent
- DB2 error using the command with USERID/PASSWORD
- Log file full problem.
- plz help urgent
- What's the DB2 connection string wihout DSN when use IBM DB2 OLE PROVIDER in windows environment?
- dropping a column in DB2
- About Reading ASC files - Urgent
- Strange Behaviour of SP due to GET DIAGNOSTICS position
- Expressions in an outer join
- DBLink to a SQL server
- Increasing SMS filesystem - AIX 5.3 running DB2 V8.1
- Increasing SMS filesystem - AIX 5.3 running DB2 V8.1
- Software Testing & Quality Assurance FAQ
- Invalid statement
- Clob as parameter in Java UDF
- catalogging remote databases
- SqlException Network IO
- DB2 Dynamic SQL Table Name in Field Value
- Moving sequence objects?
- Connecting to Stored Procedure from Crystal
- Error While Compiling UserExit program
- Reducing Pages HIGHWATER mark
- seek trick to insert a clob value from the command line
- DB2DIAG.log Error
- Decimal precision
- Size of a DB2 database
- Stored procedure for IMPORT
- Moving a database from v8.2 to v9
- about interrupt port and firewall
- Query access path question
- Help on a UPDATE query
- DISCOVER_COMM
- quiesce tablespaces for table use?
- Token SQL was not valid.
- Query regarding Backup
- Query help
- Quert tunning help....
- Query help
- Package SQLABD01 missing
- "... WHERE (a, b) != (1,2) AND (a,b) != (1,3) ..."
- Check varchar field numeric using SQL
- Index/Key length > 1100 chars
- Strange sort result on DB2 LUW v8.1.9
- Huge db2diag.log file
- Searching the Information Center
- Spilled sorts
- Collocation of Left Outer Joins
- 32-bit instance on AIX DB2 V9 ?
- DB2 Precompiler Problems !?
- how to tell if database is activated?
- Intra-partition parallelism on AIX
- CLI Driver CLI0111E Value out of range SQLSTATE=22003
- How does a bufferpool run out of pages.
- Db2 Express C db2diag.log error
- problem with a trigger
- Authentication in Windows XP Pro
- MERGE from TABLE INTO VIEW - DB2 LUW V8 FP12
- SQL0338N
- SQLSTATE 38553
- db2advis error
- UNION ALL not returning expected results
- largest value for INTEGER 4
- reorgs taking a long time
- Monitoring DB2 Performances
- Logon errors for local account appear on DC
- Best way to insure four columns are notthe same pair wise in thepresence of NULLS
- New to Db2 - installation question
- Store Questions in DB2
- db cfg setup and SYSLH packages
- db cfg setup and SYSLH packages
- DB2 v7 FP14 on Windows2000 crashing
- DAS Problem
- Logging dynamic SQL with query params
- Report layout design in Alphablox
- sql standards
- Problem with SPUFI
- Delphi UDF's
- DB2 content manager versus Lotus domino doc server
- optimize this?
- Snapshot Statement Monitor Decode
- execute COBOL via iDB2Command -- With Dynamic Parameters
- Query help
- software thuriam
- REORG problems with LONGLOBSDATA and PAGESIZE
- SQL0440 Routine .. not found with specified parameters
- MQT Help
- Doing updates/deletes in small batches...
- Integer binary representation
- SQL and variables.
- unable to run db2advis on restored backup from another machine
- How to create db2 database
- making identical table changes on many databases
- Query Help
- Urgent SQL0293N
- get event monitor state?
- Catalog non-db2 database on db2-udb
- Tablespace issue
- Occasional -30082 after an SQL1024
- DISTINCT and ORDER BY
- How to start the DAS in Linux
- Problem with Modifing MQT
- generate_unique primary key
- Syntax issue: URGENT
- SQL30082N reason 36
- How to expire DB2 backups in TSM ????
- V9 client unable to connect to V7 server!
- Tablequeue buffers overflow
- "Time waited for prefetch (ms)" very high
- XML Extender - CCSID to UTF-8 help required
- Locking problem
- Query tunning
- hi
- PATHCH2="15" is ignored?
- Tablespace reovery
- How to match a Java SQL Exception to the SQL error message
- Express C forum dead?
- How to backdown from DB2 v8 Fixpak 12 to Fixpak 10
- db2_install error
- DB2 Connection Problem
- IRC Forum for Discussing DB2
- Express-C (Linux 32-bit) : CREATE DATABASE fails
- DB2 9 Express C Functionality
- Restore DB2 from DB2 Legato Network Server
- List of users connected to DB2 UDB database
- what is the lightest-weight client query/statement?
- WebSphere Federation Server (v9)
- Uncommited Insert/Upd/Del Count
- DB2 9 for LUW is electronic GA
- Db2 in non-interactive mode
- INHERIT SPECIAL REGISTERS
- Command to get the size of DB2 database
- Federated Server
- ICREM BINDS
- DB2 audit
- query pre-processing
- Silly query question
- How to run LOAD or IMPORT from Java
- Can I see the rows deleted by LOAD
- Recovery tool for DB2E v8.2 on WinCE?
- HADR takeover by force during peer state - why does this end up with split brain ?
- TABLESPACE DROP AND REDIRECT RESTORE
- Table partitioning in V8.2
- DPF Question
- sql stored procedure questions
- SQL 0440N SQLPROCEDURECOLS
- db2uext2.cdisk
- Question about tablespace and container design
- RI to be enforced in tables containing data
- Cognos Cube with DB2 "UOW Waiting" status
- Cognos Cube and DB2 "UOW Waiting"
- Aggregate UDFs
- SQL_DATA_ACCESS set to 'M' in SYSROUTINES even though only selects
- Finding dependencies in stored procedures
- Index Optimization Question
- Replication - limit of 200 tables in subscription set
- same trigger problem
- SQL0670N creating table with 250 columns
- Migration / DEmigration
- Index tablespace
- Best practice
- Unable to Enable the DB2 Image Extender
- How to ALTER a table using the ALTOBJ procedure
- database Share Memory Limit (2 GB ) in a Instance is total of all Db shared memory of all databases in a single Instance!!
- migration db2
- List History Backup
- Db2DAS
- Bizarre Crash Recovery
- Query for file names like SC*
- New Problem Determination Mastery Exam in the works?
- MON_HEAP_SZ
- DB2 Personal Developer Edition and Spatial Extender
- unable to start db2 admin server
- db2 Backup using TSM
- Procedure Dependencies and Temporary Tables
- DB2 Application Dev Client (Fix Pack 10) on Windows 2000
- how to get agent id
- HOWTO: Make DDL changes?
- unique generated numbers
- Update Syntax SQL
- db2gov
- Db2 backup List
- DB2 and Java
- Help for a SQL Query statement: group by
- db2 connect to "psftggl"
- DB migraton failed from DB2 V7 FP13 to DB2 V8FP7
- xml Extender... cannot enable a column!!
- Referential integrity in DW necessary??
- DB2: Find most recent rows?
- Trigger design issues
- Micro-pump is cool idea for future computer chips
- db2Load API in C#
- Database requirements
- Able to Create a Procedure in DB2 V8.1 But Unable to Run it using CALL statement
- SQL30082N Attempt to establish connection failed with security reason "24"
- EXPLAIN and Global Temporary Tables
- bulk load very slow
- BIND, DYNAMICRULES and SQL Procedures
- What the heck are node names and aliases for?
- COMMIT statements in a stored procedure
- Speeding up Full Online Backups
- Should db2 allow this table to be created
- Something like base64_encode ...
- How to license DB2 in P570 server
- restore - mirrorlogpath problem
- Select Query - Looking for a better query
- Performance questions DB2 UDB 8.1.9 Linux Redux
- iSeries DB2 Delete Statement Question
- db2 v8.1 config question.
- User Exit Program
- Querying for Third Shift
- Accessing remote database via SQL
- Error SQL0901N without any Reasoncode
- Applying a patch
- DB2 Certifications
- DB2 SQL insert question
- db2 authorities very vague
- Performance questions DB2 UDB 8.1.9 Linux
- High Performance DPF INSERT's
- DBA / Architect - DB2 / UDB - Job Opportunity
- Emergency Help
- Error in replication log
- getting -805 for SYSLH203
- PlZ HELP
- Urgent Query
- Tablespace - mysteriously lost pages.
- INDEX setup on surrogate key
- SQL procedure tracing
- Error in executing SYSPROC.ALTOBJ procedure
- db2diag.log
- Migrating DB2 UDB on Solaris 8 to DB2 UDB on Z/OS 7
- Weird message in db2diag.log
- Trace,....
- creating a instance
- Variables in SP do not compare as equal when both are NULL
- DB2 VSE/JDBC
- SQL0440 - Routine XXXX in *N not found with specified parameters.
- set current explain mode recommend indexes
- SQL Optimization