Home : Bytes IT Community / View Full Version : IBM DB2
- Database backup in V8
- UDB 7.2, LDAP and ODBC Data Sources on Client
- page was victimized
- Cannot run scripts from Script Center
- Missing Summary tables after Restore
- Error using autoloader config file in V8
- Issues with LEFT JOIN through ODBC iclient Access
- DB2 Command Question
- Intra-parallelism Parameters
- Passing a java array in to a DB2 stored procedure
- DB2 FP4, BackupCompression
- DB2/UDB 8.1 (64bit) restore to DB2/UDB 7.2EE (64 bit) under AIX
- UDB Query
- Getting Offset error
- db2mtrk
- Error running db2 utilities on ZOS
- referred more than once in access plan means?
- Index on CHAR(N) FOR BIT DATA?
- db2 db2wa.war deployment on websphere.
- Better index access = worse performance??
- unable to get result data using php
- FP backout
- views and db2look
- DB2 capabilities
- CHANGE SERVER NAME INTO ODBC
- How to check Application Client installed or not in Solaris?
- Can not uninstall DB2 V8.1 FP4 under Windows 2003 Server.
- Windows query tool for DB2/400
- Unable to allocate new pages in table space
- DB2 Stored Procedure in REXX
- Updating columns w/ same value - will DB2 optimize for me?
- Upgrade DB2 v7 -> v8 and new server h/w. Best approach?
- UDB 8.1.4 & VB6/ADO
- Equivalent of VARRAYs in DB2
- SQL5035N The database requires migration to the current release.
- Where can i find Natural for DB2 programmer guide?
- Problem with db2mscs
- Does anyone use database modeling software?
- Unable to See"Sample Contents" of a Table
- Pseudo Check Constraint
- yipeee!
- RI violation. Has somebody ever seen this?
- Migrating from MsSQL to DB2/400
- RAID5 and tablespaces
- importing data from customer workstation
- Health Monitor
- How to set default schema name?
- Intermittent Beep
- Problem with locks
- Failure while installing Event Database. TEC 3.9
- Exporting large tables with a lob column
- Union in Views: No Branch Elimination because predicate with NonCor-Subselect ?
- Need help with error: The specified driver could not be loaded!
- Which tablespce is used when running ALTER TABLE & CREATE INDEX
- v8.1 fp2 application server for DB2. Where is it?
- How to list tables in order (parent & child relationship)
- DB2 Archive Log from Tape to DASD
- Create server error ...
- Did you know... that IBM's DB2 websites are now "googled"?
- checksum question
- DB2 suddenly become unable to NIS authenticate?
- how UDB reuse the Secondary Log Files
- Using GROUP BY and MAX() to ignore NULL ?
- Migrating from Solaris to Linux
- Recovery after Crash
- COLLATE USING IDENTITY
- DIA7523E, Error in Generator?
- SQL1092N "" does not have the authority to perform the requested command.
- Communication error SQL30081N ?
- Import vs Insert into with select
- Why no unsigned integers in DB2?
- FP4a 32 bit Aix compatibility question
- transaction log
- Clearification of 32 and / or 64 DB2/UDB 8.X backup restore under AIX 4.3 and AIX5.2
- How to determine field length in an unicode database
- db2 export - how to make it faster
- How to trim leading zeroes when converting decimal() to char()
- Uninstalling IBM Distributed Debugger?
- Reference books - DB2 C/C++ App development
- DB2 8.1 AIX Client Installation Problems
- dxxShredXML limitations, dimension limitation?
- UNIX UDB V 7 - In db2diag.log interpreting Obj={pool:1;obj:2;type:128}
- LDAP to populate SQL 2000/Active Directory
- convert rows to columns
- Administrating configuration data on clients
- backspace and delete button in command center
- "SQL1035N No database manager SQL1035N No database manager command was issued. SQLSTATE=57019
- Kinds of drivers for connecting to DB2 on os390
- Does os390 db2 version 7.1.1 support olap function
- jdbc driver for os390 db2 version 7.1.1
- Db2 version 8 on os390
- pagination
- export from DB2/390 as del
- DB2 and File Replication
- different tablespace containers has same bad index page error
- Relative Performance between SQL Procedures & SQL Functions
- Problem when migrating DB from v7 to v8
- Defragging removed Data Warehouse Center services ??
- Websphere DB2 Connection problem
- Data modelling tool for UDB 8.1
- error from db2dart
- novice question about password
- inspection result from db2dart
- using smtp on DB2 V8 for windows XP
- Slow Trigger
- sql can't execute on different condition
- How to find the C compiler
- help on error from db2diag.log
- extract from db2diag.log
- listing user created stored procedures
- ado updatebatch problem
- W2K did not restart DB2 service as specified in the 'Recovery' properties setting
- Do you have to always specify schema when using db2 CLP?
- replication troubles
- SPUFI
- how to validate the RETURN CODE in db2_all
- the size of db backup image
- test
- 1
- Problems debugging Java Stored Procedures in V7.2 FP9 (WinXP)
- Log Mirroring + User Exit AIX
- accessing databases
- Catalog DB Problem in 7.2
- No answer for your problem ?
- Case INsensitivity for string comparisons
- Control Center - current query opt error
- SET CURRENT SCHEMA in a Trigger or Procedure
- Please Recommend Books
- Backup - without getting an SQL0290N ?
- Finding % of used space in container
- Control Statements in Command Center
- SQL - Update stmt
- DB2 server & fixpack installation step
- Java Stored Procedures in DB2 V7.2
- comp.databases.ibm-db2
- DB2 Cluster with Peoplesoft
- ICM question for searching
- stored procedures developers guide
- db2 and lotus notes
- IDS to DB2 conversion
- callerac value or response in REDIRECTED restore
- How to find indexes working on a temporary table in UDB AIX.(UDB 8.1)
- Server buyers database
- Redirected restore, when only Instance is created & cataloged
- Count(*)
- yo
- db2 recepies
- Peoplesoft on Federated UDB?
- What is the best way for storing lengths in a database?
- db2 event log
- db2 connect
- Rollforward recovery...another question...
- Invalid Handle
- Remove import file after load
- Unable to create test DB2 database
- Change SQL Terminator for SPUFI
- Windows & DB2 - need administrative access?
- Binding after Fixpack Installation
- Remote User Defined Functions
- Inserting Multiple DATE values into a column.
- Problem creating raw container on RedHat
- rebind after DB2 client upgrade
- Replication
- Problems creating a task in DB2
- Using common table expressions - in line views
- SQL Joins and Cost
- Converting from unix timestamp format into db2 timestamp format
- Catalog system/database from DB2v8.1 to DB2v7.2 using CCA
- SQL1220N The database manager shared memory set cannot be allocated.
- column wise array insert hangs !
- select on table T1 while importing into table T1
- BackUp and Recovery for DB2
- Calculating Business Days
- SQLERROR -204
- Tablespace Design
- Max container file size for W2K
- Tables without indexes
- Trigger to create flat file for new row in table
- select * from table AND navigation
- text extenders error can't find indexes
- Tablespace conteiner I/O statistics
- db2 for educational use
- Compile-link options for DB2 V8
- Scheduling a Task
- Problems Converting T-SQL code to SQL PL
- rank(), denseRank() etc...
- getPrimaryKey on Db2
- Java procedure and the "alter sequence" statement
- different chr(0) handling in v7.2 and v8?
- Export an ixf file to ASCII
- BACKUP DATABASE
- SQLZ_DISCONNECT_PROC in V8 FP4 Stored Procedure
- ADO performance problems
- question on embedding literals in load statements
- add dbpartitionnum
- Distributed Database for OLTP?
- Log write batch performance problem DB2 V8 for AIX
- Cobol Stored Procedures in DB2 on Windows
- DB restore
- resources for preparing db2 interview
- is there something similar to Oracl'es metalink for DB2
- db2relocatedb trouble
- learning mainframe db2 without mainframe
- Enabling INTRA_PARALLEL config - does it help?
- FixPak Disk Space
- C stored Proc problem on AIX
- internal db2 rc
- Logistics of DB2 Administration Certification
- XML Extender
- Starting DB2 Universal 8.1
- User IDs with special Characters
- storing in mixed case
- How to connect the DB with user created manually?
- Used Space for Tablespaces ESE/DPF
- DB2 Version 5 - Module DSAA not found error - Please help
- Rollforward recovery algorithm...
- Need Help Converting MS SQL Server Stored Procedures to DB2
- Works in one environment, not in the other
- List sequences?
- Counting connections per user using sql
- Unable to restore a v7.02 saved database into v8.1
- DB2 EEE autoload fails due to insufficient storage (SQL3011C)
- Multiple queries in a single SQL string
- Documentation CD for V8 ???
- DB2 Configuration Advisor issue
- DB2 Data Provider for .NET
- IMPORT'ing XML
- SQLprocedures() API performance on UDB 8.1
- PHP, DB2, iSeries, PASE, binary field question
- SQL1131N with INSTALL_JAR on DB2 7.2 FP11
- Loading data and keep available
- Bug: SQLGetDiagRec returns SQL_SUCCESS_WITH_INFO
- Invalid fullselect specified for MQT, more info available?
- DB2 UDB Admin tools
- "RenameArray: add unarchived log" and "Common - OSSe - OSSHIPCSemaphore ... Time out" in db2diag.log
- Create partitions on FOR BIT DATA column: how to?
- How to create a db2 subsystem and then databases for DB2 V7 for OS/390 ZOS
- V7 data transfer/load into V8 databases
- DB2 install problem
- Sybase to UDB conversion
- DB2 SNMP Support on V8
- how to find out this ..?
- Multiple DAS server on the same machine
- CTE0190 Executable program "cteadmsv" could not be started
- Problem with Fault Monitor Coordinator
- Experience witch CLOB ( and COBOL )
- DB2/zOS: when VARY WLM,APPLENV=name,REFRESH
- How full is my Tablespace Container?
- Standard scripts for basic montoring of db2
- parallel strategies within db2 udb ?
- DB2 UDB 8.1.2 client: problem with SQLGetFunctions
- Method which acceses a reference to another object
- SQL STORED PROCEDURE
- How can I kill a pending job ?
- Beta testers wanted for new "blueshell Data Guy Professional"
- Performance improvement for Stored Proc resolution
- Problem with installation of DB2 UDB ESE on Solaris2.8
- datalink in DB2
- db2xml.update problem
- Backup using prefetch size for reading.
- V8 migration - Control Center errors
- Create v8 FP4 DB from v7.2 FP4 bkup
- Problem with ResultsetMetaData with DB2 universal jdbc driver(Type4)
- delete child table rows based on predicates in a parent table
- Memory lack
- Deadlock or timeout on executeBatch()
- twophase-commit via gateway to host-db
- Bug in calculating ISIZE for REORGCHK on indexes??
- CLI call SQLTables and RTRIM
- Trigger and nickname
- ODBC Connection
- DB2 Migration from 7.2 to 8.1
- DB2 UDF calling external application
- SQL Stored Procedure Question
- SYSMON
- Installing DB/2 8.1 on RedHat Advanced Server Version 3
- Performance of SQLProcedureColumns() API in UDB 8.1 ?
- How to speed up database scripts
- Dynamic SQL in table SQL UDFs
- Configuration Advisor
- Memory and bufferpool issues
- What ARE these HFS datasets for? (Os/390)
- aps_general_service
- No results in command center
- No Call in UDF, what other options?
- BLOB in Table
- DB2 book suggestions
- How to get catalog information ?
- BETWEEN operation on TIMESTAMP fileds
- kocham was niedorajdy
- DML Transaction List
- DB2 Security
- installing UDB v7 local Administrative authority error
- Call Java Stored Procedure fail after Migrate DB2 V7 to V8
- DB2 8.1 PE Installation on WinXP -- Invalid User Authority
- sysibm.sqlprocedures performance on UDB8.1 (Solaris)
- Is there a way DSNZPARM using db2 trace's - DB2 on OS/390 zOS
- Connecting to database
- VB.Net (OLE) Stored Procedure problem
- 64 bit - Windows Liberty 64bit, Windows Limited Edition 64 Bit,Microsoft SQL Server 2000 Developer Edition 64 Bit, IBM DB2 64 bit - new!
- DARI memory utilisation
- Historic data on index utilisation?
- DB2 Windows Client
- Control Center on Linux
- DB2 UDB 8.1 for Windows installation questions
- Sample UDF "Counter" -471
- Strange JDBC error when retrieving data
- DB2/zOS: Recreate DBRMs from remote bounded packages
- CPF5257
- is there a recover "db2 subsystem" command in DB2 for OS/390 ..?
- db2diag.log error : sqm.sqlm_log_ev_err
- Which gain better performance : multiple columns or use SQL built-in function?
- Equivalent of Oracle "@" in db2
- using Admin API from within Java
- Are people using db2 on Windows?
- db2 hangs when connecting with jdbc
- Delphi + IBM DB2 UDB (under MS Win 32) with Ado
- Bufferpool access on insert
- DMS vs. SMS on RAID 5
- Error establishing simultaneous DB connections in UDB 8.1.
- Net Search
- is it possible to pass 2 SQL statements in a single call ?
- external scheduling in datawarehouse center
- problems creating a simple stored procedure in DB2
- How to decrease primary log space usage during restore?
- SQLCODE -104 in CREATE TRIGGER
- indexing documents with datalink datatype
- [V7] Problem with memory ?
- Possible to update a file for all w2k servers via script?
- db2 api sqlesetc() not connecting to catalog node
- Version Control
- parsing a comma-separatinf list
- db2 full-incremental-delta restore/recovery question
- SQL Stored Procedure
- DB2 UDB 8.1 on HP-UX 11i installation problem resolved
- db2javit.dll error starting Control Center (or any GUI app) with DB2 8.1 on Windows
- More than 254 chars in text DB2 client
- jdbc-error from linux udb81.4-client to windows udb 8.1.4 server
- No nicknames shown in control center V8.1.4
- What means SBDB?
- Diag.log. data protection sqlpghck
- v8.1.4 new features
- Archived log path directory
- Unable to load data that has * value
- UDB 8.1.4 and MS DB2OLEDB driver
- db2connect to connect Windows client to a DB2 database on Unix platform ?
- Can a COBOL batch program CALL to COBOL batch db2 program?
- Strange 'cnv' ?
- CPU usage of DB2_USE_ALTERNATE_PAGE_CLEANING setting in V8.1.4
- DB2 SQL Statement Optimization
- DB2 on Mac OSX ?
- Drop and Create alias statements took a long time (7.2 FP7, AIX)
- Double datatype value display in select statament
- ODBC drivers, .NET providers, OLE DB providers, JDBC drivers: updated lists
- CASE problem
- newbe question: convert codepage
- DB2 OLAP vs Hyperion Essbase (version, package)
- Update 'db cfg' to all servers via script
- Table statistics
- Web Tools
- SQL0501N during import
- one server, two version, instances with different vision-- is this possible
- How to change the isolation level of a database alias
- data space missing in user defined tablespace
- -805 Error
- SQL PATH?
- GRANT BLOCKING IP
- Redirected Restore of DB With Stored Procedures
- Redirected Restore of DB With Stored Procedures
- GRANT BLOCKING IP
- SQL0805N
- Windows installer error when installing fixpak 4
- Function "1"
- about replicated summary table on two base tables
- 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
- 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
- SOAP-Interface for DB2
- any community for db2 certified people
- DB2 multiple trigger activation order for column UPDATEs
- 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.
- 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?