Home : Bytes IT Community / View Full Version : IBM DB2
- What means this db2diag.log?
- Control center problem with remote accees from terminalserver
- Allow DB2 acces through db2connect only from delimited clients
- Where is DB2_BDINFO ?
- Problem with stored procedure
- how to create additional instance in different diretory----Help
- How could the optimizer choose to use the MQT
- Auto updating field created from the value of an IDENTITY field
- Exporting Records from AS400 file to an ASCII delimited file
- CLASSPATH
- sql0444
- bufferpool
- DTS from SQL Server to DB2
- V7 client and V8 client on same machine
- Retrieve and display unicode data using ADO and DB2 V7.2
- Message: data protection sqlpghck
- Can system catalog tables be pruned?
- drop schema problems
- INCLUDE in index
- RESTORE FROM
- cataloging database after unistalling -> installing db2
- SQL1651N exporting to/from db2 v8.1
- Message : DIA8309C Log file was full.
- problem while creating sample database
- Stop DB2 instance
- db2mtrk and instance crash
- Restore..why?
- LogPrimary
- Overflowlogpath
- 8.1 win and non-java command center (db2cctr)
- SQLForeignKeys ODBC call
- db2 resources on linux
- Suggestions for the DB2 Information Center
- copying logs then roll forward problems
- erwin and Db2 version 8
- [Google] DB2 query
- Good and up-to-date book on DB2
- DSNZPARM - New Bie's Quiestion
- db2 connect migration from v6 to v8
- Development Center
- Pattern to ensure executing ONLY required SQL statements ?
- ISERIES driver for AS400 return erroneous data for NULL Values
- DB2 Performance Issue
- Problem in V8 : db2 ? command
- Date roll over functionality
- DB2 major migration from V7 to V8
- Agent not allocated, sqlcode = -1223
- (no subject)
- US-IL-Springfield: DB2 DBA, 3-6 mo., analyze DB performance with native tools, Jan. start
- call db2dari proc pb on V8.1 FP4
- IBM looking for Feedback on Installation and Packaging - DB2 andWebsphere
- Creating a SP using the control manager
- data from several rows in one field
- db2 crash
- List or Force Applications by Auth ID
- Trigger Advice ? - Thnx
- How can I create groups?
- SQL Stored procedures
- test
- SOAP-Interface for DB2
- any community for db2 certified people
- DB2 multiple trigger activation order for column UPDATEs
- DB2 on As400 ADO.NET compatibality
- DB2 on As400 ADO.NET compatibality
- nonequijoin
- MVS DB2 tables - connecting with PC
- execute DB2 VSE operator commands from user program
- DBI1222W error when migrate the instance from 5.2 to 7.2
- Inserting CLOB data to OS/390 DB2 6.1
- SQL Stored Procs
- Advice sought on best way to get data into a Linux db2 8.1.4 database
- ESQLC --- Function Parameters as Host Variables
- UDB Commands
- Local or remote instances.
- 2nd CFV: comp.databases.etl
- proper way to shutdown db2
- Binding after FixPack installation?
- Problems when binding DBConnect against OS/390
- DB2 8.1.4 I/O Performance
- Problem with DB2 field type CHAR(n) FOR BIT DATA
- IMS database migration
- db2 language
- DB2Driver; rollback closing resultsets
- How to remove constraint
- DB2 Cube Views
- DB2 8.3.1 on RedHatLinux AS2.1 problems
- FOREIGN KEY CHECK ON INSERT
- DATE function problems
- Moving SQLJ Stored Procedures
- Turn On/Off Foreign Key Constraints?
- db2batch from windows client: SQL1427N An instance attachment does not exist
- Date parameter as a criteria for data in db2 accessed from msquery returns error
- DB2-SQL questions (grant...)
- Calling Stored Procedures
- translation error on windows services ?
- DB2 connect - user id question
- Backups for e commerce site
- Resolve Error for SMCODE: -28 relative to DBA4730E
- shared memory - can't backup
- DB2 SELECT COUNT(*) problem
- Memory hogging after restore with a warning
- Where can I download the DB2 V7.x personal edition?
- DB2 table space too big problem
- ListCleaner (winpure)....Opinions / Recommendations???
- Problem installing V8 FP4 on W2K
- load data with embeded New Line character
- UNION to implement default values
- DB2LOOK & Tablespace Containers
- DB2 V8.1.4 and backup compression
- SQL0902C with Kernel 2.4.23
- Strange authentication, when account is disabled
- Unable to have a key for trial version
- DB2, LINUX & WWW
- What is UOW Waiting in DB2 LIST APPLICATIONS?
- about incremental backup
- stored proc lenght limitaion
- 2ibmteam: SQL stored procedures call in statement monitor
- Strange suggestion in Health Center
- Hyperthreading / Linux / DB2 V8.1 FP4 - performance
- UDF for z/OS v7 Select value from a table
- Archive log
- UPDATE statement and unique constraints.
- DB2 and dbUnit
- storing DMS on RAID
- ADO and DB2 8.1 performance tuning
- trap in snapshot table fonction V8 FP4
- DBD::DB2 Bug - negative REAL causes Numeric value out of range
- Converting Informix SP to DB2
- new to DB2 and CLI0621E Unsupported JDBC server configuration.
- DB2Connect - SQL8002N Error
- db2ii_8 + WebSphereStudio_5 problem...
- UDB Log
- Using CachedRowSet Selecting a BLOB Column
- data migration from SQL server to DB2
- Sql DB2
- Can lock timeouts be logged to a file in DB2 V8?
- DB2 backup error
- dangling message queues
- VIEW based on Stored Procedure
- is it normal that capture can t read archived log ?
- SQLCODE -497 -how to resolve?
- Bad performance with like in cursor
- DB2_SCATTERED_IO vs DB2BPVARS (v8 fp4)
- DB2 Commit vs. autocommit performance problems
- problem with db2
- Export LOB's in different files
- Unique constraint or index as in Oracle and "alter table alter column"
- Delays in between UDF invocations
- DB2 7.2 EE and Redhat 9 Question
- Enable DIO option in DB2 V8 FP4 For AIX
- How get info about table use by application?
- DB2 V8.1 FP4 JDBC-Performance-Issue
- DB2 CHECK for names?
- Ist es normal das es mit der Version 8.1 Performance Probleme gibt?
- Gibt es eine DB2 Funktion/Abfrage oder View um die User/User Group abzufragen?
- Nach Installation der DB2 Version von 8.1 werden Datentypen nicht meht angezeigt.
- db2jstrt: 0403-006 Execute permission denied.
- db2jstrt: 0403-006 Execute permission denied.
- SQL1088W - V7 to V8 database migration failure.
- Current date - n days
- unexplained performance drop
- Select @@ identity ???
- Siebel query question..help
- Mail di prova
- Why would tweaking SORTHEAP, SHEAPTHRES, and bufferpool sizes disables prefetch?
- SQL help with clearing out old plans and packages
- cannot create DAS, already present
- Federated database
- DB SAMPLE
- Index usage on db2 v7 for os390
- move DB with LOB's from NT4, DB2 V7.2FP3 to AIX5, DB2 V8.1 FP3
- BLOB fields trouble
- Database marked bad. One more time.
- Tempspace full at MQT refresh in DB2 V8 for Solaris
- Connection Logging
- Is there a v8 equiv of v7 db2_kill??
- Do I still need a C compiler on production server?
- Change SP query optimization level
- NFS-Home and runtimeclient
- SQL Error Code -443, SQL State 38553 - what does this error mean?
- Finding Last Backup Timestamp
- db2 reset monitor question
- Migrating from SQL Server
- db2dart - should db be activated or not?
- Building Java SP for debug
- GET DIAGNOSTICS statement....
- creating triggers in db2
- No "POSSTR" after migrate of V7 DB to V8
- UK DB2 UDB Users Group (LUW and z/OS)
- Portland, OR DB2 user's group
- db2relocatedb error
- Cannot find ibmdadb2.h file
- Problem installing NSE on Linux.
- UDB's scheduler keeps going to sleep resulting in automation not running.
- poor select performance
- identifying which logs to ship to stand-by server
- db2start error on 2-node cluster
- Possible Export bug ? (May be IY44569 ? )
- DB2 Connect EE, just the drivers?
- Adding a parameter to a Java SP
- UDB session and db2flsn
- Can't connect to db
- Event monitor creation in Control Center
- SQL1086C An operating system error "" occurred on databasemetadata.getcolumns()
- DB2 grant permission steps
- Migrating from 5.1 to 8.1: Locking problems (isolation level ?)
- Dot Net OleDB data provider ....
- MSProject -> ODBC -> DB2
- Query Number of VSAM Datsets of a nonpartitioned Tablespace
- SQL question: how to select multiple row into one row
- how to create a default tablespace
- "Database Home" and "Instance Home" (the difference)
- Recovery on UDB
- problem with UDF
- running db2jstrt and jdbc type 3
- installing a java sytored procedure from windoze development centre
- Bitwise functions available
- DB2 CLOB datatype
- Export/Import functionality
- check-constraint
- Data transfer
- Declared Temporary Table in Cobol
- Temporal functionality in DB2?
- db2 table editor?
- SQL1131N DARI (Stored Procedure)
- Accessing DB schema ...
- db2ckbkp
- db2set problem - DBI1360N
- Execution failed due to a distribution protocol error that caused deallocation of the conversation
- wrong node names
- how to specify timeout for CLI SQLConnect?
- INSERT from existing records of the same table
- How to get rid of dummy entry from System Database Directory
- Granting User-id's with special characters on a UDB database.......
- DB2 7.2 restore generating system error 1326
- one query question
- replication problem: target database cannot be accessed during replication
- DB2 ICE ( Integrated Cluster Environment )
- VIEW with specified columns for update?
- Problem with replication
- Issuing a SET SCHEMA command in a trigger..
- increase UDF_MEM and APP_CTL_HEAP_SZ size
- UDB Questions
- Select sometimes returning subset of qualifying rows.
- any help for DB2 installation on AIX
- foreign key defs 390/v6 vs. 390/v7
- Package Cache Overflow
- help needed for installing DB2 on AIX
- Reorg on UDB
- 2 concerns on FP4
- Previous Versions of UDB
- instance crash during select
- [SQL] Problem with group by and max
- DB2 vs MySQL - performance on large tables
- SYSPROC.SET_ROUTINE_OPTS exists?
- Database marked bad.
- UDB 8.1 PE and Distributed Debugger
- Migration DB2 V7.1 to DB2 V8.1.4 (both Linux)
- DB2/UDB on UNIX:
- the performance of jdbc driver
- DB2 V8.1 FP 4
- IBM DB2 Version 2.0
- Concurrent update of two child rows locks one out.
- BCD from NT to MF somtimes garbled, sometimes not
- DB2: Oracle equivalent of Autonomus transaction
- How to get the dependency tree for functions and procs
- parameter markers - SQLBindParameter issue
- db2 v7 zos archive logging
- Second instance in local node
- log shipping using ftp
- Improve query performance on large table
- *urgent* [LOAD] UDB v 7.1 OS/390 DATE problem
- index limits ?
- Authentication problem
- compatibility question
- bookmark in resultset
- 390 databases in visio
- why the table create in different tablespace
- Determining fixpack level programmatically?
- db2 application error ADM5530E
- db2 XML extender & Performance
- Create wrapper error with udb v8.1 FP3 on Linux
- RUNSTATS and JDBC
- reason codes
- SQL3089N
- Create index filled up transaction log
- SYSIBM tables corrupted.
- Call Stored Procedures via ADO
- PHP connecting to DB2
- db2 mainframe SQL question
- database monitor snapshot on partitioned db
- Number of Containers on a RAID Device
- Retruning the first five rows of a query statement result
- DB2 V7 TS Partition level reorg with NPIs
- Federated Informix - how to djxlink?
- ALTER TABLE ... ALTER COLUMN ... SET DATA TYPE
- [LOAD] UDB v.7 statement: correct?
- How much space does a certain Data-Type need?
- Test ignore!
- aliases/nicknames for fields?
- Java stored procedures on different dbs on same server
- User Contingency in DB2 UDB 7.2?
- Warehouse job schedule error
- SQLJ - DefaultContext Synchornization
- export table without string characters delimiter
- Improve query time
- Low Performance...
- A simple question: How to echo a newline in script
- Help needed with DB2 UDB 8.1 ESE on HP-UX 11i
- Restoring DMS DB from multipe backup files
- JDBC, DB/2, Apache and TomCat
- JDBC, DB/2, Apache and Tomcat
- Error running SQLJ.INSTALL_JAR
- Desupport Date for UDB V6 on z/OS
- a short connection problem
- Recursive stored procs
- Exceptions from ESQL/C to DB2
- Is GENERATE_UNIQUE unique only within a database?
- NEED HELP - Query Conversion
- Delimiting Single and Double Quotes
- SQL0632N. Why can't a child table be related to multiple parents on multiple FK columns with the on delete set null option?
- DB2 Client v8 access DB2 v7
- PATCH1 settings not taking affect
- DATE: valid expression
- Problem running simultaneous queries DB2 v8
- Using a lot of Tempspace
- foreign key constraint slows down UPDATE performance
- DB2 CAF DISCONNECT and re-CONNECT
- store java class files
- french characters in file
- does DB2 (UNIX/Windows, S390 and 400) support dead connection detection
- DB2 fixpack == forklift upgrade?
- JVM start failed
- Access 2000 ole db use of DB2
- Command Center multiple databases
- Table and Column naming conventions
- ORDER BY - how to sort on different ranges?
- NET SEARCH EXTENDER
- Agent Memory, how to determine
- Import update from files in a directory
- Error SQL0035N when creating stored procedure
- What to do when you see error DES0333N with DB2 Text Extender
- Development Center
- transform row into col
- Federated Join EE to EEE
- Status Change Time
- jdbc type 4
- DB2 for Linux - Backup to NFS filesystem?
- Understand the big picture ...
- CLI to get database directory
- Health Monitor Emails and SQL Functions
- SQL question
- IBM DB market share
- Load Pending status
- db2 installation failure
- db2 load from
- Log command in history file question
- Syntax of the string representation of a datetime value is incorrect SQLSTATE=22007
- Can I do a revoke select on table in a stored procedure?
- DB2 7.2 workgroup edition: problem with installation on W2K
- DB2 7.2 workgroup edition: problem with installation on W2K
- DB2 - Include files for API create Databse EBCDIC
- syscat.packagedep
- capture access plans ...
- DB2 commit synchronization
- capture the access plans
- trigger updating another table gives SQL0206N
- When will FP 4 for DB2 8.x be released to the public?
- File writing performance
- CURRENT SCHEMA/QUALIFIER for DB2 Z/OS 8.1?
- Why DB2 creats so many new folders, like: "db2admin.MACHINENAME.026"?
- Soft permissions?
- insert fails - accessing AS/400 from MS SQL Server linked server
- Build of SP from SPB fails
- How to find out database state ?
- test ... please ignore...
- Selecting from a view built using UDFs
- Listing DB2 Constraints
- Create Table DDL: WITH DEFAULT question
- Test - Please ignore
- Exception handling within triggers
- SQL status '02000' too early!
- DB2 Everyplace
- udf that doesn't run in wlm environment ???
- How to use parameter markers for "for bit data" columns?
- Which one got problem? MDC or the optimizer ...
- How to change interface language?
- DB2/UDB 8.1 HA Failover
- How to find out the SQL statements causing deadlock?
- Problem on Linux OS/390 for Db2 Connect
- asnmig8 problem
- RunTimeClient vs. AppDevClient
- sqlureot (reorg api) in a stored procedure (w2k, v6.1, fp11)
- FW: Check the patch from MS Corporation
- SQL_ATTR_CONNECTION_DEAD
- SQL0401N on Check constraint on UDT column.
- Support for RedHat Enterprise v3
- COM.ibm.db2.jdbc.net.DB2RowObject.getDataFromBuffer
- Oracle VS DB2 White Paper // Request For Comments
- Only 1 of 3 columns per row can ever be populated!
- DB2 UDB V7 & V8 codepage difference - DB2 z/OS ?
- How to tell if a MQT is maintained by USER or SYSTEM
- error 99999
- ODBC question
- measuring internodal communication time on Linux
- DB2 (Common Servers) data layout in containers
- Stored Procedure Builing Problems
- Dump Files?
- Help me please
- PHP on RedHat 7.2 connecting to DB2 V6.1 database on Solaris
- DB2 Certification
- DB2 6.1 on RedHat 7.2
- How to get the last N records from a table
- LOAD question
- internal lock
- IX lock not released
- Insert Performance on a Partitioned DB
- information integrator & informix
- performance tools
- DB2 Connect Error SQL20081N
- DB2 Connect Error SQL20081N
- row level lock
- log shipping tables
- DB2 SQL Extracting and reusing labels from existing fields
- Running application from VB environment and .exe - differences
- Search many tables
- Stored proc compile error
- How to setup custom location for db2 source?
- Windows Domain Problems
- Windows domain problems?
- Asynchronous index reads
- Commits on sql questions
- sql error 911
- DB2 dropped into first gear?
- new to db2 - need help to get started
- Web Report Tools For DB2?
- Help me
- Where Can I locate current db2 connections by a client
- sqlcodes for failover
- multiple containers for a tablespace on the same file systems
- buffer pool hit ratio
- Performance problem (maybe cos of Terminal services?)
- Dont read!!
- Environment Variables
- yyyy from timestamp
- CAN WE USE AST(summary tables) in DB2 OS/390
- db2 installation
- Temporary Tablespace type to encrease performance
- ODBC Connection options from Windows Server to DB2 on AS/400
- DB2 V7 Replication performance
- DB2 shared memory and extended storage
- who can explain this?
- Snapshot from DB2 to Oracle
- lock escalation
- DB2 UDB V7: Ignoring a set of parameters problem
- Using JDBC batch
- stale cursor???
- ESE parallel db - how to drop a node from nodegroup
- joining several tables
- Heap used by process reported through pmap
- How can know the transaction per second
- copy db2 tables from region to region
- urgent ---SQLCODE: -805, SQLSTATE: 51002, SQLERRMC: NULLID.SYSLH203 0X5359534C564C3031
- db2jdbcbind
- transaction log is full
- db2_striped_containers
- configure parameter
- Information_schema
- Stored Procedure, C, OS/390, DB2
- fixpack question
- UDB 8.1 CLI/ODBC Schema Support for DB2/VM 7.2
- pmap on Solaris to monitor memory usage for DB2 and ipcs
- List of Instances on a machine
- Using Net Search Extender
- db2 connect with no response
- Access 2000 does not see summary table in DB2 UDB
- CLI connection failed. SQL0902C. A system error (reason code="6029321") occurred.
- 2nd try: embedded newlines in SQL in Java/JDBC v8 changed things?