Home : Bytes IT Community / View Full Version : IBM DB2
- Failure of odbc_num_rows sometimes
- "db2ilist" and "profiles.reg" Question
- Regarding Migration to DB2
- Recursive programming in DB2 UDB v8.2 Stored Procedure
- Create a DB2 UDB database Manually using script(s)
- Getting SQL0901N error with SQL State: 58004 on running explain plans
- Mysterious error
- Performance Problem
- Conversion of 'FOR BIT DATA' string to normal string in DB2 V7
- direct SYSADM authority ??
- HADR and C Storred Prcedures
- CLI0119E from "call sqlj_install_jar()" in PHP
- SQL1031N connecting to remote database
- automated Install of DB2 connect
- Opening for DB2 UDB DBA - MNC,Bangalore,India
- Can't rollforward due to large bufferpool size
- Can I install DB2 UDB V8.1 on RHEL 4?
- column rename on z/OS using object comparison
- Migration of DB/400 to UDB on ISeries
- Executing UDF from SQL Stored Procedure
- CLI0005W from query with join in PHP script
- Error defining table function
- Beginner question: a lock without exceptions?
- Synchronizing/Replication between MS SQL & DB2
- Using Net Search Extender on Typed Tables
- db2 load with named pipe gives sql3025n error
- Problem while copying BLOB from one table to another.
- Full path in EXTERNAL NAME on Windows?
- Summary Table - Optimizer not using if ORDER BY in query
- Geodetic Extender?
- SYSPROC.SNAPSHOT_APPL_INFO Permissions ?
- Precision of results
- Design Consideration?
- Java UDF: Checking if anything in scratchpad
- Client reroute with DB2 JDBC driver
- Validation of user logins
- SQL1131N after installing a new shared library.
- Drop Database Error
- invoking external function with the definer privileges
- JDBC: DatabaseMetaData
- Smple java UDF not working: SQL4306N
- DB2 list application hang
- DB2 problem when accessing via a web page
- SQL0902C A system error (reason code = 9") ocurred
- Pushing content of a file into a varchar field?
- DB2 for Z/os version 8 DBA certification Guide
- Inserting into federated DB from trigger
- Inserting in federated db from trigger
- User-defined aggregate function
- Text index error!
- Negative value in the tablespace's percentage used field
- db2admin start error
- db2advis from Client
- Stored Proc' Offending Line Number in error message?
- What's wrong with this simple SQL UDF?
- connecting to SQL server table
- SQL-PL Reference Materials
- time stamp of DML
- How test for all digits
- how to reinstall db2 after hard drive crash
- Using "*" in subquery
- Query on tables from different DBs
- SELECT INTO - ADO.NET
- sqm.gen_dlconn_events Probe:10
- Does DB2 UDB support IPv6
- DSN creation to DB2
- Regarding Exam 701
- fp10
- Converting Windows databases to Linux
- ESE 8.1 install on Linux
- String vs Numeric Type
- blobs question
- problems with sqlcode -1225 in AIX 5.2 + UDB DPF (parallel) environment
- Index space requirements
- drop instance?
- Row or object SEKVENCE in EXTLOG001 type *FILE in use
- DB2 Blob
- Creating Tables and Populating via Script
- SPs in VB6
- how to know how many tables i created in the database
- Errors in DB2DIAG.LOG
- Automating exports of some files
- Data Warehouse Center Question
- DB2 setup problem
- DB2 setup problem
- EII (Composite) evaluation
- Invalid state transition while dropping a tablespace
- jdbc: FETCH FIRST ? ROWS ONLY
- Tablespace in Offline State...
- Insert into temp tables not working
- The cursor specified in a FETCH or CLOSE statement is not open SQL Excep
- SQLException
- DB/DBM configuration in DB2 on Z/OS, OS/390 or AS/400
- Want to write a standard user defined function in the db2
- Problems with INSTEAD OF Triggers
- SQL6030N reason code "13"
- Striping the time of the timestamp
- Creating a temp table.
- Creating a temp table.
- Get Version Level in cpp
- Doubt with MAX function
- DB2 DBA professionals needed for CMM Level 5
- Index question
- how to specify the number of records to fetch
- Declaring a variable in SQL DB2
- two-phase-commit with nicknames on 8.2.2 linux SQL/PL procedure?
- Concatenation
- about configure automatic maintenance window
- Table Inactive Error
- SQL0181N on nickname for union-all-view
- uninstall db2 NSE
- Writing User defined function in the db2 database.
- Help with a trigger
- TOAD tool for DB2
- Domain Authentication Problem
- ERD ---> Relational Mapping
- MQT Query Rewrite Puzzling
- fixpak enhancements
- Static SQL SELECT FROM SYSTABLES with CREATOR and NAME = *doesn't*use index?
- Static SQL SELECT FROM SYSTABLES with CREATOR and NAME = *doesn't*use index?
- Regarding Delete Restrict
- Difference between unique constraint and unique index?
- Move Tablespace Datafile
- Combining stored procedure and a select statement - possible?
- Declarative XML Processing with XQuery (the future of SQL/XML?)
- CLI connection failed. SQL0902C. A system error (reason code="6029321") occurred.
- change tablespace state
- DB2 Linux and High IO Usage
- SOS for long varchar
- send email with db2
- memory leak, urgent help needed
- DB2 ODBC connection timeout???
- DB2 8.1 to SP10
- Statistics - Table Name, Number of Rows, Number of Columns
- db2 and NIS
- Exciting Oracle News :: Oracle DB Worm Code Published :: Oracle PasswordsCrack in Mere Minutes
- What is a JOBLOG
- Linux Runtime Client 7.1
- version 7 backup close connections
- ImapgePlus mouse support
- Migrating from DB2 7.2 to 8.2 Questions
- SQLJ won't run static....
- Restore From Offline Backup
- db2start
- AYUDA error DB2JAVIT :RC=11
- database reorg
- Retrieve last inserted id
- Diag File Log Entry??
- HADR incompatibility between the two databases
- web service leaves thread active
- Need Help, DB2 Crash with Error DIA8301C
- Need Help: Using UDB-Type2-Driver on z/OS DB2 version 7
- db2dasrrm process / monitoring db2 processes
- Recover Wndows SAM
- DB21061E
- "User mapping missing" when accessing FEDERATED nickname
- Automatical enable and disable a task center task
- Error: SQL0971
- Windows Client for db2
- DB2 installation problem in the db2 database.
- Interested in feedback on DB2 UDB autonomic computing features
- SQL0101N and SQL0723N - Recursive Triggers Should Not be Happening
- db2 health monitor alert action to run script
- How to determine size of a table without running statstics
- WSE 8.1.5 LUW Trap file not written as claimed?
- Attempting to connect with client to remote DB2 instance
- Select the latest record for each ID from a table of historic records
- Problems creating database using scripts provided by LMS
- db2 UDB Fixpack 10 on Redhat Enterprise Linux V3
- To generate Unique id for every SELECT statement
- Searching for newline character with posstr
- DBD::DB2 $sh->prepare () after FixPack 7 upgrade
- why commit while finish a select statment
- Install db2 database in the Linux
- I don't understand results
- Foreign constraints DB2 UDB v8.1.7 Linux
- Inserting two spaces into a char(8), DB2 omits a space
- Latest Pictures and News from IDUG 2005 Europe Conference
- FreeHandle error
- Restoring to Different RAID Stripe / Extent Size
- Scripts for HADR failover
- User Data Maintenance users
- Strip titles from varchar string
- How to optimize this query in DB2
- Edit routine & access path
- ALTER TABLE <TABLE> DROP UNIQUE <INDNAME> doesn't recognize index name!
- Trigger structure
- Complex expression in select list, where, and order by
- LOAD vs. IMPORT
- Problem of two applications connect to one DB2 server
- Cannot turn on logging for tables with names > 18 chars
- What is the max length of a trigger name?
- Triggers DB2 UDB v8.1.?
- Pictures Live from IDUG 2005 Europe Conference
- Encryption question - please help
- Downloading UDB 8.2 Linux x86-64 PDE
- How to concat several lines into one
- How to decipher a SQLCODE
- LOGARCHMETH1 TSM logarchopt1 db2uext2
- Loading a delimited file to a table - new bie question
- IBM encryption tool question
- db2 restart required after changing varchar(2000) to varchar(4000)
- JDBC,CLI0109E,VARCHAR(2000) to VARCHAR(4000)
- Problem When Creating Views
- Tomcat and DB2
- Order By values of a column
- Serge......Help me
- Problem with PreparedStatement and DB2-Function...
- "Merge Into ..." Trouble
- Support for Generated columns on iSeries
- Long Error Messages in Command Center
- General Questions- Need Clearance
- Disk Space Calculation for tables
- First of each group
- remvoing statement event moitors
- Searching ODBC-Driver
- sending health monitor messages to another application
- Redirected Restore From one server to another Issue, db2advis error.
- Indexing Question
- Sanity check: primary key(a, b) implies index
- Query regarding Snapshot API
- Help - Migration to DB2
- access varchar error
- ReadOnly DB? - Improved Performance for Data Mart
- DSNTIAUL - Unload a Table that has a Null Ind
- Massive sql via WAN
- Visit the IDUG Europe Conference Blog for Daily Updates and Conference Information
- Multi-level Stored Procs and Savepoints
- how can I use db2adutl to view TSM info of another physical server
- Problem in DB2 AVI Extender
- Problem in DB2 AVI Extender
- Net Search Extender for Linux / DEV. ED.
- (Visual) Explain for z/OS
- Query regarding Performance
- db2app.dll could not found Error
- Where Am I ?
- Where Am I ?
- SQL0101N The statement is too long or too complex
- A pre-Wilma freebie for the DB2 crowd
- When are CHECK constraints evakuated?
- Slow connect to local server if VPN active
- MERGE and GET DIAGNOSTICS ROW_COUNT
- How to move a database into "global" area?
- inconsistent rowcount
- Comment in an insert statment?
- probelm with temp table
- problem with an insert
- Need Help : Power Builder and DB2
- Unable to list tablespaces from Control Center
- Capture memory leak
- Is dual-mode authentication possible under DB2?
- Error SQL0104N on very simple client setup. Help.
- HADR disconnected status
- DB2WMI and DB2 PE
- Regd: Platinum Fast Unload
- XML DAD Library List
- VBS return value from stored procedure
- script to automate table grants like a current user?
- Sybase to UDB migration --- help required on joins
- Location of Task Center tasks
- what query to ask the codepages a DB2 will read?
- Fenced user/instance question
- Replication - Not replicating deletes
- Intel Dual Core Processor and DB2 Licensing
- Java interpreter not starting after update to FP10 (testet with JDK 1.4.1. / 1.4.2)
- Net Search Extender
- Syntactic sugar for INSERT
- Have any function in the DB2 database that can generate unique id for each String?
- How to UPDATE with joins
- DB2
- cataloging and rerouting questions
- How can I move a table from a schema to another one?
- how to get parameter value from dynamic select statement ?
- Last Chance to Register Online for IDUG 2005 - Europe - Register Today
- How can I cast a BLOB-value to a VARCHAR-value?
- Relational Database Usage survey
- How can I output my own messages? Can anybody describe the Errorhandling please?
- privilege issues
- SYSADM privilege
- Is a statement like this possible: SELECT * FROM (CALL myProcedure)
- null -> not null or vice versa?
- Getting rid of "schema" from DB2 statements in COBOL programs...
- DBRM Generation
- DB2 for AIX Version 2.1.2
- case expression with SQL functions
- db2 v8 install hangs on windows XP pro
- Agents stolen from another application HIGH
- DB2 BIND from one database to another
- db2 toolsdb
- Is there a way to estimate view table size in DB2?
- Scaler Function: "Strip"
- db2connect and
- Incrementing sequences in the same select statement
- Q replication not replicating after an online reorg.
- transitive closure of a graph
- Trying to create a heartbeat for db2
- UnInstalling DB@ admin tools....
- How to db2level
- DB2 SQL Developer Tool
- Is there a way to get DB2 z/OS 7.1.1 to cache/reuse statements with jdbc ?
- Stumped With Clob data
- Rebind of Stored Procedures in response to a Table Drop/Create
- Where does DB2 UDB v 8 for UNIX write its application log files?
- Can't load library "/usr/lib/libcore.a", because load ENOENT on shared library(s)
- Can i write a user defined function in db2 Universal8.2 by the java or other language?
- Find my aliases
- Logon
- SQL/PL - Difference between OS/390 and UDB?
- DB2 Memory Allocation Error
- Time is Running Out to Register for IDUG 2005 - Europe Conference
- how to stop db2jd?
- How can i write java store procedure in DB2 universal database8.2
- Migrating PostgreSQL to DB2
- how to caculate the total size of an index?
- how to move package
- Load command
- checking existing before drop a table
- Schema Diff Tool
- Update/Load Slooooow
- LOB Access Error
- General LOB Performance Question
- Federated databases on different instances on the same machine
- DB2 Installation Error
- DB2 Installation Error
- All linked DB2 tables viewable on 390, but only some are viewable after migration to AIX and v8
- I/O error "243" when backup to tape
- LOAD doesn't seem to work using JDBC
- UDF in GENERATED ALWAYS column
- TYPES, HEIRARCHIES etc
- Integrity pending
- SQL0901N - Any comments?
- Table Comparison Tools?
- Trigger Db2 V8.xx
- recreate a same database
- sequence
- Probably dumb question
- UDB v8.1 fp 6 Summary table with an index
- Simple question on case statements and aggregating data
- db2diag.log -> "MESSAGE : Invalid private sort memory request"
- What is Max Length for Index Column
- Use fedb to access remote orcale database through a db2 fedb
- DB2 7.x and Linux 2.6 kernel + RHEL 4
- DB2 8.2 UDF_MEM_SZ / ASL_HEAP_SZ
- about cursor load
- DB2MSCS problem
- v8 cursor positioned update causes SQL4903N error
- Stored Procedure SQL0443N
- How to increase page size 4k to 16k
- Viewing last execution Date of Performance utilities (e.g. Runstats, Reorg)
- Reorg Table daily?
- IDUG 2005 Europe Conference: Call for moderators
- Drop column from table
- Cannot find db2idrop
- GENERATED ALWAYS AS IDENTITY clause
- Creation of Indexes in UDB for LUW
- SQL30081N A communication error has been detected
- IBM Single System View Monitor for DB2
- DDL for Creating the Auxilliary table associated with a CLOB column
- Slow connects to database
- Need DB2 Tuning/Optimization Specialist in D/FW for 6-8 weeks
- Need DB2 Tuning/Optimization Specialist in D/FW for 6-8 weeks
- 8.1 and 8.2 "compiling"
- load in an atomic statement -anyone resolved this??
- rows read vs. rows selected.
- iwh2serv.exe error
- Exporting just schema/metadata (w/o data) in DB2
- Db2 version 8.1 & FP5 installation Steps
- DB2 DAS causes transaction log to fill up
- trigger fire at not null columns
- as400 driver
- as400 driver
- filesystem layout for installing db2
- .Net and DB2 triggers
- Log Shipping from Primary Server to Backup and vise versa.
- Do I observe the DB2GENERAL calling convention in my Java UDF?
- Register by this Friday, 30 September and save 226 Euro on full conference registration!
- DB2 Federated connection problems
- querying the number of connected components
- Cannot allocate additional FCM - v8.2 DPF
- IMS DBA job in Irvine, CA with motoring company
- DB2 concurrent connection
- max number of colums - DB2 version 8.1
- About logfiles in db2
- Java Store Procedures Help
- Notification email address gets truncated
- Question on event monitors
- DB2 Locking: Subquery to a Long Federated Query
- HADR and Type 4 Driver
- Instance on Multihomed Host
- db2 Script and Outputlinesize
- PK--> FK relationship between tables of different databases
- Small & Large Lobs
- get request dynamicaly
- Hardware & stuff
- YYYYMM "between" selection on date column?
- Order BY with FETCH 1 Rows Only DB2 v7.1 not allowed
- Development Center, 8.1 or 8.2, UDB
- how to monitor restore process during rollforward ?
- How to start Control Center in different language?
- Problem with Time Stamp as a Composite PK
- Problem in Insertion
- DB2 Architect
- Custom Trigger Event
- help request
- How to lode/import all files in same time
- Exporting Client Configuration Assistant definitions from one computer to another
- DB2MQLsn - Where?
- java.sql.SQLException: No suitable driver when connecting to a DB2 database using driver COM.ibm.db2.jdbc.DB2XADataSource
- start instance node problem
- PREPARE stmt FROM stmtText and table names
- database name
- Formatter for SYSTABLES PACKED_DESC ?
- DB2 Error
- WANT limit the database accessible to some machine
- using dynamic sql to write a procedure for table creation
- Unable to update DB2 V7.2 FP5 to FP14 on AIX 4.3.3
- COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] SQL30081N communication error on DB2/POrtal on AIX
- Host Variable, SELECT INTO
- Net Search Extender
- Multiple connections to the same database in Cobol
- TCP/IP Comm Error
- Getting just the first couple records
- Primary-Contingency Setup
- need sql queries for following
- DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704
- Bug?
- upgrade to bd2 udb 8.2 slowed down queries.
- SET CURRENT LOCK TIMEOUT
- db2 udb 8.2 ignores indexes
- Default date format for a DB2 instance
- Scheduling Database - Design Help!
- Mysterious Trigger error DB2 UDB v8.1.5
- Source code resource
- DB2 UDB 8.2 for Linux and the ODBC-driver ?
- Wrapper development question
- error message DB2 UDB 8.1.5 LINUX
- Upgrade
- month between 2 dates
- Best practice
- describe table ignores alias ?
- DB2SET issues
- Getting next val in a sequence when the table is empty
- check_backup script required
- SQL to Generate Record Combinations from input string
- db2icrt on Debian Sarge fails
- DAS/email notifications
- JAVA UDF Accessing Another static class
- Omnifind and DB2
- Tuning for rollbacks?
- Db2jdbcBind
- sqledosd(), sqledgne() - list db directory
- IBM.Data.DB2.dll on .Net 2.0 framework
- REOPT ALWAYS for v 8.2 SQL procedures: does it work?
- Can not run DB2LOAD in parallel
- Problem in DB2 provider for .NET Fixpack 10
- function sequence error on aix5.2
- Put database in single user mode
- URGENT-NEED HELP ON FILE MANIPULATION
- URGENT-NEED HELP ON FILE MANIPULATION
- Ports for DB2 behind firewall / ssh port forward
- Escaping in db2 load
- Problem batching stored procedure calls using JDBC
- Exclamation point in password irritates DB2 CC?
- SQL6031N after /etc/services was changed.
- HELP : ANY LOAD EXPERT OUT THERE
- SLOB in Table
- Converting a correlated subquery to a non-correlated one
- Nested Stored Procedure returning result sets in DB2 on AS/400
- Question on space for a reorg
- IDUG 2005 Europe Conference (Early Registration Deadline Approaching)
- DB2 7.1-7.2 where can I download trial ?
- db2diaglog errors
- visual explain
- How do I code this complex select statement
- Problem with prepared statements of DB2 using OLEDB
- JDBC - getColumnName for stored procedure not returning the column name
- Package codepage different from database codepage
- how to force a disconnect pending application which seems hang?
- Unique Vs. Non-Unique Indexes
- SQL0501N error in simple procedure
- DB2 error on AIX
- test
- 2 Phase Commit for JDBC Universal Driver Type 4 connectivity
- How to get Db2 admin Level DB2 v8.1.5.449
- Some questions on Declared Global Temp. Tables
- Bind abends with 0C4 when DEGREE(ANY) option is used
- Health Center Email Notifications Stopped
- DB2 UDB and Cobol on ZOS
- Modify db cfg
- Stoping a runnaway task in the Task Center
- Downloading 64-bit UDB PE
- DBConnect
- Scheduler stops for no reason
- Strange behaviour when using LIKE with %
- Federated problems 1100N
- time measurement with snapshots
- SQL on DB2 - restrict number of rows returned
- Urgent - OS scripts fails in Task Center with fixpack 10
- DB2 UDB 8.2 for Linux and the ODBC-driver
- Change format US-1252 to UTF-8
- Can I put DB2 into maintenance mode for --
- Warning Message: High-water mark has moved for pool
- Wrong edition installed - reinstall needed?
- DB2 authentication using padl
- poor query performance
- SQL 1224 error
- SNAPSHOT_FILEW stored procedure
- DB2 Connect db2cli.ini file changes
- What is this process - db2dascln
- Fetch rows faster with JDBC v2.
- DataPropagator for z/OS New Version?
- database offline
- configuration parameters
- not in subselect
- lock wait for Capture service in replication
- which udb 8.2.2 processes really need to run as root?
- Replication differential
- Replication question
- Does Visual Explain work on a GLOBAL TEMPORARY TABLE?
- After reboot primary and standby starts up and then they turn into catch up pending
- How upgrade WSE to ESE without uninstall/install?(+)
- help me out
- Db2 procedure error
- strange problem
- db2cc hangs on win2k with "C0000005 Access Violation&qu
- Is this query possible ?
- error of dynamic SQL
- Tivoli System Automation for HADR
- DB2 UDB LUW: query, cursor types and optimization
- SNAP_GET_DYN_SQL
- function usage in dynamic SQL
- TCPIP port number
- Configuration Assistant problem
- News group problem?
- To change password for DB2 user
- question about dynamic SQL
- SNAPSHOT_BP function problem
- Photo Ipods
- Error while exporting clob
- DB2 MIGRATION: SYBASE Functions list
- DB2 Net Search Extender help!
- Strangeness with CASE stmts and ATOMIC keyword
- DB2 Net search extender problem!
- Alter table ADD COLUMN using UDF problem
- Connect Using db2cc and db2ce
- FP10 fun
- How to convert a string to integer?
- Attach Databasefiles
- HOME TEXTILE BOUTIQUE SERIES TOWEL BATHROBE AND GARMENT
- ORDER BY and case DB2 8.1.5 LINUX