View Full Version : db2 answers
- priviledges in db2
- How to pass a shell variable to a .sql file
- Why is the database size is larger than the server disk space?
- How to Create table using like but with modifications?
- How to concatenate 3 fields in a where statement see attach
- Compare 2 identical tables script
- on IMPORT SQL0437W Performance of this complex query may be sub-optimal
- Server Crash - Application
- Querry using Catalog information..
- Tablespace design for range partitioning tables in DB2 LUW
- Comparision of 2 identical tables
- What type of query will return the correct results?
- How to declare timestamp variable with default as current timestamp not working.
- how can import data acces to db2 in development center
- How to view a CLOB Output parameter returned from a procedure in DB2 control Center?
- Slow running sql stored procedure
- Hy everybody, i'm getting a error:
- DB2 z/o query performance?
- Sql0104n ... Sqlstate=42601
- Union All causing headache
- using dynamic SQL in a function
- How to downgrade db2 9.5 to 8.2
- I am interested in an answer to a RACF Group issue with an Authid
- how to identify the all the dbpartitions up and running?
- DB2 tablespace storage
- how to get all table names from db2 database schema
- how to restore Cognos 8 Sample DB2 tables
- I need to expand a field in a db2 table, must I write a conversion program???
- Use RID in DB2 z/OS V8.1 to find a row
- Is there any recomendation on how much the underlying FS be free for DMS containers?
- System: DB2 luw (unix) v9.5 fp4 - Q-Replication & inplace REORG
- problem solved: error occurred while initializing the Profile Registry
- z/OS DB2 Runstats Utility v8
- i have error SQL Exception in DB2
- DB2... stored procedures?
- what is difference between dbms and rdbms?
- A query on SELECT statement in DB2
- executes cobol program calling another cobol db2 program
- How to excecute a .sql file from db2cmd
- Round off the sacle of decimals in db2
- Can we move the spaces in the integer column.
- How do I find the table dependency information for stored procedures in db2
- Closing a .Net OleDB Reader is taking 250ms on DB2
- Loading CSV file into DB2
- db2 activate database results in 1226 - Overflow agent is not allowed
- How to replace '0'
- How to drop/find depencies of a user defined function in DB2?
- Using recursive CTE in stored proc?
- Having multiple databases in my environment...need to start stop every week
- To start and stop multiple databases in db2
- how can i select one row out of duplicates in a table.
- DB2 Triggers
- Problem in installation
- Connecting servlet program with db2 gives an error
- how to update/delete a row with DB2 within the same table
- What about "match simple" instruction?
- How to get column information from db logs
- DB2 Query Patroller failed
- does CTE use or create temp tablespace?
- How do you join rar files?
- Hello all, I am getting a syntax error (see below) while creating a stored
- To import bulk data in databse in db2
- When retrieving the data from DB2 through Excel do we need to catalog the databases
- How to see the collected statistics on declared global temporary table ?
- Can we truncate a table data using UDF?
- Check-pending status in DB2
- Having requirement to fetch record number 500 to 1000 from a table
- does alter table add column affect performance
- unable to create server for remote data source
- How to solve a DB2 Mainframe database connectivity issue?
- HADR- NEtwork failure server reboot
- DB2 data from AIX to Windows
- Calling a DB2 stored procedure from a trigger
- DB2 upgrade 9.1 to 9.7
- SQL1024N. A database connection does not exists. sqlstate08003
- dsn1copy
- What is the best practice for storing data in multiple time zones?
- How to select a huge table in a readable format?
- help required on IMPORT Command
- How to prevent the insertion of duplicate entries in DB2 tables.
- How to grant SYSADM privileges to user db2admin ?
- Connect drupal-DB2
- Error when trying to replace one sub-query
- DB2 Bind Variables used in queries
- is select statement considered as a transaction ?
- How to change ? to -?
- db2 :insert xml clolumn failed, HELP!
- How to create db2 Database programmatically in vb.net
- DB2 9.5 fix 4 - slow call of procedures ( SYSPROC.ADMIN_CMD, ADMIN_GET_MSGS ... )
- Auto Update a table
- Create DB2 Database When Application Runs First Time Development in Vb.net
- db2 9.4 fix 4, delay between call of procedure inside of a procedure?
- Inserts and deletes occasinally out of order when read using db2ReadLog API.
- back up DB2 use TSM
- DB2 Database Creation. At Application Startup Time
- DB2 Database Creation. At Application Startup Time
- How to kill a CICS thread after a online program Abend
- database technique
- DB2 Text Search, Update Index fails
- [DB2] SQLWarning chain holds value that is not a SQLWarning
- Temporary tablespace managed by database
- Need to find when the customers next vehicle purchase occured in less than 1 yr
- DB2 Client on Solaris fails to connect to DB2 Server on Linux
- Creating function in Db2 (version 8) on mainframe
- Concatenation in case of case expression
- Troubles with 16 level nested stored procedure
- db2audit command z/os db2 8.2
- ALTOBJ (sql-stmt parameter size)
- SQLERRMC empty on bind error
- how to read exported files?
- Data Base Replication Product and problem acessing data bases
- How to create table in db2?
- Sql storedprocedure return no error code
- Error CPD3E34 DDM TCP/IP communications error occurred on recv() — MSG_PEEK
- Code level Mismatch
- DB2 UDB 9.5 FP2a is not using the best index
- creation of 32 bit instance on 64 bit System DB2udb v9.5
- Find DB2 job name from system tables in DB2 database
- Using a Stored Procedure to Update data on AS400 DB2 database from VB.NET application
- Returning max summarized amounts
- Import specific colums
- Attempting to simplify a complicated SQL statement with CASE expression
- DB2 HADR creation get failed
- Using returned results from a stored procedure
- Manual bufferpool flush
- Execute a DB2 command from JAVA.
- Querry Execution time
- Db2 stored procedure fetch multiple rows
- Last Mon to Sun
- Group / max
- Split function in DB2 Version 5 Release 4
- db2diag.log doesn't capture deadlock
- Multiple condition trigger
- Identifying through many columns
- Wildcards in DB2 SQL
- Java application against Oracle to DB2 migrated Databases
- How can I find time/timestamp of instance creation on DB2 LUW?
- DB2 via Clist
- Db2 error SQL0901N SQLSTATE=58004 : Reason "Sdir len bad: 1542!=1520+14"
- Query to Search Data
- Error SQL0206N
- Compare DB2 source db and target db after replication/HADR
- Running Sql script from DB2CMD
- Connecting to DB2 database on remote server (UNIX)
- DB2 UDB, base sys utilities, sqleStartStopSingleNode, probe:1130 in db2diag.log
- Migrating from AIX DB2 V.8.1 FP 13 to WINDOWS DB2 V8.1 FP 9
- What are the pre-requisites to install IBM db2connect Version 9.5 FP2
- db2move from DB2 AIX to Windows
- How to pass a variable as a parameter to DB2 database from shell script
- DB2 trigger error
- snapshot_statement stmt_text unicode problem
- DB2 9.7 High response time on 50 concurrent users
- 32 to 64 bit in HADR env
- Select only a portion of the resulting rows
- DB2 Populate Date Dimension proc
- substring command not taking $ symbol in string
- Create db2 table directly by importing flat file without prior db2 table existing
- Getting Error sql0338n
- How to get the stored procedure information?
- hw to get the stored procedure information?
- Db2cmd error
- MQT with MQT
- Performance Problem with Order by Clause in DB2
- BAckup online with include logs fails !!!
- How to write a stored procedure?
- locks, transactions and stored procedures
- Return union result in one row?
- SQL1336N and DB2 CONNECTIVITY PROBLEM. What am I doing wrong?
- Journals in DB2 Server Edition???
- Migrate DB2 database from Solaris to Red Hat Linux
- How to calculate size of partition in DB2
- MQT in DB2 V9.1
- Problem in fetching procedure text
- Problem with cursors
- what is bufferpool in db2?
- Urgent - DB2 Function
- i am getting error of SQL0811N in db2 stored procedure. please help its urgent!!!
- MERGE STATEMENT IN UDB vs z/OS
- db2 user account deleted accidentally
- Using LIKE to compare input to column
- how to load a Db2 table from a compressed file which is an discarded output of REORG
- error in Stored procedure while using cursor
- A long string as a Input parameter in procedure
- List of ALTER Commands which needs REORG to be issued
- Improving a SQL statement
- Data export from db2
- How to connect db2 to java
- Sort table names by foreign key dependencies in a schema/Database
- From Oracle to db2 Federation - db2 "crash"
- Problems querying tables in federated database
- How to insert X rows into a table from a Select clause?
- Difference in record counts
- DB2 cast issue in UPDATE with parameter marker
- -802 error for count(*) query for a DB2 table
- Viewing the SQL behind a View in 9.5
- Database exception while running a batch program on Db2 V8.
- Which function has TOTAL equivalent to Oracle's TO_CHAR?
- Connecting to DB2 v7.1 from .NET ?
- Updating only the year in a date
- Alter an index in DB2
- Compare multiple result sets
- How to connect from DB2 V7.1 to DB2 V9.5 ?
- How can i store the value returned by sql statement in a variable.
- Merging Two Triggers
- How to have multiple statements in one query using iDB2Command in .Net
- Migrating database from DB2 V8.1 to 8.2
- db2 index reorg status monitoring
- Db2 9.5 behaviour in Solaris 10
- Questions with Archival logging for HADR Setup
- Few Questions with HADR - 1
- how to detect unavailable tables?
- Fetch command in cursor is very slow....
- Struggling with db2 and ASP app -- Calling a stored procedure
- db2 v9.1 UDF in C, Windows platform
- The command contains illegal characters or keywords (It does?)
- Both my application and reorg is slow...
- No one can answer this question
- convert 'Apr 19 20:00:03 CDT 2009' string to date
- Problem with Update Query in db2 9.5
- Connecting to Mainframes DB using a .NET interface
- Web Form to Database
- Set Null Using Java
- DB2 V9.5 Tablespace -pages missing and Total pg's not equal to useable pg's
- db2move issue with as400 iSeries library
- Incorrect "union all" results
- 2 linked inserts in one statement
- DB2 table design and performance considerations
- Difference Between DB2 zOS and DB2 UDB
- DB2 integer to Varchar autoconversion in Update
- How to Transmission of Large data accros network?
- Help required on using FILTER USING in CREATE FUNCTION
- Loading tables from USS on Z/OS
- DB2 on delete cascade is not working
- Single Tablespace or Separate Tablespaces
- retrieve all table names from DB2
- Stored procedure, function, very dynamic SQL and casting
- problem with db2 installation
- Trigger Problem
- Migrate db2 express to iseries
- db2 cross platform restore
- DB2 Join result columns are unnamed due to different column names used in subqueries
- Calling a UDF
- Row Locking
- How can we convert SMS tablespace to DMS Tablespace (Automatic Storage)
- help: a speech interface for information retrieval using a .db2 file
- same fenced user for different instances with different versions of db2
- Larger DB2 spaces
- remove newline character from field in exported table
- Syscat.triggers valid column
- DB2 Cpu Usage
- DB2 TableSpace Usage Actual Size vx Allocated Size
- Asyncronously accesss data using JDBC from DB2 database
- sending alerts to users
- Get diagnostics
- How to recovery a dropped table?
- db2 upgrade to v8.2
- DB2 AIX Admin tools ??
- Is Replication center v8.1 compatible with DB2 v7 Z/OS ?
- restore database
- plz suggest reg. cursors
- plz help- query related to DB2
- Using a DB2 User Defined Function
- makefile
- Updating an indexed column with the same existing value
- SQL0104 on Update with Fetch
- Use of OLAP function
- How do I change Instance in DB2
- Catalog Local windows DB2 database on AIX machine
- MS-SQL queries to DB2 conversion
- Should system temporary tablespaces generally be on automaticstorage?
- u just click u get some dollars
- SQL0284N error
- how can i generate a unique table name at runtime from db2?
- How do I concatenate strings from a column into a single row in DB2
- SQL0206N "O.$COID" is not valid in the context where it is used.
- Online reorg & log full condition
- SQL Doubt
- Trigger: After Delete ... for each row behaviour
- Views and union...
- passing input paramter of type list
- diag.log.sav
- Can we create a sample database on the app dev client
- Explain of update-statement without commit
- What the problem with VARCHAR_FORMAT?!?!?!
- Confused about memory parameters
- DB2 triggers & Cascading deletes
- JOIN between 2 tables. No foreign key, just ranges
- Online backup locking out processes...........
- UDB Stored Procedure
- Prepared statement too long
- Sustain Business with Regular Audits
- DB2 and CIO DIO on AIX
- Lock Table and auto commit
- A blog to lift the fog on Dataphor
- any documents for 32 bit and 64 bit stored procedure conversion ?
- Re: SIGNAL ON DELETE AND CAPTURE
- DB2 DBA required in Vancouver, BC (Contract)
- Re: SIGNAL ON DELETE AND CAPTURE
- Java or .NET interpreter startup or communication failed, reason code "2"
- No access to the SNAPDYN_SQL view
- Stored procedure Slo
- How to "LOAD COPY NO" without backup ?
- DB2 PHP connection issue
- Query doing table scan when added simple predicates
- new dba blog
- Is this an Invalid option? | db2pd -apinfo
- parallel insertion into a table in DB2
- NOT ENFORCED RI - what optimization opportunities are missed?
- DB2 Career
- SQL0746N: Routine violated nested SQL statement rules when attemptingto perform operation "MODIFY" on table
- Stored Procedure has no access on a remote file
- Please review this Explain plan output - need help
- Uniqueness checking overhead
- setting optimization level in stored procedure
- SQL Error
- db2diag -g db=DBNAME,instance=instname
- FLUSH PACKAGE CACHE DYNAMIC
- Load performance on AIX w/ SAN
- Last access time for index
- SQL30081N error
- Multiple databases in one project
- dsn1copy uses dynamic allocation for multiple pieces
- Error using old table() in UDF
- Unable to restore DB2 Database on Linux
- "WITH RS USE AND KEEP UPDATE LOCKS" An unexpected token
- 64 bit encoding in CLOB
- Problems with a simple Trigger :-(
- sqlqgRouter_conn_lost_cleanup in db2diag.log
- How can i modify the following query in DB2
- Linux + DB2 + php
- Co-releated Update Statement Tuning
- Overriding database collation in queries for LIKE operators
- Find SQL in Stored Procedures
- Getting rid of kuddb2
- IBMLDAPauthserver/IBMLDAPgroups, DB2 v. 9.5 ppc-Linux
- Database creation failing on AIX.
- Migrate schedules from one instance to another in V9.5
- runaway sqls
- DBA question on locating partition to which a specific tablespace page exists
- SQL PROCEDURE on the iSeries
- DB2 - forcing a table to cache all data in the buffer pool.
- What is the syntax for finding the Month(number) in DB2?
- DB2_USE_ALTERNATE_PAGE_CLEANING and HADR
- db2 doesn't start on windows2003(update from win2000)
- After adding a tablespace container: DMS rebalancer is active
- More DB2 Vista NewBee questions
- Beginner help needed - error connecting DB2-9.1 with RAD7.0
- HADR - AIX
- NewBee Express-C Questions
- How to debug sqc program
- Backup with include logs option
- encoding schema in pcap file
- Assume a bookshop has database with the following
- Capacity of "Trial"
- call a SQL Server 2000 stored procedure from DB2
- Multibyte data passed from OMVS to DB2 stored procedure gets corrupted.
- Problem with calculate difference between rows
- capturing optimization level used for certain sql
- How to get database size in DB2?
- index usage?
- DB2 instances in SDLC
- Troubles with Start database manager
- Optimal Method for Getting Max Value
- Dynamic From Clause To Create View
- PCML and DEXA
- Max table or database size?
- db2 questions
- V9.5 HADR On AIX
- how to run a COBOL-IMS-DB2 program
- stored procedures dependencies
- Query for selecting NON DUPLICATE ELEMENTS in a table
- difference in performance in two environments for same sql
- Re: SQL0104N An unexpected token error
- difference in performance in two environments for same sql
- Replication Connect Error
- DB21034E with triggers
- dynamic sql - prepare statement
- db2fmd - instance crash
- Diff in DB2 versions
- Unique values in column
- Update using WITH statement
- SQL1042C An unexpected system error occurred. SQLSTATE=58004
- Unicode arguments in posstr(), locate() and LIKE
- Restore Questions (32 vs 64 bit)
- DB2 federation problem when reconnecting to a remote federated AS/400
- How is DB2 tables stored?
- regarding cics
- db2stop taking time
- Merge on LUW 9.5.1 - Not Atomic Continue on SQL Exception
- Restrictions for SSL on db2 express c luw?
- DB2 Database Administrator
- DATABASECAPACITY and SMS tablespaces
- stored procedure to drop tables
- Health Monitor Invalid history version in header
- What happens after new function mode
- java torque nullable columns
- Possible to manually mark routine packages as inoperative in DB2LUW?
- adding nullable columns through torque
- DataServices World features Universal Services, SOA, WOA and cloudcomputing (San Jose, November 20, 2008)
- SQL3255 on DB2 v9.1 Win32 with db2move
- java torque save method exception
- issue on
- 9.5 LUW, pointers on running 32 bit client against 64 bit server?
- Question on SQL-based Administrative Task Scheduler
- Yielding timeslice
- db2 stored procedure
- Get the last day of previous business quarter
- NO FILE SYSTEM CACHING - Automatic?
- Sigh, Undocumented error - SQL30082N, RC=22
- Health Monitor - Manual Backup required...why?
- confusion about cardinality in explain plan node on compressed table
- confusion about cardinality in explain plan node on compressed table
- Procedure performance vs Query
- Re: MDC vs. cluster index: which to use?
- backup with multiple targets
- Add a partition to a table that already has partitions
- Supress SQL0347 (CTE may contain infite loop)
- update from select
- SQL30082N Attempt to establish connection failed with security reason"24" ("USERNAME AND/OR PASSWORD INVALID").
- Set Encryption password and SQL20143N
- Yellowfin Enhances Business Intelligence Reporting forTelecommunications
- CTE is not supported by db2advis
- PHP5 and DB2 9.5
- Db2 bind issue
- query help
- Detected the death of an EDU. Process was 11.
- reset monitor switches while capturing snapshots with sql functionsor views
- DB2 and Websphere MQ transaction coordination
- db2 database pages
- Solaris 10 Database bufferpool problem
- sybase post
- How to determine the isolation level of incoming queries.
- Unique Opportunity To Join The Elite Group Of Project ManagementProfessionals
- Select with odbc_exec (php)
- calling stored procedure from Perl code
- Syntax error when creating user mapping in DB2 (Data Federation)
- actual/estimated cost/cardinality of query plan
- progress bar for runstat?
- DDF Security?
- All about memory
- HADR Status
- DB2 low CPU low IO (low insert,low update) why ?
- DB2advis error
- please help
- truncate tables in stored procs?
- How to Give Operating System Security in db2 if not configured duringinstall ?
- How to view the special registers in db2
- DB2 V8 String Parsing Question
- Migration from SYbase to UDB database
- Query execution
- lfd length & pd length
- Block Comment Confusion ...
- DB2 - check if product installed on Solaris/AIX/HPUX
- DSNL013I & DDF, DB2 9.1
- DB2 9.5 SQL Procedure Developer exam 735 prep, Part 2: DB2 SQL Procedures
- Connect to Windows DB2 server from unix
- DB2 problem, need help
- REORG INPLACE -964 ERROR
- INPLACE REORG problem
- Kernel parameters for db2 v8.2 on Solaris 10
- DB2 Client Upgrade Questions ....
- HAVING and WHERE clauses: Performance considerations in SQL
- how to find middle row of a table?
- SQL help
- Try ... Catch
- Newbie - Partition setup multiple tables
- received this error message DB21034E running an ALTER Stmt
- Last DB2 to run on Solaris 8
- LOAD with COPY
- query to retrieve middle row of a table
- Difference between byte[] and blob
- Advs & disadvs of Self Tuning Memory Management feature of DB2 v9.5
- To Execute DB2 commands on AIX with a user other than instance.
- Collecting DB2 performance results for my thesis paper
- Selecting from a Dynamic Table in SQL
- Just checking
- Dynamic sql statement called in a stored procedure SP
- Please explain query intervals output
- On-line file backups
- Variables in SQL???
- outer join table filtering
- Row_number() over() not working in SPUFI
- SqlException Unsupported ccsid, encoding, or locale: "Cp037"
- why is NULLID.SYSSH200 executing so many times
- Leading Zeros
- DB2LOOK Privileges
- multiple databases in one instance
- ******GOD OF GIFTS 4 U*********
- IF Exists Bad Parser
- Re: Include all columns in an unique index
- shell script to extract rows from table
- Re: DB2 Container behaviour on EMC DMX 3 San.
- using setAutoCommit(false) in DB2 and MSSQL
- db2 V9.5 SQL1084C
- Re: Include all columns in an unique index
- Why is my static SQL dramatically faster than dynamic?
- IXF Column Descriptor Record
- Re: Include all columns in an unique index
- Db2 v9.5 - Undefined Symbol while creating an instance
- Merge statement: Index on source table
- DASCRT Command failed.
- Multiplexed Connection
- Re: flush package cache dynamic executed from client.
- Self tuning bufferpool
- Self tuning bufferpool
- regarding RAM size and db parameter
- Empty Table
- Help with query on sparse timeseries data
- Net Search Extender Throws Confusing Error
- Prepare Statement in DB2
- Ondemand
- Dropping indexes on a partitioned table
- Rows in a DB2 table..
- Requirement - Database Architect - State of Oregon - 6 months
- Merge Into using 'With UR'
- IBatis DB2
- DB2 error in DB2 control center
- Changing the DB2 Interface Language under Windows
- Does V8 of DB2 zOS supports
- db2 tablespace restore
- db2 table space restore
- Interview Type Question
- Time related question (Subtime)
- Mass Updation of Records
- Rows in IXF file
- Need example for accessing Resultsets from COBOL DB2 Stored procedures from Java
- Deletion from a large table (with two child tables) takes more than an hour
- Yellowfin says Java the smart option for Business Intelligence
- Clob variables in stored procedures and SQL10003C
- Question Regarding Parameters for DB2 COBOL Stored Procedure
- Using load/import with global temporary tables
- how to force bind option for JDBC in db2?
- DB2 equivalent to this Sybase syntax
- DB2 Bulk Load via Java/JDBC
- Db2 Explain weird results
- Call for speakers for DataServices World in Silicon Valley closes September 26, 2008
- REORG REPLICATED TABLE
- retrieving information from 2 tables
- blob and clob
- MQT cannot be used for queries with parameter markers?
- Project Management 2.0 !
- Clob
- Primary Key error wrong number of qualifiers
- DB2 9.5 equivilent of alternate fixpack
- how to ensuring MQT freshness
- SQL0101N The statement is too long or too complex. SQLSTATE=54001
- DB2 UDB LUW full time positions in California
- V9 client accessing V7.2 server
- SQL27984W - Some information has not been saved (import create mode)
- Delete and concurrency problems