Home : Bytes IT Community / View Full Version : IBM DB2
- load data into varchar column
- Relocate DB2 databases part 2
- How do i ensure 'insensitive' (ie static) cursors that are only forward readable (in DB2 for mainframe)??
- What is the connected database?
- Select the 2nd of a sequence of rows in a table
- SQL to get the max or min record which one is better?!
- What's incorrect with this function?
- Relocate DB2 databases
- DB2 Rollforward DB query status
- DB2 + shell script
- Is there a way to import tab delimited files into a db2 table?
- DB2 Table Editor Search Conditions
- load from cursor
- Sort after index scan
- OS/2 (yes) backup to XP Excel
- Inserting into temp table using Cursor
- Changing an index controlled partitioned table to table controlled.
- Alert notification time
- MDC + Partitioning Key
- SQL Query to concatenate columns
- Statement Isolation Level
- Concatenating rows ?
- generated columns for z/os
- Uregent finding difference between count of two coulumns
- How to get instance's server port?
- Selecting only letter and number characters
- SQL1031N error help
- UDB sort sequence problem
- report issue
- How do I prune db2rhist.bak and db2rhist.asc?
- Generating SQL Scripts from SPUFI
- How to find out the Java Version in DB2 personal edition 8
- select count(*) - Full table scan
- Convert DECIMAL to DATE
- Restore to new node using TSM fails
- Error while running sdl scripts
- Parallel Database
- WPAI on iSeries DB - Problem
- CLI Wrapper for .NET Platform
- DB2 UDB Error Handling
- Bulk Load BLOB using DB2 CLI
- Easy Group By Question (I think/hope)
- Puzzled
- How to do...well...anything...in DB2 SQL
- DB2 - Decode Compiled SQL Statements
- Exception Handling in DB2 UDB
- Restore into DB2 replication database
- Isolation Level inside C++ routines / Slow performance.
- Database metrics
- DB2_LARGE_PAGE_MEM
- db2exfmt - client
- Product license ? Run time client ?
- Preserving comments when creating SP's from Command Editor
- Comments in Selects DB2 v8,1.9 UDB Lunix
- Lookig for a copy of "The ABCs of Plans and Packages" by Nicola Nur
- Trouble connecting to DB2 in Visual Studio 2003
- DBA cert
- Urgett !! redirected restore of a tablespace
- How to kill idle connections or sessions
- Packages, Bind, Prepare and Execute
- Max Connections
- How to get my current connection id in SQL
- benefits of 64-bit db2 apart from addressability
- creating a Report
- have some fun and forget the problems
- CLP Execution
- db2 and the strip function
- DB2/COBOL Store Procedure Parmeter List (Reply)
- CPU Time (User / System) & Actual Elapsed Time for SQL
- DB2 8.2 32bit to 64 bit conversion
- Running a batch of sql queries?
- DB2/COBOL Stored Procedure Parameter list
- Multiplatforms?
- Could you clarify IY63894 ?
- More than one CURRENT TIMESTAMP in a PROCEDURE
- Is it possible to move the ICMNLSDB database from one drive to another?
- how ADM1822W could happen?
- DB2 RT Client silent install
- refresh view ?
- federation
- Import Problem Urgent
- JDBC Type 4 Universal Driver SQL Error Code = -99999
- Data Warehouse Cube View Control Center
- Package cache hit ratio
- DB2 Connect Ver. 7.2 Client Assistant Export problem in Windows 2000
- DB2 Connect Ver. 7.2 Client Assistant Export problem in Windows 2000
- delete statement after a RETURN CURSOR in SP ?
- Convert TimeStamp
- give me idea for this procedure
- give me idea for this problem
- Federated database and host privileges on SYSIBM tables
- Query regarding Index
- Debugging SQL stored procedure using developement center
- Debugging SQL stored procedure using developement center
- DB design
- DB2 Sample Test Question? Which is the correct answer?
- Basic SQL prcoedure question
- Problem using db2sql92 on host db2 (Langlevel or missing package)
- How to connect to the DB2 on a REMOTE machine from a C++ application on Linux?
- Connectting to as400 from DB2 ESE running on Windows XP
- Online Tablespace restore from incremental backups
- SQL0901N Error.
- Export af Tasks from Task Center
- DB2 ESE add Partition fail
- estimated execution plan
- FW: SR 603066805 : FW - Firewall in transparent mode with excessive packet drops
- Hast Du das schon gewußt?
- Special considerations to backup using ntbackup
- Report formating
- websphere vs sharepoint
- Aggregating strings
- Test database connection using C++
- memeory usage
- Licensing Issue
- my db2 routine deleting records with commit count ,any advice ?
- DB2 Replication Centre Issue
- online monitoring of sql statements
- Cannot Execute Create Server
- modelling tool
- Strange Errors in db2diag.log
- DB2 Certification exam 700 and 701 Question papers
- UDB: Backup Image Size & Used Pages Size
- problem with ibm db2 8.1 fixpak11
- urgent - Formating issue
- "SQL1024N A database connection does not exist" when using db2GetSnapshotSizeData and db2gGetSnapshot
- Import invoked from stored procedure
- external table function in DB2 LUW
- DB2/400
- Is DB2 8.2 ESE compatible with W2K3 Terminal Services?
- Problem with MERGE statement: SQL0969N Error Code: -788
- DB2 Environment Setup
- Provider cannot be found - Using current MDAC and Jet
- Restore DB2 System Tray
- DB2 Image Extenders
- INTRA_PARALLEL
- Pb load command JDBC driver
- db2 memory
- db2 memory
- Number of simultaneous connection
- How to combine fields by SQL
- Long compiling of SQL statements
- DBHEAP usage during backup
- fenced vs unfenced in DB2 UDB
- Performance problem after replication
- Learning DB2 for Mainframe - how "hard" is it? How do you do it ?
- Which SQL's are executing and what are they waiting on?
- QMF for Windows and Updateable Views
- Load utility vs reorg
- Explain history
- Views and privileges
- calculate size of table with BLOB
- Cause of excessive paging
- install studio 2005 addins
- DB2 Migration
- DB2 and LDAP
- Accuired eServer i5 570 - Enterprise Edition; questions..
- SQL30081N after RESET DATABASE CONFIGURATION
- import sql dump
- db2exsrv
- Tablescan - why?
- A few questions: LOAD/IMPORT/CLP stderr
- DB2 v8 used LDAP User Id/Password on Connect
- IBM JDBC driver behaves differently on Linux than on Solaris
- db2 zos v8
- CLP option not working as expected?
- SQL0444N Routine "db2spcat" (specific name "SQL060216094049640")... Error
- request the next value for a sequence
- 2 default database paths have been used - how do I not screw up?
- Bug (?) in SQL: Global temporary table gets truncated on failed insert.
- How to see the client type?
- More messages in db2diag.log
- Using Federated Objects
- Simple Insert using Case statement
- LOB Conversion from Windows to AIX Problem - HELP!
- truncate in db2
- converting oracle script to db2 (hr_main.sql)
- multiple insertions through jdbc
- Question on data placement re Raid10
- FP10 upgrade issues - AIX (v5 32 bit) DPF data warehouse environment
- Using multiple database contexts
- how to find the base table of an ALIAS ?
- Inapplicable message? DB2 UDB v8.1.9 Linux
- DB2 Type 4 JDBC Driver
- IBMSNAP_CAPENQ lock issue with CAPTURE_STORAGEMGMT_INFO
- Package "NULLID.SYSLH203 0X5359534C564C3031" was not found
- Strange S1010 function sequence error problem with DB2 V8 and Windows app
- blank text columns
- configure automatic maintenance from command line
- Deadlock
- Question for SQL gurus
- v8.1 (win2K) database files into v8.2
- strange behaviour with temporary tables
- Backup with maintenance plan
- v7.1 group by and SQL0134N
- Locks on table.
- ALTER TABLE ERROR
- Segmenting tables
- reorg and reorgchk
- DBMS maintained views
- the problem about load from cursor
- SQL1220N
- Urgent problem - hanging primary key constraint
- DB2 UDB Help
- sqloPdbRecvBuffer errno=104 Any ideas?
- Linux: How does db2iauto work?
- Stored Procedure Issue:Call Vs Loop
- Passing variable parameters to stored procedures
- Select Range Query
- Range Select query
- jdbc date format error
- Backup/Restore/Copy Schema
- LPAD Decimal value
- DB2 ldap catalog traversal api documentation
- BINDFILE vs PACKAGE
- Many applications in Compiling status
- Decimal Formating issue
- Converting cics screens to java/.net
- Current and Estimate Table Data Size and Index Size for DB2
- How to find out which of the record that has been updated after an appliction runs.
- ibm db2 lock (row/table) status/indication
- geting SQL0668N on file load, please help
- Avoiding SQLCODE -746 when calling procedures from triggers
- Second join based on the lack of success of the first
- question on index usage
- Connect to DB2 V7 and V8 in Java
- Problem with Information Integrator/Federated Datase - Oracle
- How to Alter size of an existing Blob Column?
- DB2 and Apple(Mac)
- DB is already in use by another instance, after system crash
- Great Job Board
- DB2 UDB WE 6.1 -> UDB 8.2 Express - Is migration possible ?
- myDBA - web-based business intelligence
- db2 7.1 fixpack 12 backup error
- Problem creating a new database
- DB2 Programing help
- HL7 and XML
- Call for Papers: The 2006 IAENG International Workshop on Internet Computing and Web Services (in IMECS 2006)
- Performance question DB2 UDB v8.1.9 Linux
- Run time error 3231
- Identity Column slow down the insert
- Question on determining heavy hit tables.
- Export data as well as the corresponding column names?
- " select * from sysibm.sysdummy1 where; ". Hmm...
- DB2 Type 4 JDBC Driver - Support for passwords with "|"
- Month question
- How can I add an identity column to an existing table?
- Need help creating Instance
- Executing procedure
- Connection hang with HADR takeover by force and old primary server is down
- How can i use a trigger in DB2 to call a webservices in .NEt please i new in db2
- Generating CREATE TABLE statements for a table
- Using a PROCEDURE to EXECUTE other PROCEDUREs
- Weird Error Message
- Newer to DB2 - How can I do this?
- SQL0072 ?
- simple SELECT sets exclusive locks on table
- Developing a Wrapper
- Import delimited hexadecimal or binary data to "varchar for bit data" columns
- How to get multiple child rows from different tables into one resultset
- updating the code of a query
- internal plan lock and internal sequence lock
- DMS tablespace size error
- Can I run the client CC on Mac OS 10? Just java, yes?
- Disable error message descriptions in Command Center
- restrict record deletions between tables.
- FP11 available
- Does DB2 UDB v8 come with a compare tool?
- Error in diag.log(-444)
- How to find partitioning key of a table
- Preferred Export Format
- Help- DB2 DBAs Needed in Midwest U.S.
- UDB date query
- Table queue overflows
- DB2 .Net Provider vrs OLE DB
- Rows read from statement event monitor
- db2 server monitor
- Parsing errors in db2diag log
- Failover of DB2 Tools Catalog on MSCS
- [db2clpex] How to pass the content of a clp-file as a parameter
- stale connections
- db2unit (DB2 Unit Testing Framework)
- hundred thousands BLOBs in database
- SQL scripts and Result set
- runstats sampling oddities
- Need DB2 DBA
- How to create a table, and make it undropable to the creator?
- Help with diaglog message
- How to find Execution time of Select, Insert and Update in stored procedures
- SQL Error "SQL3040N" when execute DB2import under DB2 version 7.2
- How to determine ALTER TABLE time?
- SQL statement for generating rows of intermediate dates
- Stored Procedures
- SQL0444N Reason Code 4 SQLSTATE=42724
- Determine Invalid Index
- String vs Numeric Type (2)
- How Db2 trigger call .Net web service ?
- regarding Date function
- Connecting to AS400 running on IBM with MS Access
- SELECT NULL VALUES AS ZERO
- Couple of HADR questions
- Couple of HADR questions
- update from V8.1 Fixpak 8 to Fixpak 9
- upgrade from FixPak 8 to FixPak 9
- Can not initialize a full refresh (SQL replication) on the apply side
- Identity column issue-SQL3526n
- Is DB2 multi-threaded?
- case insensitive select
- UDF Performance Question
- Failover problems
- Using Virtual IP addresses with HADR in addtion to automatic client reroute
- HADR split brain question
- please how to synchronise mssql database from db2/400 ?
- CLI without ODBC
- How can a CLI client get the return value after calling a stored proc
- DB2 Upgrade crash Domino 6.0.2CF2
- Updating IMS data from DB2 v7 Stored procedure (Z/OS)
- Error inserting into iSeries DB2 table with long name via SQL Server 2000 linked Server
- DB2 UDB Version 8 Workgroup Edition 64 bits, sources ????
- does DB2 support SELECT - INTO statement with ORDER BY clause?
- OS Command scripts never terminate in Task Center
- How to view date using sql
- QSYS type *LIB not found
- Query sysibm for record counts
- Windows Server 2003 SP1 and DB2 UDB
- User Defined Functions in Mainframe Enviornment
- CFP: The 2006 IAENG International Workshop on Internet Computing and Web Services (in IMECS 2006)
- Partition groups in DB2 8.2 on Linux
- Upgrading and FP 11
- Getting English Day Name
- memory usage in db2
- DB2 Connection String Problem while DB2 connection OPEN
- Low SQL cost and high execution time
- with UR is not recognised in DB2
- Auto delete rows older than a month
- Update Duplicate rows
- Regarding DAYOFWEEK function
- query tuning
- SQL select Crashes DB2 8.2?
- DB2 Connectivity problem from a wndows client to DB2 AS/390 server
- Equivalent of Sybase's @@transtate in DB2
- Table scan <--> Index scan, Version dependent ?
- Size of DB2 Incremental Backup
- Date Format problem
- Time is Running out to Submit your Presentation for IDUG 2006 - Europe
- Can I write an application with no server ?
- How to query the DB2 z/OS V7 dictionary for indexes?
- Removing Punctuations
- MERGE performance help DB2 UDB v8.1.9
- Right Align the character field Value
- a trouble of modifying procedure
- Retrieving Object ID's
- Stored procedure
- changing directory for data file
- containers in the same FS
- SQL statement parsing
- Store Procedures
- Impossible Relationship? Referential Integrity on tables with on From Date and To Date
- Dopping a schema DB2 UDB v8.1.9
- Load Flatfile in UDB (Server) from z/OS-Mainframe
- Load Flatfile in UDB (Server) from z/OS-Mainframe
- interface
- Pre-set default schema for new user
- Difference in response between Net Drive and App Drive
- A handy trick DB2 UDB v8.1.9
- Fedora Core 4
- How to get the current DB2 Version on v8 and higher.
- get_dbsize_info
- Timestamp problem after upgrade DB2 ODBC Client from 7.x to 8.x
- db2 8.2 client and vb6 ado refresh problem
- How can I drop a Column from a table?
- Clarification needed for HADR documentation
- Question about database migration from UDB 7.1 to 8.2 (FP3) on HP-UX
- Online Backup versus Offline Backup ?? What's the point ??
- Query optimizing problem
- current date minus date
- Performance impact of materialized views
- Questions on a 'shadow catalog' and ODBC
- Can't Install
- How to compare two columns in DB2 -Please HELP!
- Redirected restore - SQL2038N A database system error "127" occurred during processing
- Multi-Row Inserts on DB2 for zOS
- DB2 on zOS and Win XP Client
- client instance and server instance
- Displaying a CHAR FOR BIT DATA in C#
- Question about DB2 UDB 8.2 and 32-bit and 64-bit instances
- Grouping data by week?
- Load global temporary table
- DBD::DB2 not finding .so file on system startup
- Admin API reference for 8.2
- Important Information Regarding IDUG 2006 - Europe
- NFS problem
- convert application id which starts with "/"
- JDBC: Encoding Not Supported when connecting to Big5 database
- DB2 Client Upgrade Question
- DB2 Development Add-Ins for Visual Studio 2003
- DB2 vs Kernel Preemption
- Client-Server Conenctivity
- Reg:Migrate VSAM files to SQL server 2000
- very very slow query with parameters
- IBM DB2 Content Manager Vs IBM Content Manager OnDemand
- DB2 Performance issue
- Which predicates are stage 1 and indexable?
- throughput between application-db2
- Problem with package not found
- comparision between DB2 Connect and Shadow Direct
- type-2 index causing performance hit
- JDBC: problems using FETCH FIRST and FOR UPDATE clause at the same time.
- Equivalence for Sybase Functions in DB2
- Attaching a CLI-Connection to the static SQL connection
- Does DB2 Connect lisence needed for windows client?
- SetConnectAttr ODBC
- Query problem: sales volume comparision with previous year
- Automatic Backup/Reorg/Runstats Evaluation - How do you force a new evaluation cycle?
- Help
- Querying the Task Manager database
- Table Space size and Bufferpool page size
- Droping an index
- GRANT DROP on TABLE
- Stored Procedure Options: Modifies SQL Data and Results Set
- TCP/IP Error, rc1=22
- Crash when execute quiesce
- Migrate Sybase outer join query to UDB DB2 8.2
- Help-Sybase to DB2 migration
- DB2 books?
- need to restore old database (database server 4.01 AIX)
- There is no available conversion for the source code page "1252" to the target code page "0". Reason Code "1". SQLSTATE=57017
- Restrict Access by Application
- DB2 subselect problem
- Can XML data type be passed as parameter for procedure?
- Deleting data from table
- Log mining
- FCM_NUM_BUFFERS
- Calculate Shared Memory Usage
- Instance Creation Query - "db2iexec"
- insert into DB2 from SQL Server
- Transaction isolation level for stored procedures.
- Content Manager 8.3
- query to determine the Instance Name?
- DB2 JDBC addBatch truncates DECIMAL fields during inserts, if the last row has null values
- Connecting DB2/400 through iSeries Access drivers or DB2 Connect, which's more efficent?
- SQL0723N sequence + union all
- ESE -> WSE?
- Console disapears:Error in <EXE NAME="javaw.exe".. in DB2 8.1.8, Win Server 2003
- Dropping tables
- An internal error occurred. Report the following error code : "0xFFFF8544".
- Fixpack 11 for DB2 V8?
- Db2 Stored Procedures and File handling
- DB2 UDB v7 for z/OS TEMPLATE not creating GDG base for absolute generations
- [Urgent] validating Date field and saving into DB?
- commit and terminate
- DB2 join challenge
- Unique sequence object for each row returned from select statement
- Do anyone still have V8 FixPak 4 (U488486, not 4a) for AIX5?
- Error with Automatic Maintenance
- DB2 8.1.8, Win 2003: Steuerzentrale schmiert ab
- Any function in DB2 to help
- Equivalent to CREATE DEFAULT in Sybase
- Manually Add a Row to a Resultset
- VB8, Fixpak 10
- Migration of DB2 V6.1 to Windows 2000
- EXTEND USING option of CREATE INDEX command
- db2 connect problem
- How to elide leading zeros
- CHAR vs CAST DB2 UDB v8.1.9 Linux
- Help with 64bit Solaris 10 ...
- Stored Procedure - Aliases problem
- Requirement of Java/Oracle& All Skills with Valid H-1 B Visas --USA Opening
- SAP/DB2 Space optimised snapshot backup
- CSV file with Headers
- DB2 UDB 8.2 installation on HP-UX 11i fails
- Online or offline backup?
- how to determine the NUM_IOCLEANERS?
- Protocol specific error code(s): "10065", "*", "*". SQLSTATE=08001
- DBM Event Monitors
- Column Concatenation Function?
- Trouble with .NET Data Provider on DB2 8.1 Fixpack 6
- Error logging with Merge statemet
- multiple files for Backup
- Nested Case Statements
- Media controller -- Disk full encountered
- IBM JDBC help
- What is viper?
- SQL2048
- validation testing -- use TPC-C? (or what?)
- Some nonexistent tables in ASN.IBMSNAP_REGISTER
- Deploying the .Net Application with DB2 DataBase
- ORDERING by a FUNCTION() with simple-integer
- Show Related->Tables Spaces causes "CLI0611E Invalid column name."
- Installing DB2 on Solaris 10
- SQL22223N La instancia "DB2" no existe en el sistema principal
- DB2 Express
- split function in DB2
- Configuration parameters
- Performance issue: Need to force Optimizer use a specific Index
- Opening for IBM/DB2 Content Manager with 2yrs of Exp In Chennai
- Help- Migrating timestamp from Sybase to DB2
- Regarding MTK
- Can DB2 run on a SUN Ultrasparc T1
- RETURNS TABLE in DB2
- missing functions
- Views and Deadlocks
- Certification question
- Triggers using Uncommitted Read
- db2fm
- ResultSet cursor is forward_only from remote SQL/PL procedure ?
- Combine column multiple rows into one row
- DB2 Net Search Extender truncation
- HPU 2.2 Fixpack 3 on AIX
- db2start gives an error after DB2 installation
- Difference in between TIMEs
- SQL procedure permissions
- same query giving different out
- Suse Linux 64-bit ppc describe table issue
- Unable to Debug Java SP in Stored Procedure Builder
- Migrating from Teradata to DB2 EEE.
- One stop shop revoke tool
- Data of table not sorted by primary index in Control Center
- Safe cast from string to integer
- code page error
- maximum tablespace size
- Need Data Migration Points(Sybase to DB2)
- SOS - how to uninstall DB2 Express 8.1. on Windows Server 2000
- DB2 backup question
- Errors in diag log
- Compiled stored procedures in DB2
- JDBC Driver Failure
- reduce % of used DMS tablespace
- ccsid for db2
- Calculating Days/Months
- cluster
- No Privileges for User groups
- Restore 8.2
- Nullable Vs Not Nullable Column for Partitioning a Union ALL View
- the first connection to the database takes a long time....
- Retrieving timestamp with the Universal Driver
- identity column & import - need help
- how to make undeleted record
- Trigger fails when stored procedure is called two times in a row
- how to change the data type
- DB2XML.Content fails to export into file
- Changin Hostname ...
- SQL Problem with date ranges
- understanding health monitor output
- query bailing out after one row returned?
- Calling a COBOL Subroutine from COBOL/DB2 Stored Procedure
- DB2 on Windows to DB2 On Mainframe
- Synchronize Outlook data with db2
- Failure of odbc_num_rows sometimes
- "db2ilist" and "profiles.reg" Question
- Regarding Migration to DB2