View Full Version : db2 answers
Pages : 1 2 3 4 5 6 7 8 9 10 11
[
12]
13 14 15 16 17 18 19 20 21 22
- Creating Scalar UDF
- Connect to IBM DB2 database without installing the DB2 client.
- Multiple DB2 Client Versions
- Multiple Application Group possible ?
- DB2 - OleDb - Unable to use Catalog Library List
- list applications only show one connection (catalog/uncatalog database)
- Can you tell if a REORG is in 'paused' state?
- getting comm errors in db2diag.log instead of sql errors
- Can you tell if a REORG is in 'paused' state?
- DB2LOAD API
- which data type to select
- DB2-Mystery with Multithreading and new compiler
- adding constraints to a view?
- Version 9 and .NET
- restore tablespace backup onto another system
- Storing some Japanese data.
- Traversing Relationship Tree
- db2 jdbc
- Cascading delete
- cursor as OUT parameter of a stored procedure
- cursor as OUT parameter of a stored procedure
- Path where database is created
- Error while connecting to a database
- SQL explain plan
- DB2 Development Center & COBOL for Z/OS
- String matching in LIKE predicate...
- Difference between DB2 Client and DB2 Connect
- DB2 Backup strange Problem
- Calculating percentage in sql db2 with decmial precision
- crash when trying to get snapshot size
- JDBC error
- DB2 Instance Crash
- Finding the 'Client login ID' aka 'Execution ID': DB2 AIX
- trigger happy
- db2 database online copy help?
- DB2 Trigger To Track Table Changes
- INSERT but ignore duplicates
- Sample table structure to store pics in DB2
- Thema: DB2 + XML-Funktionen
- SQL7962 Error When Selecting From AS400 DB2 Database
- Formatting a Timestamp
- How to upload a sql file as a member of a data set in db2
- How to upload a sql file as a member of a data set in db2
- user authentication
- Java / JDBC DB2 export
- DB2cca problems.
- software services
- EMC and DB2 on Z/OS
- Raw I/O on Linux
- DB2 Client run time for linux
- DB2 via REXX on Z/OS
- DB2 via REXX on Z/OS
- how to do DB2 RTCL upgrade on Linux
- SQL Tools for AS400/DB2?? What are you using?
- SET CURRENT LOCK TIMEOUT has no effect
- Regarding install_jar functioning
- Convert rows to column
- Convert rows to column
- GSS security plugin issues
- db2 connect required for accessing db2 on z/os?
- BEGIN ATOMIC, COMMAND CENTRE SCRIPT
- db2 connect required for accessing db2 on z/os?
- Naming conventions for datamart columns
- MQT
- SQLCODE -204 using a jdbc-driver to UDB DB2 v8.2
- Regarding install_jar ... Urgent
- SYSPROC.DB2LOAD
- SQL2038N A database system error "-5130" occurred during processing.
- Load Utility
- db2advis with stored procedures
- Error while running cron job with DB2 in RedhatLinux
- Moving tables to new schema
- DB2 Content Manager: Is it J2EE Compliant?
- DB2 DAILY CHECK LISTS SCRIPT
- Query Tools
- Utilizing db2mtrk..
- Trranslating ORACLE functions to DB2
- Help! inserting records and functions
- db2 connection error while running script
- CSV file with Headers
- How to do a sql update based on a join?
- Priming the Package Cache ?
- Slow stored procedure after upgrade to 8.2
- SQL error
- How to join those 2 char columns?
- Performance of load from a cursor .... federated cursor?
- DB2CODEPAGE Variable
- Moving cursor in Command Editor results screen results in update of table
- Data Conversion in DB2
- Parsing arrays parameters in DB2
- Multiple Instances and their corresponding entries in the services file
- calculation percentages using sql command
- DateFirst in SQL Server
- very interesting - why two equal calls is different?
- changed machine name - unable to work in DB2
- Mother Celko's Monday SQL Puzzle #3
- createin privilege
- Bad magic number for shared library: libdb2.so
- Bad magic number for shared library: libdb2.so
- db2pd -activestatements
- UnsatisfiedLinkError in Java UDF
- Datatype for creating a range value in db2
- -2 option in SQL table function for snapshot does not get global snapshot
- About Encrypted Data In DB2 UDB
- staring and stoping a database in DB2
- Can the notification log (.nfy) be deleted?
- Inserting Data using a Stored Procedure
- SQL1247
- SUM(double_value) is not deterministic?
- Query Tuning Help
- Index creation status
- DB2 Instance Crashing
- running utility task on all tables
- DB2 v8.1 (UNIX) on tape
- Performance problem in db2
- Third pary tool for db2 backup and recovery
- Using a cursor for Update
- Tempspace UDB V8 FP 10
- Tempspace UDB V8 FP 10
- How do we execute this command through java?
- Geographical clustering for DB2
- Searching for strings and replacing them
- multiple result sets
- Create DB2 USERS and Connect
- DB2 Instance Status
- Execution plans and temporary tables
- monitor lockwait
- Accessing the data from DB2 servers using C# Application
- DotNetNuke help Needed!
- FOR READ ONLY cursor a named statement
- DB2 performance variables
- import utility
- how to analyze db2expln results
- Obtaining parameter MAX_CONNECTIONS through the API
- DB2 Access Slow With MISys Application
- multiple outer join
- Server Security Plugin Error
- Cloudscape - usage of?
- DB2 Daily Check Lists
- Comments in SELECT via PHP/ODBC DB2 UDB v8.1.9 Linux, PHP 4.4.0
- Stored procedure slower than an ad-hoc query ?!
- Utilization Statistics during data load
- Tool to determine Hardware needs for a DB2 server
- Creating and using a Cursor
- Passing parms to a C Stored Proc
- Deadlocks even with SELECT FOR UPDATE
- An error on search table.
- TIps on Delete Cascade performance
- Table definition for Storing a PDF page
- Call for speakers: IBM Information On Demand 2006
- Error on adding DISTINCT to a SELECT DB2 UDB v8.1.9 Linux
- Sort memory
- Sort memory
- Errors in stored procedure in db2
- Problems with performing db2updv8 on database in db2
- automated-access-plan comparisons on LUW (db2 v8.2.2)
- SET integrity fails despite of for exception...
- DB2CMD in XP - DOS batch file
- Overflows in tablesnapshot
- SQL0954C -- Not enough storage is available in the application heap to process the statement.
- Creating a simple UDF
- set variables to be used in creation of result set.
- DB2 forum???
- Slow execution of Delete Statements
- Controlbreak flag in result?
- DB2 UDB Stored Procedure help
- creating pivot tables
- Index Naming Standards
- optimize DB2 query
- database backup -linux to windows
- Retrieving most current entry?
- EEE - Nodes utilization question
- Two tempspaces on database
- PLZ help me out
- Perl and DB2
- DB2 Queries
- Installation mess
- Create a table with a structured UDT (user-defined type) as a column
- Tasks not found in version 8.2
- can i use load terminate with cursor for select * from table name?
- Passed DB2 UDB 701 test, how can I prepare for 704 test (Advanced DBA)?
- Problem with DBD::DB2 and UTF8.
- FYI: FP11 and error -925
- Running multiple SQL scripts in the background ... no longer possible?
- column "generated always as" generated from multiple columns
- How to locate the static SQL fired by an application in DB2
- The HighValues plague returns....
- problem with procedure call
- View DB2 Table definitions in QMF
- backup question
- partioned table or partioned index
- DB2 Experts To Contribute To 85K Newsletter
- identity-alteration RESTART option
- DB2 version 8 DBA (Houston, TX.)
- DB2 Connect returning data in HEX?
- SQL Cross join
- Language Issues
- redistribute nodegroup
- Rename a database?
- Install IBM DB2 on Fedora Core 5 (Bordeaux)
- Sudden excessive access time to DB2 via ODBC?
- Accessing DB2 on an AIX server via ODBC from MS Excel
- SQL stmt to find if table is in load pending state?
- IGNORE NULLS possible fro CREATE INDEX? DB2 UDB v8.1.9 Linux
- Syntax question DB2 UDB v8.1.9 Linux
- Storing Japanese characters in UTF-8 database
- Naming ...
- Naming ...
- GENERAL SQL Question
- Help performace question DB2 UDB v 8.1.9 Linux
- Truncate Table
- column functions
- How to recover db2 instance user's privilege?
- remove spaces from field contents in DB2 database...
- DB2 Backup
- Privileges on SP??
- I need help
- HADR and failed tablespace creation
- Multiple SQL SPs accessed from one SP
- how to create a DB2 system dsn in linux fedora core 4
- Writing file from procedure
- Replication using asnload
- can someone help me figure out what caused the rollback?
- DB2e_Shadow
- DB2 Version 8 - libeay32.dll problem
- SQL0298N Bad container path Error
- Log Full
- Duplicate rows from a SELECT DISTINCT DB2 UDB v8.1.9 Linux
- Open LDAP Plug-In Anyone?
- Multiple Temp Tablespaces
- z/OS to AIX connection - authentication/authorization
- Viper and VisualBasic
- Calling SYSPROC.DB2LOAD within SQL stored procedure
- Moving db2 to a dedicated partion
- Should db2 summarize or home grow a build app in C
- problem with long object name
- FETCH FIRST ROW ONLY
- plz help me out
- delete from table where in, problem
- top-down-top query approach
- MERGE in V8.2 FP4 (on condition returns multiple rows from target)
- Differences between UDB V7.2 and V8.2 for federated connections?
- Uninstalling v7.1 on Solaris
- re-configuring db2 server for client operation? [comparison to oracle]
- Compiling stored UDFs
- Parameter Markers in SQL queries and ADO.NET
- Lock escalation in SYSCOLDIST
- help me out
- How do I do this in DB2
- DB2 Viper Testdrive
- SQL0902C - SQLSTATE=58005 - Reason Code = "14"
- Seek newbee Java UDF installation tip
- Blocking Agent ID for Locks in SNAPSHOT_*
- Multiple temp tablespaces with same page size
- Multiple temp tablespaces with same page size
- ADO.NET - strange behavior
- About automatic database maintenance
- db2pfchr processes and high CPU
- Catalog Database
- Problem with Global Temporary Table
- About Multiple Cursor from Stored Procedure
- db2cmd.....
- SQL issue? Can this be done?
- Reading an explain Plan
- Functionally equivalent exception Join
- Command Editor problem?
- Extended optimization messages
- Is "One view per table in DW" really a good practice?
- locks and related
- Confused on how to get a percentage of total using OLAP functions
- slow download-insconsistent latency
- DB2NTMEMSIZE
- db2diag.log error
- Need ROLLUP expert advice!
- Is there a way to find the record causing SET INTEGRITY command to fail?
- Problem inserting spanish characters in DB2 UDB
- Problem with Backup/Restore with Vendore Products
- How to Drop data from table quickly
- db2_evaluncommitted
- Parameter.Add need help - not understanding
- DB2_FMP_COMM_HEAPSZ - need help!
- Sequences in db2 8.1.0.36.
- Grouping SQL statements
- SQL6024E Table or index "tab_name" is not defined on node "0".
- SQL Server co-existance
- how to rollforward without userexit - SQL1268N
- db2 File system caching ..DIO or CIO??
- db2 File system caching ..DIO or CIO??
- db2 File system caching ..
- Control Center Error
- Alter Column
- Illegal Immigration, the Non-Issue of the Week??????????????
- How to obtain the schema from a JDBC Connection ?
- 2-nd edition of Celko Puzzle book in the works
- Truss output - semget analysis
- Inserting data into a DBCLOB column
- Passing a parameter to IN predicate of DB2 udf
- LOWER() and UPPER() functions not found.
- limiting number of rows returned by resultset
- Control Center doesn't find backup files
- Issues with loading 124 million records
- Set level acestor report; DB2 UDB 8.1.9 Linux
- Restore not finished
- Query performance
- jdbc and list of all databases
- Is db2uext2 archiving directly to tape?
- DB2 Application Development Client
- creating a database using DB2
- Mixed Case in table and column names.
- T-SQL to DB2 UDB SQL-PL conversion...
- SQL construct conversion...
- Can't get table out of check pending state after load.
- Group Authentication
- DB2 V8 z/OS
- What's wrong: SQLCODE -30082 password missing (on windows)
- SQLCODE -1024
- Computing the product of a column groupped by...
- Triggers crashing database ?
- Migrate DB2
- SQL1224N - A database agent could not be started to service a request
- jpg file to mainframe
- Mixing SQL and traditional I-O in an ILE COBOL program
- Query Performance
- DB2 Control Center crashes
- insert data into graphic column
- Shell Script eroor while using db2 export
- Locking issue
- regd data migration from DB2 v7.2 to SQL server 2000
- i can not create db2 sample
- Transaction Log full.
- # of Agents -> db2 list applications
- Tablespace on NFS (Netapp filers)
- deadlock related
- [IBM][JDBC Driver] CLI0622E Error accessing JDBC administration service extensions.
- Authorization/Privilege Issue
- SQL/PL Stored Procedures and SYSIBM.SYSDUMMY1
- Case Sensitivity in DB2 on linux
- alter query
- DB2 Query problem
- DB2 UDB Detective - Ace Ventura
- NULLID.SYSSN300
- Logging
- odbc connect string and library list
- SQL help
- Is LOAD really this brain damaged?
- Sequence number for a Batch
- Help me to Create Database
- DB2 Redirected Restore
- About Encryption Function in Db2
- iSeries: JDBC problem v5r3
- multi-file multi-table import
- table identifier for db2ReadLog
- Simple Query
- to fetch first record
- DB2 exception handling in triggers
- DB2 error handling in triggers
- How to get generated key back in php/db2 v8.1.9 Linux
- How to do more things in DB2
- Is this the right way to go about ranking things?
- Backup a suspended database with SMS tablespaces possible
- nonrecoverable load during backup
- User Defined Function in DB2 Urgent Help please
- Exporting current system timestamp to unix server
- Timestamp equivalent in DB2
- SQL0818N after V7 -> V8 migration.
- IXF LOADing w/ different column orders
- Sql help
- DB2 SQL error: SQLCODE: -805, NULLID.SYSLH20A 0X5359534C564C3031
- DB2 CF and Visual Studio 2005
- How to load a cursor from a stored procedure in DB2
- Strange error:An unexpected token ")" was found...Expected tokens may include: ")"
- 2 version of admin client on same PC?
- about high security field
- DB2 Incremental BackUP / Restore problem from one machine to another
- Checksum for Duplicacy check
- Catalog-view to get tablespace-state?
- Places to schedule database backup in DB2 UDB V7
- Cursor Load fails with SQL0964C error
- Merge Alternative
- Upgrade my db2 8.1 fixpak 6 to last release
- V8.2 Express Edition XP Home
- task center error 22207
- size of db2 udb database
- Ink
- Just for laughs..
- Migrating DB2 UDB 8.2 dbs from windows platform to Linux
- Building Simple SQL Stored Procedure
- Ink
- HELP! reading syscat from php in db2 udb v8.1.9 Linux
- Recover IBM DB2 Data (Urgent)
- Senior Mainframe Cobol CICS DB2 Programmer Needed in Alabama
- Stored Proc Performance Improvement
- Stored Procedures / UDF
- DB2 program to read log files ... incorrect function identifier
- Data Replication DB2 VM to UDB with DPROP
- Data Replication DB2 VM to UDB with DPROP
- DB2 Backup into 3590 tape drives
- Difference between Collection ID and qualifier
- problem with Group By
- Comparing dollar amounts stored in a varchar
- Adding user data to the system metadata tables Db2 UDB v8.1.9 Linux
- DB2 and embedded SQL
- Expected Impact of Changing Logging Type
- get a list of all users in db2
- Query performance - Please help
- extracting db2 table records to csv
- How can i connect to tables created in a schema with a username different from the schema name?
- Drop Table
- Optimizer not using MQT ?
- load data into varchar column
- Relocate DB2 databases part 2
- How to convert DB2 data type P to SQL
- What is the connected database?
- How do i ensure 'insensitive' (ie static) cursors that are only forward readable (in DB2 for mainframe)??
- 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
- load from cursor
- UNIX shell script and DB2 Queries
- 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
- 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
- Max Connections
- 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?
- 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 problem
- give me idea for this procedure
- 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)
- DB2 Altering an integer to character type
- 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