View Full Version : answers
Pages : 1 2 3 4 5 6 7 8 9 10 11 12
[
13]
14 15 16 17 18 19 20 21
- 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
- agents -recommendation
- How to Update multiple tables in a single SQL update Statement?
- Alternate fixpacks and DB2 Connect
- Are LOB's replciated using HADR ?
- unload data on DB2 Z/OS to DB2 UDB on Windows
- SQL PL question: Get Diagnostics
- Attach Database
- bufferpool heap taking 4 GB when it is only specified as 750 MB total
- hmz... what's going on???
- FP10 - ooops!
- active users
- FP10 Now available
- where to find pricing?
- Error while compiling view
- SQL0351 when acccessing V7 from V8 client
- Extensions of DB2 engine
- Win2k Memory Allocation - BP v Sortheap
- PRUNE HISTORY question
- share tablespace
- Faster Runstats?
- UDB 8.2.2 specify statement-delimiter inside script?
- failover with HADR
- Run db2updv8 after installing fixpack 9a?
- Backup fails with SQL2059
- db2cc/db2ce on Linux
- Problem with a UDF
- CLI trace and DBD::DB2
- Bufferpools
- Delay a trigger
- How to replace Procedures/Functions?
- PROCEDURE with one-character name, not returning RESULT SET
- Convert Current Time to Dec
- Strange message in db2diag.log
- L2/3 Cache
- No select privilege on sysibm.sysdummy1
- SQL0374N on METHOD for structured-type (V8.1. fixpak 8)
- Hmz.. what's this then.
- db2start fails on Solaris 8.2 (SQL1042C)
- DB2 UDB ULW: Replacing an SQL procedure language based function used in object definitions?
- UDB V8 FP8 - Tablespace Filesystem caching enabled for DMS Raw?
- No start database manager command was issued. SQLSTATE=57019
- Questions re WITH RETURN TO CLIENT
- FYI: developerWorks/DB2: Tracing Procedures
- DB2 V8.2 install on Redhat 3.0 - AMD 64 bit
- Health Monitor Crash
- Change column name in replication environment
- Information Integrator with Oracle
- Applications hang in a "Commit Active" state
- How to avoid Tran Fail Log error with update statements
- db2 transactions per second
- db2plug and Control Centre
- Triggers-Replication-unique key
- Db2 Net Search Extender help!
- Zugriff auf DB2
- DB2 Program to connect to 2 databases
- What is JDK_PATH used for?
- db2dasdiag.log is filling up the filesystem
- Before insert Trigger
- db2 Redhat 3.0 AMD 64 bit - db2cc problems
- db2 v8.2 reorg
- javaw.exe
- Any Replication Gurus?
- Do I miss anything?
- Encrypting Data in DB2 Connect
- Current library on AS/400
- DB2 Connect - PE v8.1 - problem
- How to send Mails out of a DB2 database on SuSE
- Use Of NULL Keyword In DB2
- locks_held_top - Maximum Number of Locks Held monitor element
- i want to rename the table schema
- Java Type 4 Coonection in V8.x
- "Devices"
- fetch first in full select
- how to select source of procedures and functions
- Trigger and Call results in the 57053 problem but why?
- BIZZARE MQT-BASE Table Locking Behaviour
- Managing users under DB2
- increase write speed to UDB
- Will splitting up a table improve our select performance?
- Focused DB2 Education at IDUG 2005 - Europe
- Focused DB2 Education at IDUG 2005 - Europe
- sqluexpr - external routine problem
- Solaris client suddenly hangs
- A snapshot of the database market and DB2 by Philip Howard
- DB2 Hosting
- Licensing
- Multi RDBMS Support
- IDENTITY_VAL_LOCAL AND STORED PROCEDURES DB2 ver 7.2
- Advantages of "MERGE INTO"
- memory usage
- AS/400: generate unique numbers
- Dumb IBM Marketing?
- db2 8.2.2 error when creating database
- EXPORT DATA without quotes"
- Examples wanted
- passing parms to query in DB2 Unload
- DB2 Audit Trigger Generator [long]
- Upcoming DB2/XML webcast: Aug 16
- Making stored procedures resident in memory
- one performance question...
- one performance question...
- Long Varchar - when will it no longer be supported?
- migration toolkit (from oracle 9.x to udb 8.2.2)
- V8 FP 8 : Restore error messages.
- db2 8.2 fixpaks
- Db2 full text search help!
- reading DB2 with isolation CS - why is the lock blocking?
- Moving to AS/400
- Extentsize/Containers/Tablespace
- data access across instances
- DB2 SQLJ.Install_jar(file:///user/shared/java/javamail.jar', 'MAIL') Error 58004
- equivalent of oracle's dbms_output.put_line in db2
- Odd Security Need
- Euro Symbol and ASCII-Tablespace
- DB2 version 7 JDBC drivers
- How switch db into read-only mode?
- CAN WE MAKE USE OF CURSORS IN A SIMPLE BLOCK IN DB2?
- pass an recordset to a procedure
- New features for the next version of IDS
- Bug in DB2 8.2
- Finding DB2 instances and databases
- Year, Month, Day functions
- db2_all
- Named Pipes Problem
- Setting nulls in Development Center for SQL Functions
- DB2 V8 Client / DB2 for z/OS Upgrade Path
- Running the same script across multiple DB2 databases, instances and servers
- can't create database cause access failure in db2spcat
- MS-DTC and .Net client doesn't work with Transaction Required
- Unable to select from temporary tables
- DB2 SQL Formatting
- Problem with Rebuild Index after loading data with DSN1COPY
- Handling Special character in openquery
- Problems with national characters
- SQL PL online manual/guide?
- Last Chance for VDC Embedded Database Survey - Takes Less Than 5 minutes...
- Last Chance for VDC Embedded Database Survey - Takes Less Than 5 minutes...
- DB2 UDB Security
- access pseries DB2 from iseries using COBOL and RPG
- Apply Program Not Moving Data
- db2_awe and more than 4GB memory on Windows
- NAS for DB2 active logs
- MDC Rollout
- Shameless self-promotion
- Oracle DBA Inherited DB2 System
- Trigger Failure Cancels calling transaction
- Performance of union all views
- SQL Procedure Question
- Why does the execution plan hav a nested loop join when an UDF is used?
- Embedded Database Research
- Where are the downloadable versions of the V8 manuals?
- Sybase to UDB Migration - Code Freeze
- Update Fails with SQL0407N
- sql replication script
- problem while index creation
- DB2 replication - Apply program not replicating
- Error in nested SQL Procedure
- SQL Statement length exceeded
- compact and compress?
- SET CURRENT LOCK TIMEOUT
- materialze query?
- Putting Information Center on hard drive
- 64-bit platform support for XML Extender
- clob question.
- Can I store binaries outside /sqllib/function?
- Get the DB2 version number through SQL (onMVS)
- How I can get statistics by indexes using?
- Packagename of a routine
- Change Server Name on a DB2 Server
- drop table/recover space
- Can I replicate data between a pair of databases in the same instance?
- Stored Procedures (db2dari.exe) sucking up memory
- Does DB2 WSUE supports 64 bit computing ?
- DIA3819C A file sharing violation has occurred, filename was ""
- UDB V8 FP9a "log data" monitor elements
- Cannot connect to db2 using jdbc
- Statement sequence in SQL Stored Procedure
- retrieving clobs over wan
- UDB V8 (Fixpak8) - "Database files closed" monitor element
- Why are the "same" queries optimised differently ?
- DBA2052E
- Db2 help needed
- DB2 V8 - user account TROUBLE
- DB2 port
- using jdbc to connect to db2
- Difference between a 'file' and a 'table'
- load utility does not work from control center
- Char in US Code page vs Char in UTF-8
- problem with unloading data from DB2 ver7
- problem with unloading data from DB2 ver7
- DB2 and PHP
- No future for DB2
- Vargraphic not available in GUI
- Prevent Infinite Looping in Q Replication
- Help! Call sql procedure - SQL1109N The specified DLL "SYSIBM.SQLPROCEDURECOLS
- show comments for columns ...
- solution on source code page "1114" to the target code page "UNKNOWN".
- Merge stmt
- Design Advisor does not recommend indexes !!
- UDb V8.FP6 - Finding NEXTVAL for IDENTITY COLUMN (not SEQUENCE)
- Reorg of very large tables
- UDB V8.2 (FP1) - DGTT WITH REPLACE vs. delete * from DGTT
- Trying to get scrollable result set from SQL stored procedure
- HADR / Q replication comparison
- commands to copy archived logs in disk to tsm
- DB2/390 v8 - union all subquery in select list returns wrong results
- Inner Joins and UDFs
- how to archive logs to disk and then use tsm to back them up to tape
- Table function GET_DBM_CONFIG missing in Fixpak 9
- How to Stop a Database
- DB2 AS400 convert character to date format
- DB2 AS400 convert character to date format
- unable to install SQL Express 2005 CTP
- overflows : interpretation
- DB2 Event Monitor puts "?" for all the values
- Help to compile C UDFs using gcc on AIX (bldrtn)
- Copying my DB2 database connections
- Table size estimation
- Need FixPack 7a urgently. Plz. Help!
- DB2 v8 --- Creating the DB2CERT database...
- DB2 v8
- DB2 replication setup step by step
- Help with "SQL30081N A communication error has been detected"
- DB2 and cygwin ...
- resetting monitoring switches
- Cursors defined as "WITH HOLD" are closed after commit.
- MQT/Staging Table/Syntax
- Division by Zero or changed order of applying predicates in SQL
- q replication/sql replication
- Pick until enough
- very strange ... SQL0910
- Modification time
- SQLSTATE 42997
- DB2 Replication - synchtime
- How do I increase the size of the output message parameter of a debugger
- SQL0270 RC 73
- HADR Questions
- DB2 solaris installation without open windows?
- DB2 Warehouse Site Agent!!
- privileges on packages - db2 8.2.2
- Journal - Task History - Database backup success is expired
- [Restore DB] backup from linux & resotore to windows
- Can we create an alias for a sequence in db2
- error : DIA3207E L'appel TCP/IP "gethostbyname"
- Will the new RECOVER Command run in parallel on a partitioned database ?
- DB2 migration v5 to v8.1
- Change a table's tablespace
- DB2 V8.2 FOR LINUX - REXX STORED PROCEDURE
- db2advis - Disk Limit Constraint
- TPC-H Query Results - 1GB DB
- Problem running control center.
- UDB 8.2 poerformance problem
- DB2 Before Insert Trigger not acting like before?
- How to DELETE with COMMIT COUNT
- SQL Problem - Date / Txn Sequences
- Bogus data type incompatible error SQLSTATE=22001?
- Select column user via clp without getting token user
- Can CLP output be timestamped?
- Problems with Java SPs on Win2003 server
- SQL0289 when Alter table space
- db2spmrsy
- Question about VARCHAR Vs. CHAR fields
- DB2 8.1 32-bit Linux migration to 8.2 64-bit on AIX
- Delete vs. Merge
- DB2 Connect V8, Schema functions, and CLI driver
- Materialized Query Syntax--I can't get the samples to work
- Question on Package Cache Overflows
- Problems with connection pool for DB2400