View Full Version : answers
- Re: SQL 2008 published - Highlights
- Recursive SQL Question on breaking the infinite loop.
- Add a DB2 database partition in different drive
- Add a DB2 database partition in different drive
- Add a DB2 database partition in different drive
- Add on New partition IBM DB2 Database
- settign DB2 environment under Windows without using db2cw.bat
- Need help on SP with GTT
- SOMET_09
- PRIQTY and SECQTY
- Re: Need help to canvert oracle funciton last in db2
- Db2
- Difference between automatic and Auto-resize tablespace
- SQL 103 - "Numeric literal invalid" on SELECT *, but not SELECT a,b,c
- Maximum number of STRIPE SETS in a Tablespace
- DB2 EE LOADER
- Read Blob field
- Yellowfin seeks resellers for BI product
- Monitoring DB2 JVM
- robust optimisation
- OUTER UNION
- Storage required for VARCHAR in V9.5
- DB2 page structure
- db2 express C and file XML
- db2ckpwd uses a lot of memory
- IBM DB2 Content Manager eClient v 8.4 configuration fails
- Certification in Mind???
- More than one second of CPU in one second
- clustering index - will your table be arranged by the columns here?
- Crash recovery for LUW on Linux
- Which are the best R&D websites for DB2 internals?
- HELP DESK SOFTWARE APPLICATION DESIGNED
- disable windows db2 user
- Error in Stored Procedure (DB21034E)
- db2 udb crashed
- sql0954
- How to safely trim log space
- Midnight query chalenge
- Can I create unique index on selected records ?
- Urgent openings for Informatica with CMML @ PUNE, India...!
- Can I use "Get Snapshot" for DB2 on mainframe?
- Tablespace containers not accessible
- connect Z/OS database from windows
- Activate NIS authentication
- Problem While loading from Client Database
- Parameterizing Schema name
- Copying a DB2 database from one server to another
- Call to SP in partitioned env. not allowed
- DB2 Express-C on Vista/Business
- Looking for participants for a 30-minute DB2 survey
- Run sql from Dos
- Automatic maintenance policy files
- conversion from db2 to oracle
- Change value in IMPORT
- Query size limits
- Query size limits
- ANy one can plz send me some DB2 V9 (730 exam) dumps
- db2 username length 8 characters limit
- Function to convert for bit data column / field to INTEGER?
- Function to convert for bit data column / field to INTEGER?
- How does a SYSIBMADM created
- Lock issues in db2
- Is there a 'non-mandatory' relationship in DB2 8 for Z/OS?
- perl dbi built on DB2 8.2 does not run on 9.1
- How to call a stored procedure from a trigger ib DB2 ver 7.x
- Newbie question - this is highly unusal
- Purging task output
- Remote debugging in Java stored procedures
- DB2 Live Database Replica for Reports
- DB2 UDB for z/OS V8 Sample Programs needed
- Connecting to CA-IDMS via JDBC drivers
- calling SP from UDF
- Paging steadily increasing over time
- MQT on a nickname
- PL/1 DB2 V8 Table Declaration for a CLOB
- PureXML
- trouble with C-written application and UDF on 64-bit Windows
- remove large number of rows using SQL only
- remove large number of rows
- Control Center problems
- max sequence value --- how?
- FETCH into sqlda structure
- Treatment of SMALLINT in Java Program
- cannot run db2imigr even if LIBPATH set
- DB2 Run time client
- SSL support for natvie DB2 LUW (non-SQLJ/JDBC)
- Preventing First Steps Launch Pad screen
- formula to calculate DB monitoring parameters
- Finding Tables without any Primary key
- What can we do about these non-topic postings to this group?
- What can we do about these non-topic postings to this group?
- Table in Load Pending state but Terminate command does not work
- Cobol cursor and update processing
- enable_MQFunctions in DB2 V9.1 x64
- How to import database schema back to DB2
- spam
- how to backup db2v8 in linux os
- HADR support for DPF partitions
- Why this Stores Procedure is not working - puzzled
- Not able to connect to db !
- Re: Rewrite LUW query to work on z/OS
- I need to check the position of '(' in a string.
- mon_heap_sz
- hello i need help with torque (java )to setup him to db2
- [Test]
- Why is DB2 not releasing memory sooner?
- Newbie on SQL & Excel
- Latest updates in database mangement and many more
- Re: How to check SQLCODE in trigger
- SQLOGDIR permissions in AIX
- spam
- spam
- TCPIP problem
- DB2 Express UDB 9 with db2jcc JDBC driver- Issues with Auto generatedfield
- Re: How to avoid 2nd trigger
- Any suggestion on how to speed up large batch inserts?
- Sql Code = -311
- Problem with IN predicate
- Re: ADVICE NEEDED: Removing Inner Tie Rod Ends - TWO QUESTIONS
- Special register USER
- db2exfmt and missing function EXPLAIN_FORMAT_STATS
- Offline backup logs
- V9 runtime client setup problems
- overflowlogpath and hadr
- SQL0100W error...while returning result set
- UDF Portability?
- Calculating Business Days Between two dates...
- What's the meaning of IID=0 in output of db2pd command
- User-defined aggregate functions and OLAP windowing
- Job Opening
- about online reorg
- How to connect IBM DB2 with JSP?
- notify/listen?
- Tablespace qualifier in DB2 UDB On Linux/Unix/Windows
- Aggregate Concatenation
- backup falsely marked as in progress. can i clear this state?
- store procedure error
- issue for label on table
- How to LOAD deleimited data with linefeeds to mainframe DB2
- Query exceeds specified time limit or storage limit
- Re: SERGE I AM TRYING IPLEMENT YOU TRIGGER
- DB2 Views
- Automate delete archive log !
- search image by content
- changing the authorization of the tablespace's tables
- never-ending LOADs
- inserting data into a dependent table
- Redirect SELECT results to a file
- need help with the trigger
- DB2 patches - need historical record of proof
- Schema size(Size of all the tables in a schema)
- How to invoke db2top in batch mode
- Backup Online db2 9.1
- Latest updates in database management and SQL server
- brothers and sisters must register and send this article to users
- UDF RETURNS DIFFERENT TABLE
- Declare result set variable in procedural SQL
- DB2 8.2 Workgroup Server Edition limitattions
- Sqlcode=-443, Sqlstate=38553 Sysibm:cli:-727
- SQL0101N The statement is too long or too complex. SQLSTATE=54001
- Timestamps on data records, Documentation on old versions of DB2
- privileges on functions
- Find a sentence with words separated by multiple spaces
- Re: Migrated From v7 => v9 ... and Now Can't Use Semi-Colons inStrings?
- library compatibility libdb2.so undefined reference to`__cxa_guard_acquire@CXXABI_1.2.1'
- Yellowfin Business Intelligence Release 4.0 Announced to Industry
- Temp tablespace - system or user?
- TRANSLATE function
- SMS TableSpace - Reorg not releasing space.
- Multiple fault monitors from different db2 versions
- Re: Delphi + Stored Procedure + Locks
- Change default TimeZone in DB2 [JDBC]
- Export utility is taking long time
- Export utility is taking long time
- Export utility on a table is taking long time
- Runstats error
- DB2 Performance tunning
- Re: Community's water tower perhaps somewhat in questionable taste
- Re: Migrated From v7 => v9 ... and Now Can't Use Semi-Colons inStrings?
- Urgent - need help
- CREATE TRIGGER ON INSERT
- the option CPU_PARALLELISM of LOAD
- When does a stored procedure use an MQT
- Re: Question on syscat.keycoluse.colseq
- Getting group of data for each member of primary key
- FYI: IM Consumability Survey
- Parallel SQL (forking) in SQL stored procedures
- Question: restore from backup in relative path...
- Re: Otra vez sin news (news.tie.cl) ...
- converting DB2 triggers to Oracle
- error messages for key constraint violations
- z10 or z9
- Re: Questions to FAILARCHPATH and HADR
- MQ Functions included in DB2 Workgroup Edition?
- FYI: DB2 for LUW Best Practices
- Find the latest updates in database management of IBM
- CLOB and searching by it
- Reorgchk, Reorg, Runstats not having any effect after completion. Why is this?
- SQL to find if table has identity and/or row change timestamp columns
- DB2 9 runtime client install
- Estimating performance on an OLAP database (virtualization vs. serverinstall)
- How can I use shell script to remove specific records from a flat file?
- import XML file into DB2 table
- DB2v9.5 64-bit does not allow me to chose location of user tablespaces. Why?
- Trigger fire a query
- bind file recovery
- How to terminate idle agents?
- DB2 query hours difference
- Migrated From v7 => v9 ... and Now Can't Use Semi-Colons in Strings?
- Control Center SQL Assist
- How to get 'message text' portion of error from SP
- String comparison in DB2
- Getting rid of nuls
- Getting memory size for an application
- Catalog Service - User interrupt detected
- Is it possible to "enable" auto-rollback functionality whiledead-lock occurred on DB2/400?
- BACKUP & RUNSTATS running simultaneously
- db2 load using v9.1 client into a v8.1 fixpak 16 database
- CPU usage in DPF on Windows during massive parallel single rowinserts
- Loading Data from SYSCNTL and SYSREC files
- CTEs in UDFs
- Parameter markers in LIKE clause
- What is SQLCODE=-3196?
- Oracle Database Training, Practice Tests
- Need help w/.ksh script to REORCHK & output Recommended tables to a file
- How long does it take to migrate db from 8.2 to 9.1 on LUW
- Re: Takers for a Friday SQL puzzle? Timestamps and recursion...
- Re: Takers for a Friday SQL puzzle? Timestamps and recursion...
- How can I installed DB2TOP on my windows or Linux?
- Re: Takers for a Friday SQL puzzle? Timestamps and recursion...
- HCL, Aricent, Infosys and many more companies hiring fresh &experienced engineers ,
- Database Application Front End
- db2 client hang - db2osse!ossLockGetConflict
- Re: Olympialaisia terävänä
- How to get list of database?
- [z/os] Finding location of DB2 specific copybooks
- Redirected restore DMS -> SMS (or automatic storage) possible?
- Is it possible to develop ODBC program on AIX?
- how to develop embedded SQL program by C language?
- Lock waits during online backup
- Re: How to reset auto generated id in a DB2 table
- Is replication really transferring data via my desktop PC?
- How to reset auto generated id in a DB2 table
- DB2, vim, and dbext
- Ask for help from ORACLE board: matching normalized and denormalized tables
- DB2 'CASE' puzzle slqerr -811
- DB2 Performance Monitor.
- how to define such a trigger....
- Cross Platform db Restore
- Distributed statistics and optimizer
- Re: How to get stored procedure definition?
- How to get stored procedure definition?
- .databean.jdbclob from DB2 Control Center
- how to create Store procedures without using development center
- Can someone enlighten me on 'handles'?
- SMALLINT casting difference on Windows vs AIX
- Is there is a way in DB2 to return multiple fields from a single case
- DB2 9.5 fixpack 1 stalls when running script
- Re: perform date and time arithmetic, represent seconds and dates inDB2
- SQL-> RDF or other question about linked data? Win a pass toLinkedData Planet for best question.
- Update, case, and -407
- Can i drop a cloumn from a table in DB2 for Z/OS
- DB2 Intelligent Miner - for 64 bit AIX 5L
- Control Center - Activity Monitor Permissons?
- root owns files in db2 instance directory.
- Re: DB2 Query Help
- DROP PACKAGE with hex zeroes
- Performance Goals for DBAs
- Query from ORACLE board is not working in DB2
- stop remote instance
- stored procedure or SELECT statement
- monitoring backup
- SQL statement not supported error SQL1042N for MQT defn on a nickname
- Generate Unique Number in DGTT
- any warehouse database upgraded to v9.1? or v9.5?
- decimal to date
- Stored procedure, first run slow
- LDAP and caching on DB2 9.5
- loading in to generated row change timestamp column
- ADD A COLUMN IN SERTAIN POSITIONS:
- Reading Arabic data from db2 v8 using db2 wire protool
- DB2 UDB Installation on Windows Vista
- DB2 memory usage help
- ho w to see the output of "Message_Text"
- DB2 on z/OS different than on LUW ?
- move rows from one table to another
- Re: Long compilations
- Database Management
- Multitable insert in DB2 v8 os no Merge is avilable:
- Re: Long compilations
- Plug-In extension for Control Center
- How to fined un-unused indexes on DB2 /ZOS
- TRUNCATE stored procedure
- Get Diagnostics
- Multi-row insert timestamp error
- V9.5 and SQL1084C
- DB2 contoken split by PLI compiler
- Is this is output from EXPLAIN?
- Schema on Db2 database installed on Main frame machine zOS.
- How to calculate difference between 2 columns excluding nulls
- Re: SQL - Unexpected result
- collating sequence
- Re: SQL - Unexpected result
- problem: sum is incorrect (e-10)
- Rolling out V8 client using response file
- Re: DB2 equivalent for ORACLE SQL*Plus BREAK???
- Seeking simple after insert example
- Re: rollup for DB2 UDB for iSeries ?
- IDENTITY PK-FK corruption of data
- AS400 STRSQL vs RUNSQLSTM
- Throttle automatic runstats
- LIST all available db2 server in my farm lan
- How to replace VALUES IN UNPIVOT QUERY
- IDENTITY columns as foreign keys
- Symbolic links for containers?
- size of numeric data
- Re: CTE CONVERSION TO DB2
- DB2 Tools, DB2 administration server, transmitRunCmdMessage, probe:30
- Subquery decorrelation
- Re: CTE CONVERSION TO DB2
- Cannot redirect restore into a different database name.
- Re: Update Statement and frequent commits
- Altova v2008r2
- Archive logs?
- Instance choice in JDBC url connection
- CHECK CONSTRAINT on DB2 V8 zOS
- about snapshot monitor
- DataServices World (June 24, New York City) early bird registrationexpires 9 May
- ANSI Dynamic SQL syntax in DB2 [789] for z/OS
- Not able to assign select query "WITH UR" CLUSE TO A VARIABLE
- Row and Statement based Trigger Question
- Re: Looking for SQL statements database
- Administration server startup error after installation of DB2 V9.5
- Trouble. Please help.
- Federated database access
- Shift_JIS to UTF-8 Conversion
- parameter limit for XML datatype
- convert a decimal number into character
- Date function in DB2 V8.1 for Z/OS
- Alter Table causes SQL0901N ( SQLSTATE=58004 )
- db2 connect 4 minut delay after adding partitions
- db2 v8
- How to add leading zeroes
- Again against generated columns or (missing) row value constructor inwhere clause
- Question about tablespace design
- How to reduce the highwatermark for a DMS tablespace?
- db2rbind after runstats?
- Deleting ID which owns scheduled tasks...
- Extract LOG file from Backup Image created by NCLUDE LOGS
- Best scripting language for DB2 with a java implementation?
- Space between characters
- Determining Table Status?
- DB2 CONNECT configure and Sysplex support
- Get a COUNT(*) for all tables in a schema?
- SYSSH200
- Problem using sqlj with type 2 universal driver - Db2, z/Os, v8.2
- SQL0437W Performance of this complex query may be sub-optimal. Reason code: "1". SQLSTATE=01602
- express-c and php very slow
- Get "user" tables
- CLI Trace - Syntax Error
- Dynamic statement cache on LUW
- connect to db2 9.5 server slow
- ROLLFORWARD failed
- concept behind in db2 software as root with some files as worldexecutable
- db2 8.2 base release download
- Select privilage on all the tables in a schema.
- commit active -- forever
- What is the optimal average bufferpool read time in a multipartitioon datawarehouse?
- safe fallback procedure in windows on version 8 fixpack 14 to backon Verison 8 no fixpack level
- Commit Active
- Question about MIN/MAX optimization
- Current week job updates-visit www.northvacancies.com
- Re: How do I turn 2 separate select queries into the columns of 1select query
- db2stop and db2start require password in partition env
- DB2 UDB Warehouse
- Group privileges and views
- Sleep command in db2
- can a trigger do an execute immediate?
- Moving tables between an iSeries and DB2 for Linux
- Data Studio Developer: Platforms and Assembly Information
- A simpler truncation function that renders credit card numbersunreadable
- Learn querying DB2 system catalog tables -basics
- Raise signal with dynamic message_text
- Java Architects - Immediate Opening
- Query Help
- Deadlock due to table level exclusive lock
- store procedure to transpose rows to columns
- Repost (sort of) of an old problem
- Re: heavy inserts and bufferpool
- db2vshelpreg.exe error
- DB2V9.1 pureXML Creating Unique index with 2 attributes
- app driver and ERRMC delimiter
- Re: heavy inserts and bufferpool
- Re: heavy inserts and bufferpool
- DB2 on z/OS Mainframe
- Can I set up bidirectional Q-replication with both sender andreceiver server having HADR environment
- moving a C++ written application from db2 v8 to db2 v9..............
- Question on restoring databases taken across timezones
- systoolstmpspace : %%When is this tablespace used %%
- converting from time in seconds to timestamp format
- Partitioned table and its indexes
- catalog node and DNS lookup
- V9.1 Insert Trigger to extract attribute from the XML document beinginserted.
- how to archive lots of records
- How to change schema of table in DB2 v.8.2 without coping data
- WLM and DB2 9.5
- Contribution: quick monitoring script
- Re: Partitioning Key
- Curiousity about how other people do it.
- MQTs under z/OS - how to get IMMEDIATE REFRESH functionality
- Admin client for Linux Red Hat Linux AS/EX 3.0/x86
- CLOB tablespace locking
- XSD data into DB
- IMS to DB2 migration
- name spaces in db2 Xquery
- Convert character to date
- How can I change n-rows --> 1-row ? Getting constraint information.
- Reading DB2 Transaction Log files on Windows XP using DB2 API
- How to execute DB2 C sample file (dblognoconn) on Windows XP
- Need Help: Error while creating Store Procedure
- DB2 instance update problem
- Dynamic SQL in DB2 procedure
- Stored Procedure not working on DB2 8.1.14 on Windows XP
- Multiple db2diag.log files
- db2 restoration problem
- compare dates in yymm format
- Executing a DB2 stored procedure in Unix Environment.
- Creating a new Database
- Scheduling
- Performance Goals for DBAs
- order query on set function
- Problems in restoreing the database
- DB2/DATSTAGE issues
- DB2 Administration Server & DBA8001E & SQL22205C
- How to convert character to date in DB2
- DB2 equivalent for ORACLE SQL*Plus BREAK???
- Instead of Trigger
- escaping strings
- Variable as column or table name
- overhead in creating a new table
- Adding varchar of 32k
- changing the Isolation level
- readonly tablespace
- DB2 Stored Procedure
- EXPORT, Change the CLOB and then IMPORT
- CHAR to DATE conversion
- how to check for when a db2stop command is last issued
- dropped table recovery /tablespace restore
- What is XML extender???????
- define another default instance
- deleting simillar rows
- Raw Device
- SQLDA problem - data type doesnt match
- How to Insert an XML document in DB2??
- DB2 UDF create temporary table
- NEED HELP: How to convert Joe Celko SQL IN DB2 without Stored Procedure
- Java + DB2, import table data
- to ACCESS-DB from zOS/DB2
- Can MQTs use views as underlying objects?
- put 2 lines into 1 column
- deadlock
- rollforward recovery & rollforward pending state
- prob linking C with db2
- Sum result format is float(?)
- Looking for listing of MQT reason codes...
- How to get substring of numeric value
- Backup Pending State
- Load Pending State
- convert decimal to display 0.00 as '######.##'
- increase the size of UNIX window to see the entire output of a selectdb2 query
- DB2, Java, and multi-row inserts
- DROP system stored procedure restriction
- formatting the decimal value 0.00 to 0,000.00
- How to check "bad page" efficiently?
- Is there anything else to gather database size info?
- DB2 Express-C Global Temporary Table Performance on vista
- Refreshed Cross Platform SQL Reference Manual (9z, 9LUW, 5.4i)
- WPLAN: Set is skipped. errcode is 5E1603
- Tracing agent execution and activity
- Difference in default constraint syntax between LUW and z/OS?
- help for db2
- REORG Recommendation on HADR
- REORG Recommendation on HADR
- REORG Recommendation on HADR
- Wisconsin Benchmark DDL and SQL for DB2
- Need Help with query
- How to export/import DB2 database
- db2fmp...what is it running?
- Subquery Problem
- z/OS stored procedure doesn't return value
- How to use sequence in FUNCTION?
- How to access DB2 database using Microsoft access(SQL passthrough)
- Count the number of select on a particular table
- Need to setup a federation b/w 2 databases. Please help.
- sql confused
- Save results of a stored proc into a temp table
- Wrong Date DATE(CURRENT DATE - 1 DAY) DB2 Z/OS
- Drop / Rename a Column
- DB SQLSTATE check returns wrong value
- Table joins across databases
- Question: RI from one field in one child to two different parents.
- Cataloging database on unsupported platform
- SQL-question
- Restore DB2 9.1 backup problem
- Indexes on nicknames not in catalo
- Problem In DB2 First Step / Migration V8 to V9
- OSERR : 5 "Access is denied."
- I know OTLT is the Evil Undead, but I need that stake...
- Spufi Audible Tone
- DB2UDB V9.5 net search extender silent install on windows
- z/OS DB2 SPUFI called procedure
- difference in date transposed as total number of rows
- How can I query?
- db2 script needed to count and delete the data
- Questions to FAILARCHPATH and HADR
- v8.1(fp14) GET_DBSIZE_INFO SQL1131N
- import into db2 fails
- error when installing db2 9.5 in cent OS 5
- Convert MS Access to DB2
- find default tablespace
- SQL Error causing CPF5257 DB2/400
- current timestamp shows wrong time
- view optimization.
- Calculate the maximum total memory ever used by the instance
- Querying schema/description
- Creating an Audit Query
- Problem of UNION ALL view & Update of master table row in Paralel Execution
- List Queries executed on a database
- ORDER BY and FOR UPDATE
- Can't connect to database, missing log files
- loading alternative records into a table
- SMS tablespace limits
- How to get rid of an uncataloged node??
- Reg DB2 700
- Need DB2 701 Sample papers
- about create index online
- Problem with db2advis
- db2 load problem
- Users on dabatase
- Help with cataloging databases.
- Can anyone correct this code
- SQL help
- DB2 express-c under linux-vserver ?
- Visual Explain after applying Fixpack 15 on v8.1
- unable to apply XML Extender to DB2 database
- Migration from Mysql to db2 express-c
- DB2 instance recovery
- DB2 DCLGEN
- Accessing mainframe DB2 in Java.
- SQL Help