View Full Version : answers
- DB2 Control Center not responding
- Is there any attribute which indicate the last access date?
- How to determine the DB2 version
- Querying "Sequence" in Select statement
- Got a intresting problem
- Backup Information
- Conversion of Oracle 9i to DB2 V9
- Software Testing Tools
- Sybase to DB2 Data Movement
- expanding a default value
- DB2 V8 (mainframe) Install - 'Resource Not Available' Msg
- how to replicate the SQL Server 2005 Procedure to DB2?
- DB2 execute permissions issue
- Disabling the DB2DETAILDEADLOCK event monitor
- Problem in Automatically generated columns while copying schema
- "channel DB2"
- When is an offline backup not really offline?
- Incorrect results using FULL OUTER JOIN in DB2 v8
- DB2 Two "how to" questions - [conditional loading and variable use]
- DB2 Automated Backup configuration parameters (DB2 UDB v8)
- package name restrictions
- Selecting Field Description With DB2 and SQL
- Archiving Older Data
- SQL0206N "BLOB" error
- DB2 on AIX throw exception with SQL that has (
- DB2 V8.2 - Value compression question
- problem with POSSTR
- Error while declaring a global temporary table
- INSERT IGNORE in db2
- J2EE Professionals for Bahrain
- Reading Tables & Columns
- db2 restore database
- Multi Row Insert using an SP in DB2
- exam cost??
- using Dynamic SQL for Update
- Express-C
- DB2 Viper 2 compatibility features
- Dump of a schema in DB2 / Admin_Copy_Schema
- Database Size Problem
- Funny
- Help me on Query fine tune.Explain report details provided.
- Problem with AutoCommit & problem with XML insert
- Db2
- setting the termination character in CLP
- Nested case in DB2
- Nested case
- DB2 Z/OS Stored proc help
- Db2
- setting pause on output in CLP (Db2 9)
- Oracle EXPORT and DB2 LOAD
- How to change a column from a not null to null
- SAP DB2 userids
- Perl DBD::DB2 connect error
- COM.ibm.db2.jdbc.app.DB2Driver
- How to insert and retrive data from Visual Stidio 2005 (MFC) into DB2???
- IBM][CLI Driver] SQL1032N No start database manager command was
- How to export resultset to CSV
- How to export resultset to CSV
- How to export resultset to CSV
- How to export resultset to CSV
- How to export resultset to CSV
- if "all applications disconnection" is anathor tigger of page cleaner?
- killing application/thread automatically
- importing data with CR-LF
- Insert values into a table B based on a flag on table A
- Sql performance Tuning
- Database inconsistant?
- Sql-Translation: Oracle to DB2
- DB2-quries
- lock escalation
- Unicode...
- Tablespace STUCK in Roll Forward in Progress State...
- How to make a generated column function of other columns?
- db2 pring command for dynamic queries
- Calling a nested stored procedure in DB2
- Performance of JOIN vs. singleton SELECTs
- How many cursors?
- What are the process to add another DB2 database to existing Instance?
- connect as400 to mysql
- substr of a number's field
- Emptying index advisor cache
- DotNet compatibility of BLOB datatype
- positioned update
- Tablespace remains full after deletions
- Big problem with DB2 and Clobs...
- How can i Connet from 1 DB2 Server/Client to Remote Server on AIX
- The Best DB2 Articles
- DB2 Automated Backup configuration parameters.
- Need help getting DB2 Connect to catalog a remote AS400 DB2 server
- Load Data from fixed length/delimited feed file
- How to get System Date in DB2 with SQL Statements
- I need help to fine tune below query..urgent please.
- MIGRATE DATABASE from 7.2 to 8.2
- How to find no.of deleted rows
- DB2 SQL error: SQLCODE: -551, SQLSTATE: 42501
- Examination 070-229 Resource
- ERROR SQL in DB2
- Restoring the event monitor file
- plz help:i want to create db2 account Not using OS account
- CREATE PARTITIONED TABLE - SQL0104N error
- 5th Fast Track Automation batch from Quality Globe from August 9th.
- SELECT of Members
- inserted values required with the given format
- Compare two databases in different subsystem
- Lock Escalation
- Troubles inserting to a new unicode table....
- clientside backup of partioned database
- quiesce database problem
- Prevent database user to access another database
- Use of REORG TABLE in a C++ Applikation for db2 Version 9
- CLOB columns change after database restore
- Need to display the header as the top row in the recordset
- Laptop Version ?
- Db2admin password
- check constraint
- DB2 load utility and subsytem
- DB2 Concepts
- DB2 Vers 8.1 installation error on WinXP
- DB2 connectivity
- TCP/IP Communication Error
- mainframe (7.1.1) lock escalation
- application id
- how to get even or odd number rows from database in db2
- [Question] DB2 LUW V8, regarding after drop tablespace behavior
- DB2 INSERT search for space
- runstats from reorgchk update stat
- Outer Joins in MQT`s
- migrating SQL Server data to DB2
- SQL stored procedure in Z/OS (DB2 ver 7)
- how to *really* remove a database in DB2 ..
- Insert v/s Load
- creatin a trigger
- To create a trigger
- xml
- connection remote to DB2 database with the C/C++, with prohibition of installation DB2 client software.
- execution time in HADR
- ClientBean and ReportBlox
- V8.2 Check if nonrecoverable load was done
- sql update to a substring
- V9 Column Rename
- HADR performance issue
- Sqlstate = 56038
- db2 replication Center
- Error activating a database/cannot allocate agent
- DB2 Common gcf error
- QMF vs SPUFI
- import from NUL converted to ordinary delete
- Problems with starting DB2 service on windows
- SQLJ default context override
- DB2 queries
- Migrate Data from Oracle 10g Express to DB2
- Order of Where and Composite Key
- Stored Procedures for DB2 z/OS Developed with SQL Language
- Very basic formatting question
- DB2 Container Size Limit
- at the start of db2
- First process in db2 startup
- Errorr execute immediate
- displaying a date
- Get error SQL0723N when trying to insert a row into mainframe DB2 from web server
- Mqt Store Procedure
- Newbee Query Problem
- IN versus ANY versus EXISTS
- DB2 Load utility
- describe command
- Specifying Record Delimiter
- SQL0338N-Error
- Delete rows from two tables
- db2 sql query
- SQLCODE: -805, SQLSTATE: 51002 , this is the error code
- Temporary table in DB2
- Summing a column as a seperate column in the same query
- db2_pconnect SQL10007N Reason code: "3"
- Nested selects
- Invoking Stored Procedures in Triggers
- Oportunidade Stefanini It Solutions
- BEFORE OPTION
- Max length Locate can handle
- MF COBOL/DB2 Error
- Clob In Db2 Aix
- DB2 "Net Search Extender" for v9.1
- Define a return value in store proc.
- Creating Function Template in UDB 8.2 with TABLE return type for Federation
- SQL Error in DB2 and MS Access
- DB2 migration utility ?
- Looking for a db2 tool that converts Oracle to Db2 - Migration assistant?
- DB2 Express-C on Windows XP SP2 "Invalid parameter number. SQLSTATE=S1093"
- 64bit client application in a 32bit instance
- Software Testing Cycle
- DB2 Certification Exam question
- Packages and Procedures
- DB2 online data copy
- Db2-cobol Program
- Isolation level - interesting scenario
- Update difficulty
- Interesting isolation level problem
- access level problem in multiple instance
- db2 offline db restore from v7.2 to v8.2
- Version Recovery (Db2 on AIX)
- Formatted CURRENT DATE
- SQL0104N An unexpected token "DATABASE" was found following "CREATE ".
- After merging - how to bring over parent_ids
- DB2 database shutdowns after excecution of sqlj procedure
- VARCHAR field that is not NULL
- DB2 ver 7.1 Processing was cancelled due to an interrupt
- Help on Null
- LIbrary System
- db2 704 exams
- Very urgent.. need threshold levels for db2 monitoring metrics
- SQL Code -181
- 4th Fast Track Automation batch from Quality Globe from July 24th.
- iNFO O db2 CERTICATION REQUIRED.
- How to reduce the ImageCopy job run time
- how to ignore errors when creating stored procedure?
- help in DB2 Load command
- db2 wsad connectivity
- Import SPF via Script
- SQL0332N There is no available conversion for the source code page
- library system
- SQL0206N, case statement and time calculation
- Failed to load libaio
- Asp - Db2
- db2 doubt
- Catalog Node : Port Number
- HELP! declare global temporary tables?!?
- HOW to convert a character type into date format
- need a little insight on index that allows reverse scans
- select from a sequence and from a table in the same statement
- update from a select
- Storage quantity
- Commit Active problem solved (db2rhist.asc)
- STOP RUN in DB2 stored procedure
- how do you add a zero to the left of an integer
- view tables
- Retrieving latest row
- Error in DB2 (COBOL/DB2/CICS )
- Space instead of Null
- plan and package
- IBM supplied WLM stored procedures
- Client compatibility
- Oportunidade Stefanini It Solutions
- How does threads work in DB
- load vs. import ( warnings )
- row_number
- LOAD and LOAD with AMDIN_CMD
- Replication tutorial
- DB2 subsystem
- SQLCODE groups
- Db2
- Is there any command or tool for doing DB2 Catalogs reorg/check?
- complile and execute a stored procedure.
- Run DB2CMD commands through PowerShell
- DB2 versus UDB
- Controling tablespace for a primary key index in alter table
- Db2 700
- Need help on data replication and available options
- Rename a tablespace file?
- Is there any way to make my transcripts of the DB2 certifications viewable for public ?
- How to speed up this SQL statement
- How to extract sequences in db2 udb 8.2
- log table changes with a trigger...
- IBM and AGS Announce Availability of New Solutions for Informix Dynamic Server
- Contokens
- check pending state
- message in db2diag.log
- DB2Dart Report meaning
- problem during database connection test in db2 stored proc
- db2dascln
- db2 iseries
- Application inventory DB
- list of Parameters that has to monitored by a DBA in db2 UDB
- list of parameters that has to monitored by a DBA in db2 UDB
- Renaming an instance
- Could this be DB2 or an Access problem??
- How to take the database backup
- How to define my own exception in db2 stored procedure
- DB2 Trigger Help
- update a column on particular table relation with multiple tables
- ROW_NUUMBER LOOP
- Software Quality Management
- Need Help with db2 db2start throwing SQL6048N error
- Query help...
- DB Backup error
- DB2 Driver- ClassNotFoundException-Please help
- Oportunidade Stefanini It Solutions
- Ibm Db2 Sql
- Error in loading data into DB2 table
- common problems found in db2
- Universe locks
- command for viewing DB2 configuration parameters
- IBM Establishes Global Center of Excellence for Nuclear Power
- Corrupt Trigger Nameless
- Stored Procedure
- Error uninstalling DB2 V9.1 (XP Home)
- DB2 700 Exam
- SQLDA corrupted when using VARGRAPHIC type parameters
- DB2 Certification
- db2ReadLog, Variable format data
- How to do DB2 Clustering
- db2jstrt or db2jd on OS/390
- db2look -tw
- What are the Files generated after db2 installation
- Cobol precompiler query
- Installing and Operating DB2 Within Windows Domain
- Tables and Columns security in database db2
- Long running of DB2 Queries
- Creating Indexes For Declared Temporary Tables
- How to execute a procedure in DB2
- CMMI Practices
- DB2 trigger failing while calling stored procedure
- How to change the primary key for already existing table?
- Statistics with volatile table
- Cannot Load
- Third Fast Track Automation batch from Quality Globe from July 5th.
- "Best Fit" Match against multiple tables?
- PHP5, ibm_db2 connection problem
- COBOL DB2 V8 Mainframe - moving data from one table to another
- Primary Key
- DB2 Model
- Primary Key
- specified attributes not existing with existing column error on Altering table
- Getting error whle changing the Datatype of a column in the table.
- When to use cursors?
- Migration from V8(solaris) to V9(redhat)
- normalizing two related tables
- How to specify the creator in db2connect
- Left outer join with case
- Query's Strange Behavior
- Dates, DB/2 and Java
- [IBM][CLI Driver][DB2/6000] SQL0952N - HELP
- DB2V8.2 DPF CPU Usage
- AS400JDBCDriver, encoding charset
- Issues when deploying applications on WebSpeher process server.
- [IBM][CLI Driver] SQL1284N The attempt to connect to database
- Query from more than 2 database
- Query from more than 2 database
- Please..need SHA1 implemented in DB2 version 8
- Need help on deleting log file (log_dir)
- UDF's crash after new CPU installation on AIX!
- set integrity
- The database manager is not able to accept new requests, has terminated all requests
- how to declare temp tables in a user-defined function
- Non-SOAP Web Service in DB2 9
- Event monitor that gives more lock info?
- Error Message Retreival in SQL Stored Procedures
- Applying CURRENT TIMESTAMP On Updates
- Db2
- What is the difference between BIND REPLACE and REBIND commands?
- Basic doubt in union.
- JDBC: Connected but no tables shown
- DB2 SQL Query
- timestamp
- Db2javit:rc=9505
- Delete table command in DB2 SQL ?
- db2 9 processes on linux.
- how to add a logical partition on the same computer.
- Replication : when asn.IBMSNAP_UOW is pruned ?
- BACKUP PENDING(Help me,Please)
- Inoperative packages vs. invalid packages
- Self Join in DB2 SQL
- Troubles using DB2, Websphere 3.5 and Java
- Effect of manually updating AVGCOMPRESSEDROWSIZE?
- is this table function possible for IBM DB2 v8.2?
- Mapping between Package and DBRM.
- JDBC type 4 driver for DB2 v7.1
- case and count
- SIMPLE but SLOW SELECT query!!!
- where do i declare the user temporary tablespace?
- temporary global tables
- Replication error
- functions that returns a table
- I cannot find License key
- Data Dictionary counterpart in DB2
- lock escalation : how "expensive"?
- INSERT Trouble
- How to create user Temporary table in DB2
- Migrate from v7 to v9, 32 to 64 bit
- How to Update Blob with JDBC?
- Generated Always As Identity
- COMPRLIB in backup
- Comparison of two rows in a table using SQL ?
- Setting a default schema for a particular group
- Removing a record from resultset using SQL
- Define tablespaces with different size paging into DB2
- Handling Null from a stored procedure
- truncate table for DB2 - differences
- Hosting Robots On Terminal Server
- Can Not Create Database - DAS Is Not Active
- what is a fully qualified table name in DB2 ?
- Script for db2 backup
- DB2 Trigger syntax
- DB2 Trigger syntax
- HTTP Web Service Consumer
- db2 inplace reorg and log space
- Online Reorg of LOB data
- Federated Systems Question
- Accessing data from an intermediate results table
- Protocol specific error code(s): "10060", "*", "*". SQLSTATE=08001
- DB 2 content manager replication
- SQL1131N DARI (Stored Procedure) process has been terminated abnormally.
- db2 object comparison tool
- DB2 version 7 having paging space issue
- WIN XP Pro SP2 Db2 V8 install/setup message invalid password
- I Don't Need The Data I Need Only The Syspunch
- DB2 logging options
- DB2 HADR Logging options
- qurey for ibm db2
- Problem while calling java stored procedure which connects to db2.
- Unable to connect to DB2 v7.2 using JDBC Universal driver 4
- beginner XML extract question
- Oracle to DB2 DRDA connectivity
- DB2 Viper 2 beta - compatibility features Feedback needed
- [DB2 V9] Problem with Unicode in XML fields
- DB2 Viper 2 Open Beta - Enjoy
- Can anybody give me the exact syntax to rename a column in DB2??
- How to convert: Oracle to DB/2
- Event monitor db2detaildeadlock
- DB2Express conenct existing database
- DB2 Express 9.1.2 failed to install on Fedora 6.
- How can I bulk-load a typed table?
- How can I bulk-load a typed table?
- Error in reader
- Oportunidade DB2
- Create Function
- instance owner can't stop the instance
- Connection to DB2 using ODBC
- Int to Date in DB2 SQL on AS400
- Not all archive (offline active) logs are getting backed up
- How to install Fix Pack without stopping instance and das?
- Transaction Processing over XML (TPox): New Release (1.1).
- SQLSTATE 25501 invoking SPs from a J2EE DataSource connection
- Hibernate -- JDK 1.5 -- DB2 SQL CODE -4700
- Global Temporary Table and 'AS' clause
- db2 control center
- A recovery scenario
- db2 audit user activity
- delete with join - is it possible ??
- fullymaterializeLobData property for db2 jdbc driver
- Number of bufferpools.
- DB2 Database Management Services
- "Auto number" within a combination key
- DB2 protocol connection infomation
- Where Statement?
- Governor Question Iddle
- Differing query results based on access path
- problem facing in enabling the automatic db2 backup maintenance
- DB2 Books
- Load the PS data into DB2 tables
- Load the PS data into DB2 tables
- Error :- SQL1052N The database path "c:\mhi" does not exist.
- DB2 on Solaris X86
- Can Anyone Give Dumps For Db2-703 Exam
- DB2 User Defined Function
- Declared Global Temporary Table on z/os v7
- HADR questions
- query
- reading xml using stored procedure
- How to get the Optimization level?
- bulk loading into a table with "not null" column constraints
- Page Size
- embedded sql application fails on Suse (powerPC)
- IBM DB2 Content Manager eClient v 8.3 installation fails
- SET statement in a stored procedure
- Package "NULLID.SYSLN30F 0X5359534C564C3031" was not found.
- How to use NULLS first
- hi all
- snapshot monitor performance issue.
- MAINFRAME/ DB2 DATA MODELER/ CONTRACT/ MO
- Select query with column positions insted of column names
- getProcedures() interface method doesn't return the functions
- CAST sql statement
- Problems Updating via Oracle DB link to AS400/DB2
- Stored procedure failing on nightly cycle
- Software Testing
- long running query
- Arithmetic overflow
- Create a stored procedure that will load a csv file
- Unicode and UTF-16
- combining results by unique id
- Automatic Timestamp
- TesterQA is a Leading Software Testing site
- Reporting On DB2 Performance
- SQLCODE: -904, SQLSTATE: 57011, SQLERRMC: 00C90090;00000801;NULLID.SYSSTAT.5359534C56
- Counting in SQL with breaks
- Automated Testing
- ADMIN_LIST_HIST table function
- Maximum size of table is 512G??
- HADR and REORGS
- Sorting weirdness?
- Space being used by a table with long data and lob fields
- Software Testing tool Rational Robot Tutorial
- How to get unicode value from aN UTF-8 character
- db2pd: "Changing data structure forced command termination"
- SQL to get table names from view
- Merge statement in db2
- external db2 UDF in C compiled on AIX
- Question about table space rebalance
- using level number 49 in dynamic sql for declaring group variables
- Aunthentication Question
- advise for INTRA_PARALLELISM
- trigger with delete statement gives error "DIA8309C Log file was full."
- fixpak 15?
- Setting locktimeout value
- Migrate 4K Tablespace to 8K Tablespace in DB2 v8
- connect from host(z/os) to a mssql server
- Blocked SYSIBM.SYSTABLES
- throwing error when creating procedure
- Reg : File transfer using SCP script
- How to simply insert or update to a BLOB column using data from file
- SQL Query to list table(s) in LOAD PENDING
- load stored proc from ant.
- STMM with multiple instances/databases
- Call Procedure
- Set Declared Variables...
- db2gov - idle....
- Strange Reorg response time
- DB2 V9 Installation Problem
- Advanced SQL Query - Grouping Results from One Column into Multiple Columns
- Custom Software Development
- increase sequence value more than one
- Express-C V9.1, JCC Driver and SQLException.getMessage()
- DB2 Access with Unix Shell Scripts
- How to set langauge environment of machine(Windows) to french in DB2?
- Migrating from 7.2 to 8.1
- db cfg: CATALOGCACHE_SZ obscurites.
- SQL - Sum of rows containing non-numeric values
- Question on DB2 Fetch
- ADD DBPARTITIONNUM fails on Linux
- Getting SQLCODE -302 after migrating DB2 V7 to V8 IN ibm z/os
- Data type convert issue
- Overflow error????
- ANNOUNCE: Altova 2007 Release 3 available
- problem with db2 commit on aix (lock and cuncurrency)
- Invoking excel APIs through DB2 with any native interfaces
- rollback load by cursor
- Dynamic SQL
- syntax differences from oracle to db2
- Version of DB2 9 Information Center that doesn't require admin authority to install is now available.
- Redirected Restore and container removal
- DB2 Page Cleaners
- problem with memory heap
- DB2 views - Read Only
- SQL - Select ALL rows
- Vsam
- Convert TIMESTAMP to DATE
- DB2 Connect
- Count() and count(*) in DB2
- load in db2
- Anybody using DB2 9 on Linux x86, please, examine...
- Interpreting dynamic SQL snapshot