Home : Bytes IT Community / View Full Version : IBM DB2
- Problem with Catalog database
- Can you Fool DB2
- Memory is full
- How to delete data from a table quickly
- Transpose rows to column
- Personal Edition
- Stored Procedure commit point
- stored procedures problem
- PROBLEM WITH CLONING A DB2 SUBSYSTEM MORE THAN 1 HLQ FOR VSAM
- V8.2 - How to stop SPs always being explained?
- Fixpack 7a
- Two questions about "alter table tbname activate not logged initially"
- db2advis
- db2advis
- db2Advis
- Migrating from DB2 UDB 6.x on Solaris to UDB 7.2 on Linux
- Same query, different access plan in Prod. and Dev.
- How to find build level or fixpack level?
- DB2 8.1 FP 7 on AMD Opteron
- db2 v8 on windows
- why should temporary table space page size matter?
- /usr/lib64
- Fifty Thousand Foot View needed for DB2 audit capabilities
- DB2 Explain
- Database backup & Schedule problem
- Problems with setting up replication
- Max length name of a database/schema
- Time functions in db2
- AddNew Fails when too many fields are added
- simple csv export db2 with *column names*
- Development center
- connecting to the DB2 UDB Windows 2003 Server
- SQL-Statment that add to strings
- ROW_NUMBER on ZOS/OS390
- Import and triggers
- Adding a column - Column oder a concern?
- Load Problem With MDC Table
- DB2 8.1 Client
- Kernel Parm Settings for DB2 v7.2 On SuSe 9.1
- Help with UDB and MQSeries. Can't use the UDF wizard to create MQ UDFs
- Where can I get the DB2 backup/restore errors?
- Federated Database: performance problem with outer-joins
- table index organized ?
- Weekend date for given a date
- Backup DB2 MVS OS/390 7.2 and Restore to DB2 UDB AIX 8.1.6
- Weekend date given a date
- How to integrate ForUpdate iterator in Development Center
- Floats become decimals when read from a resultset.
- Lock Mode QUESTION
- UDB 8.1 FP7a / Error DBA 1107
- UDB 8.1 FP7a / Error DBA 1107
- Online reorg and super exclusive lock cause many problems
- Deleted Backups on Control Center
- Can I ALTER a column to have a DEFAULT
- db2dari processes remaning after db2stop/db2start
- Tomcat DB2 connection - No suitable driver
- communications error when starting with multiple "nodes"
- change log path
- licences
- Move from Solaris to AIX
- Length of Data in CLOB Column
- DRDA and accessing a db2 database hosted on Windows 2000 from OS400 V5R2
- Is it bad to see "High water mark for database heap = 4291373408" when the server has 4G memory?
- DB2 SQL Stored Procedure Build problem
- DB2 8.1 installation error
- Need to connect to DB2 via a CLIST
- aix db2 client
- Statement Problem Update
- Online SQL query simulation DB2`
- any way to obsfucate a stored proc?
- Guide to Clustering using Linux and multiple machines
- Colocated join question
- db2look didnot get all the admin cfg at all
- Deleting all Data in a DB
- get time in a sp
- rollforwaring a database which is NOT is rollforwarding state
- How can I resale or return DB2 8 and QMF?
- Mystery db2agent Processes
- V8.2 - SQL/PL Continue handlers not working?
- DB2 8.2 on Linux - Table Functions get_dbm_cfg get_db_cfg
- parsing dynamic sql and removing constants
- UDB 7.2 DB binary-compatible between OS/2 and Windows?
- [IBM][CLI Driver] CLI0112E Erreur d'affectation. SQLSTATE=22005
- unixODBC client problems
- runaway/zombie fmps slowly starving engine of resources?
- Health monitor causing issues!
- can't start db2isetup
- trigger question
- DB2 64-bit fallback to 32-bit
- 64-bit to 32-bit fallback
- JAVA :: Timestamp from DB2
- Need DB2 V7 Sample programs for CLOB and BLOB's
- nodes can not be uncataloged
- How do i connect UNIX TO UNIX Machines???
- How to change a NOT NULL column to allow NULLs?
- how to verify
- more instances
- Apple clients for DB2?
- Somewhat obscure Q about clustering
- FYI: DB2 UDB V8.2 on the Windows Environment
- Bufferpool size Problem
- reason code = "54"
- Optimizer bad with sparse keys?
- 8.2 - recursive sql procedure
- DB2 - send mail via SMTP-Server User-ID?
- Comparison of DB2 and Oracle?
- Error Calling SPROC that returns multiple result sets
- runtime.zip and Dev Center
- What Next ? A Google DB Engine :)
- Automatic Client Reroute with Type 4 Driver
- 8.2 registry differences
- Help w/ stored proc creation - extract only numeric from alphanumeric
- database in an inconsistent status when doing DB2DART
- DB2 Linux - AIO and DIO questions
- restart replication on new database copied from old database without full refresh
- Alert or Preventing data entry?
- Warning message in Linux db2 8
- Automatic RUNSTATS in 8.2
- security holes that have been found.
- Row Locking Problem
- pagesize increase or longvarchar
- Runstats Command Question
- Dot in usernames
- Using Blue Phoenix for VSE->z/OS?
- v8.1 authentication question
- Information Integrator 8.2 Download ?
- DB2CONNECT "DIA3202C The TCP/IP "
- Using a lot of sequences
- CAST function and performance
- XML Extender result rows prefixed with the <prolog> and <doctype>
- Restoring DB's without Backup?
- Two Way Replicaiton
- Loading Long Varchar for Bit Data
- UDF with exception handler possible ?
- multiple instances
- Does DB2 support inline views?
- Help using columns from Left Outer Join in query
- Query help - MIN
- Very Basic Question: What is the DB2 Admin. Server (DAS) used for and is it ...
- How to convert this Oracle SQL(CONNECT BY) to DB2 SQL
- View permissions
- GRAPHIC and VARGRAPHIC encoding
- Copy structure
- error with db2udp.dll on db2 version 7
- Does DB2 sort an empty resultset?
- What does the error (Reason "Can not enforced Maxcard > 1".) mean
- "releasing" unused tablespace pages
- How to specify column header titles in a SQL CREATE TABLE statement?
- stored procedure runs on udb8 but not version 7
- An issue with UPDATE via UNION ALL view
- How to change Tasks from using local id to domain id?
- Row table locked
- Java on iSeries: setBinaryStream problem
- Cannot create database....SQL1225N
- How to get structure of temporary table ?
- DB2 Design Advisor with huge workload?
- get the right side of string ?
- continue handler question
- Deadlock on a Prepare?
- how good is the information from EXPLAIN?
- db2 snapshot database log information
- Problems changing the IP address of a W2K3 system with 8.2
- .NET integration and development - best version of DB2 to use, tools, etc?
- DB2 install on Gentoo Linux
- INSERT INTO .. SELECT with BLOB columns
- Maximum length for table names, colums etc.
- DB2 DBA for UNIX and DB2 DBA for OS/390
- SQL correlated subqueries
- Calculation of seconds for a month
- Redirected restore
- DB2 Connect version needed for DB2 v6.1 (Mainframe)
- Replacement CD?
- SYSCOLUMNS - COLTYPE or TYPENAME?
- DBHEAP configuration for buffer pool size
- Backup ok but restore not working
- Failed SQL statedment w/DB2
- Design advisor feedback
- Where is the "bit data" flag in the System Tables?
- Executed SQL-statements in a logfile?
- V8.2 Trigger - NEXTVAL FOR seq -- behaviour change?
- how to set variable using dynamic sql
- how to set variable using dynamic sql
- Merge does not work on 8.1.0
- Do u often use OODB?
- How many pre-decimal positions/integer digits has a DECimal (5,3) defined field ?
- Transferring ODBC Connections from one PC to another
- UDB V8.1 Feature
- Copy of database
- Page fault during backup
- CALL in TRIGGER and SQLCODE -746
- ordering a long varchar column
- Computed columns in DB2
- Problems with incremental backup UDB 8.1
- Problem with a view
- Application Development Client and XP SP2?
- SQLCancel not working with UDB?
- DB2 V8.1 does not accept the adDBTimeStamp data type
- DIA500C in db2diag.log
- DB2 Vulnerabilities
- Good DB2 book?
- db2cc fails on 64 bit AIX 5.2
- Proc Language in 8.2
- Average Num of Active Connections On DB2 Instance/ Small NUM_POOLAGENTS
- Two different versions on DB2 on Window box?
- Problem with a simple union
- CPU usage in connection concentrator
- Parallel incremental index build during load operation
- db2.->pam ldap -> edirectory
- Arithmetic overflow/other exception - what to do to find the source?
- DB2CC and XP SP2
- db2 -> AS400 (sql statment error)
- copy a db2/zos table with a blob column
- two phase commit?
- getting a com.ibm.db2.jcc.a.SqlException
- Finding locks
- db2 import and microsoft host integration server
- db2 - indexes
- Help with like predicate in update trigger
- ?example after insert trigger doing update on inserted row?
- SQL help
- Problems installing DB2 Contol Center.
- simulating ldap with db2?
- container recovery
- SQL10004C error
- How do I redirect ouptut from the List Database Directory command from DB2 CLP on AIX to a file?
- Calling a stored procedure from a trigger in DB2 V7.2 FP10
- Create a cursor and fill it dynamically
- how to drop constraints within a table
- Using sequences from external programms
- varchar vs char
- the market value of SQLJ
- Database Manager agent configuration
- DB2 Connection Pooling
- ruminating on 390 performance vs. VSAM
- db2syscs.exe CPU usage 100% & db2empfca failing
- DB2 UK Education Conference (16th / 17th November 2004)
- See the good, the bad, and the ugly of your DB2 data with OneClickRevelation(tm)
- End of service for V7.2??
- Checksums question.
- v8 FP 6 Affect on Data Warehouse Center
- set integrity after load
- V8: Difference between FP7 and FP7a?
- 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