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
- Table queue overflows
- DB2 .Net Provider vrs OLE DB
- Rows read from statement event monitor
- db2 server monitor
- Parsing errors in db2diag log
- Failover of DB2 Tools Catalog on MSCS
- [db2clpex] How to pass the content of a clp-file as a parameter
- stale connections
- db2unit (DB2 Unit Testing Framework)
- hundred thousands BLOBs in database
- SQL scripts and Result set
- runstats sampling oddities
- Need DB2 DBA
- How to create a table, and make it undropable to the creator?
- Help with diaglog message
- How to find Execution time of Select, Insert and Update in stored procedures
- SQL Error "SQL3040N" when execute DB2import under DB2 version 7.2
- How to determine ALTER TABLE time?
- SQL statement for generating rows of intermediate dates
- Stored Procedures
- SQL0444N Reason Code 4 SQLSTATE=42724
- Determine Invalid Index
- String vs Numeric Type (2)
- How Db2 trigger call .Net web service ?
- regarding Date function
- Connecting to AS400 running on IBM with MS Access
- SELECT NULL VALUES AS ZERO
- Couple of HADR questions
- Couple of HADR questions
- update from V8.1 Fixpak 8 to Fixpak 9
- upgrade from FixPak 8 to FixPak 9
- Can not initialize a full refresh (SQL replication) on the apply side
- Identity column issue-SQL3526n
- Is DB2 multi-threaded?
- case insensitive select
- UDF Performance Question
- Failover problems
- Using Virtual IP addresses with HADR in addtion to automatic client reroute
- HADR split brain question
- Activation Key - DB2 UDB
- please how to synchronise mssql database from db2/400 ?
- CLI without ODBC
- How can a CLI client get the return value after calling a stored proc
- Development Center
- DB2 Upgrade crash Domino 6.0.2CF2
- Updating IMS data from DB2 v7 Stored procedure (Z/OS)
- Error inserting into iSeries DB2 table with long name via SQL Server 2000 linked Server
- DB2 UDB Version 8 Workgroup Edition 64 bits, sources ????
- does DB2 support SELECT - INTO statement with ORDER BY clause?
- OS Command scripts never terminate in Task Center
- How to view date using sql
- QSYS type *LIB not found
- Query sysibm for record counts
- Windows Server 2003 SP1 and DB2 UDB
- User Defined Functions in Mainframe Enviornment
- Partition groups in DB2 8.2 on Linux
- Upgrading and FP 11
- Getting English Day Name
- memory usage in db2
- DB2 Connection String Problem while DB2 connection OPEN
- Low SQL cost and high execution time
- with UR is not recognised in DB2
- Auto delete rows older than a month
- Update Duplicate rows
- Update Duplicate rows
- Regarding DAYOFWEEK function
- query tuning
- SQL select Crashes DB2 8.2?
- DB2 Connectivity problem from a wndows client to DB2 AS/390 server
- Equivalent of Sybase's @@transtate in DB2
- Table scan <--> Index scan, Version dependent ?
- Size of DB2 Incremental Backup
- Date Format problem
- Time is Running out to Submit your Presentation for IDUG 2006 - Europe
- Can I write an application with no server ?
- How to query the DB2 z/OS V7 dictionary for indexes?
- Removing Punctuations
- MERGE performance help DB2 UDB v8.1.9
- Right Align the character field Value
- a trouble of modifying procedure
- Retrieving Object ID's
- DB2 Authentication problem
- Stored procedure
- changing directory for data file
- containers in the same FS
- SQL statement parsing
- Store Procedures
- Impossible Relationship? Referential Integrity on tables with on From Date and To Date
- Dopping a schema DB2 UDB v8.1.9
- Load Flatfile in UDB (Server) from z/OS-Mainframe
- Load Flatfile in UDB (Server) from z/OS-Mainframe
- interface
- Pre-set default schema for new user
- Difference in response between Net Drive and App Drive
- A handy trick DB2 UDB v8.1.9
- Fedora Core 4
- How to get the current DB2 Version on v8 and higher.
- get_dbsize_info
- Timestamp problem after upgrade DB2 ODBC Client from 7.x to 8.x
- db2 8.2 client and vb6 ado refresh problem
- How can I drop a Column from a table?
- Clarification needed for HADR documentation
- Question about database migration from UDB 7.1 to 8.2 (FP3) on HP-UX
- Online Backup versus Offline Backup ?? What's the point ??
- Query optimizing problem
- current date minus date
- Performance impact of materialized views
- Questions on a 'shadow catalog' and ODBC
- Can't Install
- How to compare two columns in DB2 -Please HELP!
- Redirected restore - SQL2038N A database system error "127" occurred during processing
- Multi-Row Inserts on DB2 for zOS
- DB2 on zOS and Win XP Client
- client instance and server instance
- Displaying a CHAR FOR BIT DATA in C#
- Question about DB2 UDB 8.2 and 32-bit and 64-bit instances
- Grouping data by week?
- Load global temporary table
- DBD::DB2 not finding .so file on system startup
- Admin API reference for 8.2
- Important Information Regarding IDUG 2006 - Europe
- NFS problem
- convert application id which starts with "/"
- JDBC: Encoding Not Supported when connecting to Big5 database
- DB2 Client Upgrade Question
- DB2 Development Add-Ins for Visual Studio 2003
- DB2 vs Kernel Preemption
- Client-Server Conenctivity
- Reg:Migrate VSAM files to SQL server 2000
- very very slow query with parameters
- IBM DB2 Content Manager Vs IBM Content Manager OnDemand
- DB2 Performance issue
- Which predicates are stage 1 and indexable?
- throughput between application-db2
- Problem with package not found
- comparision between DB2 Connect and Shadow Direct
- type-2 index causing performance hit
- JDBC: problems using FETCH FIRST and FOR UPDATE clause at the same time.
- Equivalence for Sybase Functions in DB2
- Attaching a CLI-Connection to the static SQL connection
- Does DB2 Connect lisence needed for windows client?
- SetConnectAttr ODBC
- Query problem: sales volume comparision with previous year
- Automatic Backup/Reorg/Runstats Evaluation - How do you force a new evaluation cycle?
- Help
- Querying the Task Manager database
- Table Space size and Bufferpool page size
- Droping an index
- GRANT DROP on TABLE
- Stored Procedure Options: Modifies SQL Data and Results Set
- TCP/IP Error, rc1=22
- Crash when execute quiesce
- Migrate Sybase outer join query to UDB DB2 8.2
- Help-Sybase to DB2 migration
- DB2 books?
- need to restore old database (database server 4.01 AIX)
- There is no available conversion for the source code page "1252" to the target code page "0". Reason Code "1". SQLSTATE=57017
- Restrict Access by Application
- DB2 subselect problem
- Can XML data type be passed as parameter for procedure?
- Deleting data from table
- Log mining
- FCM_NUM_BUFFERS
- Calculate Shared Memory Usage
- Instance Creation Query - "db2iexec"
- insert into DB2 from SQL Server
- Transaction isolation level for stored procedures.
- Content Manager 8.3
- query to determine the Instance Name?
- DB2 JDBC addBatch truncates DECIMAL fields during inserts, if the last row has null values
- Connecting DB2/400 through iSeries Access drivers or DB2 Connect, which's more efficent?
- SQL0723N sequence + union all
- ESE -> WSE?
- Console disapears:Error in <EXE NAME="javaw.exe".. in DB2 8.1.8, Win Server 2003
- Dropping tables
- An internal error occurred. Report the following error code : "0xFFFF8544".
- An internal error occurred. Report the following error code : "0xFFFF8544".
- Fixpack 11 for DB2 V8?
- Db2 Stored Procedures and File handling
- DB2 UDB v7 for z/OS TEMPLATE not creating GDG base for absolute generations
- [Urgent] validating Date field and saving into DB?
- commit and terminate
- DB2 join challenge
- Unique sequence object for each row returned from select statement
- Do anyone still have V8 FixPak 4 (U488486, not 4a) for AIX5?
- Error with Automatic Maintenance
- DB2 8.1.8, Win 2003: Steuerzentrale schmiert ab
- DB2 8.1.8, Win 2003: Steuerzentrale schmiert ab
- Any function in DB2 to help
- Equivalent to CREATE DEFAULT in Sybase
- Manually Add a Row to a Resultset
- VB8, Fixpak 10
- Migration of DB2 V6.1 to Windows 2000
- EXTEND USING option of CREATE INDEX command
- db2 connect problem
- How to elide leading zeros
- CHAR vs CAST DB2 UDB v8.1.9 Linux
- Help with 64bit Solaris 10 ...
- Stored Procedure - Aliases problem
- Requirement of Java/Oracle& All Skills with Valid H-1 B Visas --USA Opening
- SAP/DB2 Space optimised snapshot backup
- CSV file with Headers
- DB2 UDB 8.2 installation on HP-UX 11i fails
- Online or offline backup?
- how to determine the NUM_IOCLEANERS?
- Protocol specific error code(s): "10065", "*", "*". SQLSTATE=08001
- DBM Event Monitors
- Column Concatenation Function?
- Trouble with .NET Data Provider on DB2 8.1 Fixpack 6
- Error logging with Merge statemet
- multiple files for Backup
- Nested Case Statements
- Media controller -- Disk full encountered
- IBM JDBC help
- What is viper?
- SQL2048
- validation testing -- use TPC-C? (or what?)
- Some nonexistent tables in ASN.IBMSNAP_REGISTER
- Deploying the .Net Application with DB2 DataBase
- ORDERING by a FUNCTION() with simple-integer
- Show Related->Tables Spaces causes "CLI0611E Invalid column name."
- Installing DB2 on Solaris 10
- SQL22223N La instancia "DB2" no existe en el sistema principal
- DB2 Express
- split function in DB2
- Configuration parameters
- Performance issue: Need to force Optimizer use a specific Index
- Opening for IBM/DB2 Content Manager with 2yrs of Exp In Chennai
- Help- Migrating timestamp from Sybase to DB2
- Regarding MTK
- Can DB2 run on a SUN Ultrasparc T1
- RETURNS TABLE in DB2
- missing functions
- Views and Deadlocks
- Certification question
- Triggers using Uncommitted Read
- db2fm
- ResultSet cursor is forward_only from remote SQL/PL procedure ?
- Combine column multiple rows into one row
- DB2 Net Search Extender truncation
- HPU 2.2 Fixpack 3 on AIX
- db2start gives an error after DB2 installation
- Difference in between TIMEs
- SQL procedure permissions
- same query giving different out
- Suse Linux 64-bit ppc describe table issue
- Unable to Debug Java SP in Stored Procedure Builder
- Migrating from Teradata to DB2 EEE.
- One stop shop revoke tool
- Data of table not sorted by primary index in Control Center
- Safe cast from string to integer
- code page error
- maximum tablespace size
- Need Data Migration Points(Sybase to DB2)
- SOS - how to uninstall DB2 Express 8.1. on Windows Server 2000
- DB2 backup question
- Errors in diag log
- Compiled stored procedures in DB2
- JDBC Driver Failure
- reduce % of used DMS tablespace
- ccsid for db2
- Calculating Days/Months
- cluster
- No Privileges for User groups
- Restore 8.2
- Nullable Vs Not Nullable Column for Partitioning a Union ALL View
- the first connection to the database takes a long time....
- Calling a COBOL Subroutine from COBOL/DB2 Stored Procedure
- Retrieving timestamp with the Universal Driver
- identity column & import - need help
- how to make undeleted record
- Trigger fails when stored procedure is called two times in a row
- how to change the data type
- DB2XML.Content fails to export into file
- Changin Hostname ...
- SQL Problem with date ranges
- understanding health monitor output
- query bailing out after one row returned?
- query bailing out after one row returned?
- Calling a COBOL Subroutine from COBOL/DB2 Stored Procedure
- DB2 on Windows to DB2 On Mainframe
- Synchronize Outlook data with 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?