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
- UDB Migration from LUW - Mainframe DB2
- Concept Question re UDTs in UDFs
- Error on data type Number(X, Y) with DB2 Connect v 7.01
- SELECT outer join
- ODBC error
- DB2 & AIX or OpenPower 64-bit Platforms ?
- sql help
- Need help missing log file
- Who to Import PostGRESQL 7.2.2 database into Db2 7.2
- Remote DB2 administration
- No experiences with UDB 8.2 on Linux Suse
- QADBXREF authority - aliases creation
- V8.2 SQL stored procedures implementation
- 7.2 client slower when connecting to 8.2
- IMPORT with REPLACE piveleges needed
- what is rowcount from UPDATE called in db2 cobol pgm?
- showing actual values in sql statement event monitor
- Putting Auto Commit Off on the Server
- C# and db2app.dll
- functional dependencies from column correlation
- hospedagem de sites - planos de hospedagem - hospedagem 22727
- Compile problems
- Keeping DDL's in sync
- sqlj Command Doesn't Work
- Which tool to use when creating/compiling procedures?
- How to automate creating a database, tables, index, procedures...?
- DB2 V7.1 DRDA environment TCPIP and DIST address space CPU usage high
- Qucik Question in DB2 2 way Replication (Update Anyware)
- Strange error in UDF
- MS SQL Profiler equivalent in DB2 8.2?
- How to display dependencies for a view (source tables)
- Oracle Migration - LAG function equivalent.
- Chasing down dormant user accounts
- ADO.NET Isolation Level
- Can I pass a parameter from a stored procedure to a table function that is joining on other tables?
- More HADR thoughts
- HELP NEEDED for Internal error 0xFFFFF707 which cause DB to go Crash Recovery
- Need help generating SQL select statement
- hospedagem de sites - planos de hospedagem - hospedagem 52225
- getting LIST APPLICATIONS to run...
- SQL0104N on insert of consecutive NULLs
- Sr. SAP resource - Fixed Assets / SME
- Limit on Items Using "IN" Function
- DB2 Governer - db2gov: GOV1062N Unable to start governor at node "0". rc = "53".
- CALL Procedure with OUTPUT parameters
- Create an SP that references a non existant SP
- Latin -- English
- Hadr, Congestion, Recover-Pending
- How to do a commit after each insert inside an SPL ?
- SQL2072N Unable to bind the shared library "". Reason code: "".
- Archiving data from 2 db2 tables...........
- DB2 v8.2 Installation Problem
- MOVE DATA FROM ORACLE TO DB2
- Copy "related" tables data from MVS to UDB on NT
- More on the design advisor
- db2updv8 lead to strange error
- DB2 Questions
- c# and udb 8.2
- Redistribution of V8.2 data warehouse
- DB2 v8.2 Installation Problem
- LARGE INSERT in STORED PROCEDURE
- generate UI from constraints
- Difference between runstats and reorgchk ?
- Java UDF Question
- Help needed for 'sqloopenp' errors in db2diag.log
- table udf's and java
- DB2 Configuration Assistant and ODBC System DSN
- DB2 Authentication
- How to convert MS SQL SPs to IBM DB2?
- db2licm -l
- DPROP / SQL Replicator
- db2jcc with GCJ
- db2 unix man page
- Best way to transfert high volume data between AS400/DB2 to Unix-Sybase
- Urgent - security issue with SQL SP and UDF
- looping on db2 get snapshot for locks on <db>
- REORG & DISCARD
- pi()
- Temp tables and UDFs and multiple subsystems
- [IBM][CLI Driver] CLI0109E String data right truncation. SQLSTATE=22001
- db2 version 8 load
- DB2 WSE 8.1 Authentication
- Query Question - Multiple Tables
- as400 join sqlserver...
- Filling ksh array with db2 returns..
- CASE syntax in check constraint
- update taking forever
- Java UDF Questions re scratchpads
- Problem Installing DB2 Connect Personal Edition Version 8.1 for Windows
- Replications "Tables"
- Table size and index size
- Switch Tablespace Type During directed restore
- Question on the design advisor
- Performance Issue: BI Reporting tool: DB2:Query
- Moving CLOB data from OS/390 DB2 to UDB V 8.2
- SQL question: Matrix creation
- Multiple DB2 versions on AIX
- Message i db2diag.log from 'oper system services sqloPostIPCWaitPost'
- Federated database
- UDB 8.1 - Case Insensitive (shared-weight)
- merge error (udb db2 v8.1.5 linux)
- Db2iprune location
- DB2 Developer Works - RSS Feed?
- Why are 2 ports required for a HADR Pair?
- SQL1031N Error while creating database
- SQL Server 2005 - Still not upto it
- no suitable driver db2 tomcat 4.0.6 linux redhat
- Elite NYC invesmtne firm seeks DB2 developer
- MERGE commit count
- Is there some application can help export only the changed data from DB2 ?
- sqlj code
- can not start database
- db2look question
- Cursor
- IBM and Ascential
- ADO dates and '0001-01-01'
- Reliabilty of DB2 Connect / ODBC / AS400
- simple select question
- Unable to update a Created Global Temporary table.
- How to build database to support user-specified attributes?
- Multiple INSERT
- DB2 on Solaris 5.8 linking with PAM module
- Help installing IBM Content Manager 8
- Using Purify with db2 CLI application
- calling Philip Morris, errrrrr, Mr. Adamanche
- Why is this happening in `Enable Query Optimization`
- UNInstall db2 code on Win2K
- odbc driver for db2 in OS/390 ?
- ORACLE MIGRATION - CASE Statements.
- How to pass variable in dynamic SQL?
- Development Center refuses to work at all
- default base
- Zugriffstatistiken
- DB2 Packages
- top ten guidelines ...
- Development Center build
- Schema query
- DB2 Fast Load and Unload
- export utility - does anyone have any benchmark numbers
- More CPU???
- FUNCTION: MODIFIES SQL DATA
- Getting SQL0526N error when updating a Global Temporary table.
- V8.2 FP1 automatic startup
- DB2 Load Abend
- DB2 command slow after Migrate to AIX5.2 ( RS/6000 H50)
- Looking for a good book
- db2iprune
- how to ignore in an insert statment
- unable to obtain solaris fixpak for DB2 8.1
- federation between MF subsystems
- Any equivalent to setSQLstate and setSQLmessage in DB2JAVA UDFs?
- Installing InfoCenter on local drive
- How to assign a DB2-Instance to a unique IP-Address (and Port - of course)
- simple, segmented, or partitioned tablespaces
- SQL30082N, Reason 19
- Error in DB2ICRT on Fedora Core 3 running x86_64
- plug-ins for Stored Proc Builder (Dev Center)
- Re-install Development Center
- Bitmap indexes
- CLI0125E Function Sequence Error. SQL STATE=HY010
- Fetch first
- Replicate
- Migration Problems - SQL1039C
- Migration Problems - SQL0535/SQL1088W
- db2 v8 fp7 on hp-ux11i
- DB2 UDB V8.2 and DB2 V8 on Z/OS
- ORACLE MIGRATION - EQUIVALENT IN DB2
- Move a Storage management view
- Import of csv-File
- Load using VB6
- Install problems re DB2 V8 (FP8)
- Take a bow IBM with your HADR implementation
- Need help with V8.2 install
- check constraint performance on zos/v7
- ORACLE MIGRATION ISSUES
- SQL 2000, AS400 and Client Access
- a non-edu child crashed
- Expiry Date of license?
- HOW-TO: recreate a big set of interdependent UDFs...
- STRIP: Expected tokens may include: "<strip_spec>"
- Removal of old entries in Journal or old storage snapshots
- DBAINTRN: SQL22206N
- Constraints
- DB21034E
- Container Operations Through a Roll Forward.
- DB2 UDB or Oracle (who's got better support)
- DB2 User Group Italy - next meetings March 2005
- DB2 Connect with MDAC
- How to setup lobsinfile when importing LOBs to a table?
- UDF Design Question
- Need help with an automated backup process problem.
- SQL0104N when using STRIP UDF
- Retrieving get_db_config information in SQL statement.
- Connection port not listening
- Help in gathering deadlock information
- Speed up backup
- Migrating DB2 v7 to v8 on z/OS
- DB2 Licensing/Update Questions
- Multiple DB2 versions on Windows?
- Replication with UDB v8
- db2cmnclp
- Health Monitor / SMTP Server
- SQL30083N Attempt to change password for user id "17"
- import & internal commit
- Replication with v8 UDB
- Local config vs. LDAP, weirdness connecting
- UDF Driver?
- Help needed.....
- update db2 version 6.1 (Sun Solaris 7)
- update db2 version 6.1 (Sun Solaris)
- Design advice
- How to interpret db2diag
- Big Endian / Little Endian bind variable problem
- Can you rename a DB2 instance?
- How to retrieve register values?
- Question on a table reorg with clustering index.
- US- MN - Functional Oracle Consultants
- Need help with SQL - connect to multiple data source in DB2 AIX
- Very basic performance question
- Static cursors in DB2
- How to I delete a column from a table in DB2 on AIX or Window Environment
- IBM Websphere Information Integrator - distributed transactions
- Automatic Runstats
- SYSADM privileges? How to assign?
- UDB 8.x FP8 Windows (XP-SP2)
- db2_all with muliple commands
- questions on HADR on tables with "not logged initially"
- How to auto start DB2 service on Linux Suse 9
- Federated connection issues
- Problem with EXPORT HIERARCHY
- DB2 Memory usage
- Connect to DB2 database through PHP WITHOUT ODBC ?
- Secaucus, NJ -- AIX Developer
- Plano, TX -- C++, CORBA, UNIX
- Bloomington IL -- Technical Analyst / Security (Oblix)
- Meaning of lock_mode values in SNAPSHOT_LOCK function
- DB2 UDB LUW 8.2:clp 32 bit connect to 64 bit engine
- How to reterive the last 5 records in a table?
- "FIND" command is narrowed
- Schema mapper
- Sample package
- Fenced User
- Easiest/fastest way of storing a schema and default data in source control?
- how to extract one row from each range data
- DBMS_JOB equivalent?
- uninstalling a fixpak
- DB2 v5r3 FULL Join?
- 8.x FP8: concurrent database activation with AWE-Memory cause the instance to crash
- Installation error with DB@ Personal Edition v8.1
- db2diag.log code ffff 8528
- Connected, Unable to Work
- Semistructured data in DB2
- Archiving data on very large tables
- db2move
- does Not logged initally affect rolling forward recover?
- Creditwrench
- Load command on table, field timestamp primary key
- Escaping semicolon embedded in string values in db2sql92
- Require : Dumps and guides for Test 700/701
- TO_CHAR(date-value, 'HH24') returns error: type, length or valueof arg is incorrect (42815)
- Left Outer Join Using Views
- Error SQLSTATE=42703
- Field created from case statement / SQL0312
- How to perform bitwise operations
- Cool File Encryption Software Released.
- RID
- loading a timestamp
- DSN1COPY
- numdb reset???
- 32-bit vs. 64-bit ??
- Page Cleaning of Buffer Pools
- migration of postgre to db2
- userid disabled or restricted in DB2 8.2
- DB2 Image Copy & Restore..
- SQL/400 and "TOP x" function
- How do I make a VIEW read-only?
- do i need to exclude transaction log while replicate
- Problems with db2 log archive
- Difference between inbound_comm_address and corr_token
- Problem with MONTH() function
- Problems with archiving logs.
- DB2 Universal JDBC Driver and {fn CURDATE()}
- Federated setup - additional column
- Deleting Rows from DB2 table that Contain LOBs
- SYSPROC.DB2LOAD
- How to analysis the Performance of DB2 UDB 8.1?
- federation windows-aix
- What are security risks with running DB2 services using local system account?
- Federation of DB2 Instances Across LPAR's
- force in a join the election of a table as the most important
- What is the difference in the update statements?
- trigger logic
- Swap space usage
- Mark Townsend, Oracle Product Manager, on posting in DB2 newsgroup
- IBM.Data.DB2.iSeries database access problem
- What is node migration ?
- How to analyse poor performance of the database
- db2 size and performance
- reorg & data corruption
- db2eva help.....
- Seeking some planning info for DB2 UDB LUW REORG
- force rollforward pending state
- reorg performance and online reorg
- DB2 8.2 on linux x86_64 - authentication options
- win98
- DB2 UDB DBA needed
- Question on db2licd command for applying FP6
- Fault monitor question
- Updating Partition Key with Before Trigger
- Running DB2 Stored Procedures from Microsoft SQL Server 2000
- type2 vs type 4 drivers
- DB2 V8.2 HADR Questions
- AWE Bufferpool: instance crashing with DB2 8.x ESE FP8
- recover tables db2
- proble database
- What is wrong in this statement?
- DB2 CLP - formatting text columns
- Cross-platform DB2 UDB restores with Linux on POWER5
- Stored Procedures error SQL0440N on db2 8.1 fp5
- Moving data from UDB 7.1 to UDB 8.1
- Wrong values for dft_,mon_table in 8.1 FP 8 in db2diaglog, if chaning it ?
- Restoring a Tablespace level backup to another database
- V8.2: "Attempt to create interval of 0-dimensions"
- DB2 Exam 700
- Diffence between Quantified Predicates: IN , ANY, and SOME?
- Equivilant of Oracle's DB Links in DB2
- Preloading data/table in memory?
- num_poolagents doesn't add up
- unit of TOTAL_EXEC_TIME in SNAPSHOT_DYN_SQL?
- v8 Dynamic Scrollable Cursors
- ODBC Issues - SQL0443 SQLSTATE=38553
- calling stored procedures via oracle odbc
- HOW To get Monitoring VALUES in sqlmon.h
- SQL0443N Routine "ALTOBJ"
- Question on IY54968: IN THE DATABASE SNAPSHOT,"APP ID HOLDING THE OLDEST TRANSACTION"IS INCORRECT.
- help with db2image extender 8.2
- help with db2image extender 8.2
- Prometric Test centers in Chennai(India)
- Is it possible to Hexadecimal or Binary Value as the input to WHERE clause in query?
- Message in db2diag.log after returning to version 7.2
- Websphere Compliance Auditing Tool (DB2 Based)
- UDF with dynamic SQL and result
- The best tool to analyze and document.
- Cannot connect to remote db via 'Federated Database Objects'
- Install problem on Windows XP - VerifyPrereqsCA
- JDBC Support by DB2 Fixpak
- DB2 installation on Mandrake 10.1
- task center
- Reorg table/index questions
- DB2 numerical data type on HOST instead of bigint
- What is the difference between Alias and Nickname?
- What am I missing?
- specify package names for sql stored procedures how?
- DB2Connection.typeMaxVarChar=254??
- Primary key and Unique indexes in UDB Vs Oracle....
- SQL error 204 when we try to access tables via alias
- DB2 SQLCode Connection lost.
- DB2, SQL Server, Oracle
- UNIQUE WHERE NOT NULL
- Replace JAR failed in DB2 Development Center on AIX
- DB2 Technical Support
- db2 store procedure build failed.(aix 64bit server)
- setDB2ClientUser ?? example
- .NET and UDB2 Transaction Manager
- ZLES 9 Suse Linux and UDB 8
- ZLES 9 Suse Linux and UDB 8
- DB2 UDB v8.2 - SMTP Server Configuration
- Temporary index is not taking in the Stored procedure
- AS400 JOB - Sydney CL, Cobol etc.
- before trigger on 390/V7
- 64-bit instance on Aix 32 bit kernel / 64 bit hardware
- DBI1124E Instance inst1 cannot be migrated.
- How to reset/restart/modify the IDENTITY counter?
- Performance-related Issues on a Restored DB
- application program - question
- Error using Fast Path DB2 course from IBM
- What does this mean?
- Accessing a remote DB2 server
- single table query multiple indexes
- DB2 Client Access Licensing Question
- DB2 UDB 7.x BufferPool change
- Client Access ODBC driver problem
- Exporting and Importing tasks to Task Center
- sql0199 error
- Obtaining a list of databases within an instance using only the CLI commands
- db2 udb 7.2 config question
- Install DB2 CAE v5.2 using a response file.
- How to find routinename associated with a particular package??
- Merging a data mess
- export and dateformat to produce CSV file
- DB2 Run time client setup on XP won't install TCP/IP
- Fun installing db2 8.1 in a suse linux box
- OnDemand TSM
- HELP --- unirpc no port avail
- How can I terminate locks manually?
- DB2 & jdbc
- db2 and stored procedure
- Steps on db2 trace
- Identity values in dynamic SQL
- Which DB2 for Intel Xeon with EM64T Extensions on Linux
- Tips and tricks for fast SQL procedures
- Backup of DB2 on Windows 2003 using open file option
- reduce size of log files?
- reduce size of log files?
- reduce size of log files?
- Retrieving database record with the lowest value in field aaa?
- autonomic feature DB2 V8.2 question
- db2fm questions
- Date conversion
- Explanation/help with DB2 memory Usage on Linux?
- DB2 Command Center not working properly .....
- Converting NUMBER, DATE and VARCHAR2 database fields from Resultset to variables?
- Getting MetaData for JDBC tables with getTables() does not work?
- IDUG 2005 - Europe: Call for Presentations
- Some thoughts on netiquette
- Performance problems when inserting into a large table
- Questions regarding large MDC tables
- Please take a look at this great program
- Is the Database Administration Service part of the standard installation or an option?
- No Keys on Federated tables
- DB2 Backup Error
- Finding if a character is alphanumeric
- Database Administration Survey
- create triggers
- Any DDL Information on the DB2 Logs?
- deleting records without writing to the transaction logs
- Reason Code: negative number
- E monografia Administração E
- questions on Design Advisor after FP8 apply
- Question on FP8 install process
- Detecting the INSERT format for DATE database fields?
- ODBC update error with DB2 timestamp data
- Full-time DB2 UDB DBA position in downtown Portland, OR
- db2jcc driver issue with getting an empty resultset
- sqltypes.h compile error?
- Issue with a stored procedure
- Statment too long or too complex
- Full Backup of DB2 V8.2
- How to use collect statistics for temporary index?
- Which DB2 on IBM xSeries 346-8840 with SuSE Enterprise 9 ?
- DMS tablespace size calculations
- .net installers
- Trigger porting problem
- I dont think y can
- SQL Code Beautifier for DB2
- Before delete triggers
- Federated Table Errors
- Access DB2 UDB thru teriminals
- Access DB2 UDB thru teriminals
- db2_all/rah completed rc=-10 on Windows 2000
- DROP error level (20) on iSeries UDB
- vargraphic column Question.
- Using SQL against Non DDS files?
- Memory Visualizer?
- create trigger -> invalidates stored procedure
- Can a table UDF modify SQL data?
- revoking select from all tables
- DB2,UDF,modifies sql data
- Reading triggering table data in trigger (without error SQL0746N)
- 3390 mod3 vs. mod9 performance
- DB2 V8.1.4 aix 32-bit to 64-bit migration
- Client for DB2 UDB 07.02.0007 database
- Large table redesign
- How to find actual LENGTH of a CHAR string
- Fixpack 6b?
- Is there a rule for determining number of Page Cleaners?
- Windows
- SQL0204N
- Multiple Tablespaces
- Washington (DC) Area user Group Meeting - January 27, 2005
- Will we be able to apply FP8 directly ?
- SQL0104N An unexpected token "END-OF-STATEMENT" was found
- updating a lob
- how to read exported files?
- db2 conf. on HP UX problem
- IBM DB2 Connector throws exception with .Connect() in .net
- Decrease database size
- How to determine what table got offline?
- Bufferpool reduces performance.
- Suppressing DB2 logon prompt
- SQL output, do I need recursive SQL todo this?
- Copying an existing DB2 database
- db2 block archtiecture
- DB2 Basic queries..
- DB2 Basic queries..
- Need help decrypt db2diag.log
- Where does one find a DB2 UDB DBA?
- Insert with RR causes Table Lock (DB2 z/OS V7)
- jsp - jdbc connection to db2v8 failing
- Stored Procedure Question
- How to retrieve FK reference infomation
- DB2 redbooks RSS feed
- AIV Extenders - where can I find it?
- db2 connect 7.2 on Linux with OS400 V5R3
- IBM Visual Studio Add-in v8.2 , Problem when trying to compile a stored procedure
- DB2 Personal Edition License Question
- db2look spools DDL in the ascending order of DB objects Timestamp only
- Connection to other database
- Problem to build Java stored procedures on DB2 V8.2
- multiple DB2 instances under one OS userid?
- DB2 8.1 Work group Edition Pricing/Licensing
- Multithreading in java stored procedure
- CLI0108E Communication link failure
- Branch elimination for a query on a UNION ALL View does not work as expected
- check constraint questions
- FP8
- DB2 error using the command with USERID/PASSWORD
- Not logged initially for Simulation catalog tables ?
- Uniqueness in a Nullable Column
- Question on reorgs
- Data moving from iSeries to DB2 UDB
- A VoIP usergroup
- Dont visit this site
- Insert Clob using Perl into DB2 v8 on OS/390
- Error Reading DB2 BLOB field : Please Help
- How to find the number of threads ?
- udb cursor (or curser)
- automatic statistics
- GROUP BY question on standard
- DB2 error using the command with USERID/PASSWORD
- log files full autocommit
- Windows UDB Question
- Functional Index.. How to?
- DB2 error using the command with USERID/PASSWORD
- memory leak in APPLHEAPSZ ?
- Cross-endian DB2 backup compatibility?
- the database with many inserts vs less reads
- Control Centre - Create -> Text Index (V8.2) , can you do it?
- Redirecting DB2 output in Korn shell
- Type 4 driver licencing error message ....
- Creating UTF-16/UCS-2 database in AIX
- How to log the source IP address of DB2 connection?
- db2advis -m C?
- SQL Compiler for Linux on AMD/Opteron-64 bit machine
- am I too tight on memory?
- How to find the version of the client...
- Can we use ORDER BY clause inside a SQL UDF
- db2diag error - "oper system services sqloWaitInterrupt Probe:10 "
- util_heap_sz - optimum value?
- Second call: third edition of SQL FOR SMARTIES
- Bookish Question Regarding DYNAMIC RESULT SETS
- LOADing BLOB
- Problem while using PUT Routine.
- Increase Decimal length in v7.x
- DB2 v MySql
- Triggers fire before commits... and can not be rolled back?!?
- where to buy udb 8.2 express
- Reg 704 - DB2 UDB V8.1 for Linux, UNIX and Windows Advanced Database Administration certification
- SQLCode -512
- REXX routines, zpharma DB2