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

  1. Re: heavy inserts and bufferpool
  2. Repost (sort of) of an old problem
  3. store procedure to transpose rows to columns
  4. Re: heavy inserts and bufferpool
  5. DB2V9.1 pureXML Creating Unique index with 2 attributes
  6. app driver and ERRMC delimiter
  7. Re: heavy inserts and bufferpool
  8. DB2 on z/OS Mainframe
  9. Can I set up bidirectional Q-replication with both sender andreceiver server having HADR environment
  10. moving a C++ written application from db2 v8 to db2 v9..............
  11. converting from time in seconds to timestamp format
  12. Question on restoring databases taken across timezones
  13. systoolstmpspace : %%When is this tablespace used %%
  14. Partitioned table and its indexes
  15. catalog node and DNS lookup
  16. V9.1 Insert Trigger to extract attribute from the XML document beinginserted.
  17. how to archive lots of records
  18. How to change schema of table in DB2 v.8.2 without coping data
  19. Curiousity about how other people do it.
  20. Re: Partitioning Key
  21. Contribution: quick monitoring script
  22. MQTs under z/OS - how to get IMMEDIATE REFRESH functionality
  23. WLM and DB2 9.5
  24. Admin client for Linux Red Hat Linux AS/EX 3.0/x86
  25. CLOB tablespace locking
  26. XSD data into DB
  27. IMS to DB2 migration
  28. name spaces in db2 Xquery
  29. Convert character to date
  30. How can I change n-rows --> 1-row ? Getting constraint information.
  31. Reading DB2 Transaction Log files on Windows XP using DB2 API
  32. How to execute DB2 C sample file (dblognoconn) on Windows XP
  33. Need Help: Error while creating Store Procedure
  34. DB2 instance update problem
  35. Dynamic SQL in DB2 procedure
  36. Stored Procedure not working on DB2 8.1.14 on Windows XP
  37. Multiple db2diag.log files
  38. db2 restoration problem
  39. compare dates in yymm format
  40. Executing a DB2 stored procedure in Unix Environment.
  41. Creating a new Database
  42. Scheduling
  43. Performance Goals for DBAs
  44. order query on set function
  45. Problems in restoreing the database
  46. DB2/DATSTAGE issues
  47. DB2 Administration Server & DBA8001E & SQL22205C
  48. How to convert character to date in DB2
  49. DB2 equivalent for ORACLE SQL*Plus BREAK???
  50. Instead of Trigger
  51. escaping strings
  52. Variable as column or table name
  53. overhead in creating a new table
  54. Adding varchar of 32k
  55. changing the Isolation level
  56. readonly tablespace
  57. DB2 Stored Procedure
  58. EXPORT, Change the CLOB and then IMPORT
  59. CHAR to DATE conversion
  60. how to check for when a db2stop command is last issued
  61. dropped table recovery /tablespace restore
  62. What is XML extender???????
  63. define another default instance
  64. deleting simillar rows
  65. Raw Device
  66. SQLDA problem - data type doesnt match
  67. How to Insert an XML document in DB2??
  68. DB2 UDF create temporary table
  69. NEED HELP: How to convert Joe Celko SQL IN DB2 without Stored Procedure
  70. Java + DB2, import table data
  71. to ACCESS-DB from zOS/DB2
  72. Can MQTs use views as underlying objects?
  73. put 2 lines into 1 column
  74. deadlock
  75. rollforward recovery & rollforward pending state
  76. prob linking C with db2
  77. Sum result format is float(?)
  78. Looking for listing of MQT reason codes...
  79. How to get substring of numeric value
  80. Backup Pending State
  81. Load Pending State
  82. convert decimal to display 0.00 as '######.##'
  83. increase the size of UNIX window to see the entire output of a selectdb2 query
  84. DB2, Java, and multi-row inserts
  85. DROP system stored procedure restriction
  86. formatting the decimal value 0.00 to 0,000.00
  87. How to check "bad page" efficiently?
  88. Is there anything else to gather database size info?
  89. DB2 Express-C Global Temporary Table Performance on vista
  90. Refreshed Cross Platform SQL Reference Manual (9z, 9LUW, 5.4i)
  91. WPLAN: Set is skipped. errcode is 5E1603
  92. Tracing agent execution and activity
  93. Difference in default constraint syntax between LUW and z/OS?
  94. help for db2
  95. REORG Recommendation on HADR
  96. REORG Recommendation on HADR
  97. REORG Recommendation on HADR
  98. Wisconsin Benchmark DDL and SQL for DB2
  99. Need Help with query
  100. How to export/import DB2 database
  101. db2fmp...what is it running?
  102. Subquery Problem
  103. z/OS stored procedure doesn't return value
  104. How to use sequence in FUNCTION?
  105. How to access DB2 database using Microsoft access(SQL passthrough)
  106. Count the number of select on a particular table
  107. Need to setup a federation b/w 2 databases. Please help.
  108. sql confused
  109. Save results of a stored proc into a temp table
  110. Wrong Date DATE(CURRENT DATE - 1 DAY) DB2 Z/OS
  111. Drop / Rename a Column
  112. DB SQLSTATE check returns wrong value
  113. Table joins across databases
  114. Question: RI from one field in one child to two different parents.
  115. Cataloging database on unsupported platform
  116. SQL-question
  117. Restore DB2 9.1 backup problem
  118. Indexes on nicknames not in catalo
  119. Problem In DB2 First Step / Migration V8 to V9
  120. OSERR : 5 "Access is denied."
  121. I know OTLT is the Evil Undead, but I need that stake...
  122. Spufi Audible Tone
  123. DB2UDB V9.5 net search extender silent install on windows
  124. z/OS DB2 SPUFI called procedure
  125. difference in date transposed as total number of rows
  126. How can I query?
  127. db2 script needed to count and delete the data
  128. Questions to FAILARCHPATH and HADR
  129. v8.1(fp14) GET_DBSIZE_INFO SQL1131N
  130. import into db2 fails
  131. error when installing db2 9.5 in cent OS 5
  132. Convert MS Access to DB2
  133. find default tablespace
  134. SQL Error causing CPF5257 DB2/400
  135. current timestamp shows wrong time
  136. view optimization.
  137. Calculate the maximum total memory ever used by the instance
  138. Querying schema/description
  139. Creating an Audit Query
  140. Problem of UNION ALL view & Update of master table row in Paralel Execution
  141. List Queries executed on a database
  142. ORDER BY and FOR UPDATE
  143. Can't connect to database, missing log files
  144. loading alternative records into a table
  145. SMS tablespace limits
  146. How to get rid of an uncataloged node??
  147. Reg DB2 700
  148. Need DB2 701 Sample papers
  149. about create index online
  150. Problem with db2advis
  151. db2 load problem
  152. Users on dabatase
  153. Help with cataloging databases.
  154. Can anyone correct this code
  155. SQL help
  156. DB2 express-c under linux-vserver ?
  157. Visual Explain after applying Fixpack 15 on v8.1
  158. unable to apply XML Extender to DB2 database
  159. Migration from Mysql to db2 express-c
  160. DB2 instance recovery
  161. DB2 DCLGEN
  162. Accessing mainframe DB2 in Java.
  163. SQL Help
  164. Please help. How to create Detail table using Summary
  165. composite keys and delete performance
  166. Unable to consume Web Service from DB2: DB2XML.SOAPHTTPV error in "\db2soapudf"
  167. cursor with hold
  168. containers info
  169. Database Partitioning Feature( DPF for EEE) concepts
  170. clarity on UTIL_IMPACT_LIM and UTIL_IMPACT_PRIORITY
  171. DB2 UDB Recovery after Total Media Failure or Server Loss due to Extreme Disaster
  172. How to translate string with data have integer + character and null data
  173. Windows Admin Rights for IBM DB2 Client?
  174. Exit/Continue handler for any errors
  175. connections to a node
  176. CLI0111E Numeric value out of range. SQLSTATE=22003
  177. ibm db2 000-700 dump
  178. table changes since last runstats?
  179. Environmental Variables
  180. DB2 equivalent for Oracle's PMON?
  181. DB2 equivalent for Oracle's PMON??
  182. timestamp subtraction
  183. SQL10007N 99999 on z/OS stored proc call
  184. SQL from Java - PREPARE (with parameter markers) vs. Dynamic
  185. Schema Read privilage
  186. db2 java application of 32-bit and 64-bit DB2 insatnce
  187. delete rows from two tables using one sql statement
  188. move a tablespace (sms containers) to different location
  189. ROWNUM functionality DB2 Ver 5
  190. hex function doesn't return what I expect
  191. db gets deadlocked while trying to delete records
  192. MS Access vs Shareware SQL query software
  193. howDB2 has a lot files under /proc on aix
  194. Regarding fee structure of DB2 certification
  195. Backup online error
  196. 64 bit SO + 32 bit Media + Db2 V8
  197. Find Active Queries in real-time
  198. Syntax Error-Help!!
  199. DB2 Health Monitor v9 fixpack 4 still can be a BIG PROBLEM
  200. how to stop all database manager processes even after db2stop
  201. DB2 8.2 on AIX 6
  202. db2 print message within procedure
  203. modify query to use ndexspace
  204. db2 performance issue (cli and db2batch)
  205. DB2 Bulk Load
  206. Federated access to Excel from DB2 9.1.1 on Linux
  207. SQLSTATE=42724 on z/OS stored procedure call
  208. Inline UDF returning a computed string
  209. Need help with Stored Procedure
  210. UDB JDBC procedure call causes S04E in DB2
  211. SQl Syntax Check
  212. computer trade shows
  213. HWM on Reorg Questioned
  214. Large Table Index Rebuild Problem
  215. Transport database to another system
  216. DB2 z/OS Unload question
  217. Recursive query - Help needed...
  218. select * view and alter table
  219. Backup-Restore problem
  220. how to adjust the column width for a result set?
  221. Global temporary Table
  222. datastage
  223. db2 error ( Agent not allocated, sqlcode = -1225 )
  224. Insert to table question
  225. Limits to statement size in ISERIES
  226. Similar LPAD function in DB2
  227. how to handle utf-8 char in db2 export
  228. trigger exceptions
  229. DB2 on z/OS
  230. Are you face any problem with processor....no problem study the fulldetails here...
  231. how to set priority
  232. moving objects from db2 on windows to linux
  233. Error Occurred in SQL Call Level Interface CPYTOIMPF
  234. variable for table name in stored procedure
  235. which Unix UDB Version 8 fixpack level equals 9 , 9.1 & 9.5
  236. how to convert bytes[] to blob
  237. Remote database
  238. Don't want to rollforward
  239. MESSAGE : Unable to find donor to satisfy minSize constraint
  240. Question on DB2 LUW auto-reorg
  241. DB2 and Windows Server 2008
  242. Inline UDF returning a computed string
  243. Is there a way to remove / clear / drop statistics for a singletable?
  244. New to db2
  245. Linking error
  246. SQL0803N duplicates and problems inserting
  247. winsql CASE statement
  248. restrict privileges
  249. disconnect all
  250. Transaction labeling
  251. Library of V5R2M0 iseries access for windows
  252. LOAD question
  253. Views & performance
  254. information on databases
  255. help for operation with date
  256. need help with UDF
  257. Execute Immediate in UDF
  258. Encryption algorithm & key length in DB2 UDB v8 & v9
  259. DB2 ALTER date
  260. encryption & unicode
  261. Problem with LIKE in cursor
  262. DB2 AWE configuration Error.
  263. JDBC driver fro DB2?
  264. Why DB2 developers could not make it possible to change statementtermination character dynamically?
  265. Insert into .. (select count(*),sum(xx
  266. Problem in creating stored procedure in db2
  267. ibm_db2 php module
  268. Does DB2 8.2 client support DB2 9.5 Server
  269. JDBC DB2 and CLOB
  270. Procedure variable scope?
  271. intra_parallel throttling
  272. db2look not showing not null characterstics for columns in hierarchy tables definitio
  273. DB2 Load (Replace vs Insert)
  274. SQL to determine RI constraints hierarchy
  275. Error while accessing User-defined function ( SQL0444N and SQLSTATE=42724 )
  276. SQL1139N The total size of the table space is too big.
  277. SQL1220N after Installation 9.5
  278. Can DB2 V8.2.9 address more memory when /3G flag is enabled on32-bit Windows?
  279. DB2 9.5 global variables
  280. Updating day portion od date field
  281. How to use the SET TERMINATOR directive to change the delimiter to newline?
  282. .NET assembly dll for connecting to DB2
  283. Please read me first
  284. how to get into..?
  285. DB2 does a tablescan even with an index present
  286. DB2 Stored Procedure Select
  287. White paper or source for Materialized tables?
  288. Restrict on drop and table is inaccessible
  289. Need Help with setting up a new db2 database v9 wse!!
  290. Excessive z-lock time with LOAD command?
  291. Table Create Question
  292. DB2 9.1 and 8.2 co-existence on UNIX
  293. AS/400 DB2 SQL optimizer issue?
  294. Function for adding 1 to a hex column
  295. db2pgixt.exe
  296. SQL Capture/Replay tool for db2 luw
  297. Execute immediate error
  298. Replicating data between IBM DB2 on OS/390 and MS SQL SERVER
  299. db2pd API
  300. QUESTION: Does db2 8.2 for z/OS support ALLOW REVERSE SCAN onindexes?
  301. DB2 HADR and ACR problem V9.5 on Redhat
  302. Problems with Import of UTF-8 files - Differences between LOAD andIMPORT
  303. Issue Reagrding Structure type array variable in SQC code.
  304. How to seed or increment NEWID() value
  305. Select the data with '
  306. Relational data base
  307. regarding BACKUP/RESTORE
  308. DB2 migration
  309. timstampadd function
  310. Making db2 use syslog
  311. Generating and running SQL on the fly
  312. QUESTION: Select <PK> from <TABLE> - index scan or table scan??
  313. getting sql0818n on db2advis
  314. need advise to create web based database directory
  315. Set integrity after load
  316. Deleting a Global Temporary table datas
  317. Enable encryption of Server authentication
  318. Informix SDS Functionality in UDB?
  319. AMD 2 Opteron servers, which Linux OS - CentOS or OpenSuse
  320. Db2 in cobol
  321. Columns Affected by UPDATE STATEMENT
  322. Division error on float data type in DB2
  323. ADM6017E error, but no obvious limit reached
  324. Db2
  325. Transaction Log full
  326. DB2CC - is it available for Apple Mac OSX
  327. ERROR:SQL1220N
  328. backup & filesystem snapshot question
  329. DB2 Store Procedure Using Fetch Cursor
  330. Doubts about the "For Read Only" clause
  331. DB2 Database Administrator Certification Path for v9
  332. Convert timestamp to yyyy-mm-dd format
  333. Changes with DB2 version 9 and automatic tablespaces / restore / listutilities
  334. capturing the result from Execute Immediate
  335. Wartning! Ubuntu- Users: db2exc updater currently broken!
  336. DB2 Execute Immediate
  337. how to maintain the cursor open in a procedure?
  338. Large Objects and Java
  339. Help with understanding : select stmt from sysibm.syspackstmt
  340. NFS / file system requirements for DB2 v9.1 on O.S. as RHEL (Very Very urgent)
  341. How do you display the Current SQLSTATE or SQLCODE
  342. Flush package cache for one sql
  343. db2 backup image file is having strange changes of sizes
  344. Using Group By with a scalar function or to find shorter way of coding this query
  345. MQT and too small transaction log size
  346. Export 50,00,000 records from a table into CSV file
  347. Insert from table in DB A to table in DB B
  348. SQL function for HEX input
  349. What's hash partitioning syntax on DB2 UDB v 9.1?
  350. Help needed writing an SQL statement with parsing
  351. Question on DPF implementation
  352. Mainframe software pricing, DB2, RACF, security/audit
  353. DB2 RECOVER Utility in Mainframe - Urgent
  354. i5 515 and console problem
  355. I don't understand what SQL20148N error is telling me. Can someone explain?
  356. How to get Databases Name in DB2
  357. DB2V9.1 UDFScalar error during build. Any tool to convert T-SQL to DB2 SQL?
  358. DB2 via IBM JDBC problem
  359. DB2 JDBC driver problem
  360. problem in result may be because GTT with threading in java
  361. db2 restore database TSM
  362. Database Crash : Need some urgent help
  363. Using SYSPROC.ADMIN_CMD to terminate load
  364. Sorting issues
  365. declare global temp table and package cache conciderations
  366. Linux DB2 Client Hangs when Connecting to Remote Host
  367. db2 prep and exec sql include
  368. Running concurrent reorg / runstats on DB2 ESE for Aix V8.2
  369. How to create Oracle dblink to DB2 ?
  370. IMS to DB2 Migrations
  371. Fluctuating size of db2 backup, also db2 backup dates have problems
  372. multirow fetch with embedded SQL
  373. "list history" command - How to remove entries?
  374. A question about setting logsecond to -1
  375. SQL limits
  376. Table size in bytes
  377. db2look throws 1427N
  378. Query using a different index than expected
  379. Help with db2Load API (COPY= YES USE TSM)
  380. How To Call Procdure From Function In DB2
  381. Looking for syntax help with ALTER TABLESPACE
  382. DB2 DATA TYPE BLOB INTO VARCHAR
  383. sysproc.snapshot_tbreorg
  384. I am getting this error
  385. Rollback
  386. How can I upload a BLOB/CLOB into a DB2 UDB Column?
  387. Getting started with
  388. Control Center - how to add a system...
  389. CLOB data is getting truncated on SELECT
  390. Proble with DB2 load with column declared as Generated always
  391. code set& territory
  392. Need help in REPLACE function in DB2
  393. Help ... Rollback Transaction
  394. Exception Handling
  395. HOW TO COMMENT OUT BLOCKS OF CODE IN IBM DB2 Control Center console
  396. Anyone with example of DB2 UDB UDF calling Java/C++ routine for Double Metaphone Keys
  397. Timestamps in a Windows Environment
  398. db2 stored procedure not returning value with select into
  399. How can I export the data with del but don't wanna put "" ouside the character data?
  400. How to identify installed DB2 version?
  401. problem with SQL replication with SQL1476 with slqcode "-430"
  402. timestamp issue
  403. Anyone have good experience leaving the HEALTH_MON on ?
  404. Trying to View DB/2 File on NT from AS/400 with SQL
  405. DB2 Query !!
  406. Do you need to recompile user exit
  407. Export DB2 file with correct date
  408. Using sum in nested select
  409. Connection Concentrator Counting of Agents
  410. I need a lot of help with a DB2 query
  411. retrieving stored procedure result sets with embedded SQL
  412. DB2 temporary BP override
  413. Specifying the Isolation Level as UR for all Select Queries Only
  414. Can we use temporary tablespace with reorg indexes all in V8 FP12?
  415. Question on get db cfg
  416. Generating the Insert Scripts for Table in DB2
  417. DB2 certification
  418. Rowset string concatenation
  419. what is this error ?
  420. db2 to oracle migration
  421. Zombie database
  422. DB2 Data Replication Issue
  423. Db2 administrators
  424. On File/aid DB2, refrential integrety
  425. DB2 metadata expoitation
  426. Question About Merge
  427. Regarding DB2 Developers
  428. importing data with date format
  429. DB2 8 - Collect statistics
  430. TRANSLATE function
  431. oracle to db2 export
  432. How to track the execution of procedures in the database
  433. MS ACCESS to Query Data on an IBM iSeries DB2
  434. Regarding SQL Replication
  435. What are the best options to Copy data from one database to a different database with
  436. Cursors, Host Variables in Stored Procedure
  437. create stored proc
  438. Decompressing a compressed backup image
  439. TSM Backup Images
  440. Cannot load program db2licm
  441. DB2 Linux db connect issue
  442. -922 in COBOL CICS DB2 program
  443. choosing a server codeset
  444. Editing DB2-Tables with QMF table editor
  445. count distinct subquery
  446. count distinct subquery
  447. Disable Automatic Storage
  448. Any function can find out the similar numeric string?
  449. DB2 Modified by Clause Problems
  450. Copy DB2 Sequence number from Production to Test
  451. SQL2038N A database system error "-1062" occurred during processing
  452. db2 Subsystem Sharing
  453. Automatic Runstats
  454. AIX DB2 Version
  455. double rounding in gui tools
  456. Vertical data to Horizontal data
  457. Reorg index not using tempspace?
  458. Good ETL tool for MySQL->DB2
  459. Product / license for z/OS Universal Driver on clients
  460. Isolation Level on DB2 UDB 9.1.1
  461. Stupid delete logical question
  462. which sql is better on perfomance in DB2 and how conditional where clause works?
  463. Question Marks in Event Monitor
  464. Can I alter (increase) a column size with the data type as blob
  465. load text files to DB2 dbase
  466. load data with admin_cmd()
  467. Deleting LOB values taking very long time !!
  468. Just installed DB/2 9.1 on AIX, no db2cc?
  469. price of db2 certification?
  470. Force isolation level for a user
  471. Help with returning output of FOR loop in a DB2 function
  472. UNLOAD utilitiy on DB2V8 for ZOS
  473. DB2XML.SOAPHTTV - Could not allocate memory.
  474. Help with stored procedure
  475. DB2 Nicknames and Indexes
  476. how to diable table in Db2
  477. Update across 2 tables
  478. db2_evaluncommitted , db2_skipinserted and db2_skipdeleted
  479. db2fmp EACCES errors in 9.5 while trying to access tablespacecontainers
  480. SQL/XML nested child problem
  481. Problem with DB2 connectivity using Java
  482. Can i find process id in UNIX/AIX corresponding to a particular AgentId
  483. Batch Spufi - Db2
  484. Array data type in Triggers
  485. INTERNALP_LOCK, INTERNALC_LOCK, INTERNALV_LOCK on queryingSYSIBMADM.SNAPLOCK
  486. Any body could help me out on DB2 stored procedure on Z/OS
  487. Experiences with database extensibility
  488. Using Array content in IN expression
  489. DB2 8.x in Z/OS - rownumber() over not working
  490. Question on Replication
  491. DB2 RExx example
  492. External Stored Procedures Limitations?
  493. Dropped Tablespace
  494. Dyanamic Sequence name in User defined SQL function
  495. How to get only dupliacate rows from the table through COBOL-DB2 program?
  496. problem with MQT
  497. Export DB2
  498. The column name as com.ibm.db2.jcc.b.dc@1d5b3a
  499. Try this site
  500. Nees sample Questions for Exam 701
  501. Trigger Updating another table gives SQL0206N
  502. db2 instances
  503. views going invalid
  504. Import data question
  505. can't create nicknames for tables with distinct type
  506. manual performance monitoring query
  507. common table expressions
  508. Two-phase commit with Federated Database (AIX UDB 8.3)
  509. db2fmp high cpu ( DB2 8 + FP 12 )
  510. DB2DIAG Error :DIA8305C Memory allocation failure occurred.
  511. MSSQL2K > DB2Connect > mainframe
  512. MSSQL2K > DB2Connect > mainframe
  513. DB2 V8 32-bits and 64-bits instance
  514. Format of a string
  515. DB2 UDF...need to eliminate IF statement
  516. Tab delimited file with comma seperated column headings.
  517. Replication with Federated DB2UDB Tables
  518. db2 load content from text file
  519. DB2 connect with vse
  520. M'I`5,Persec ution , wh y the s ecurity se rvices?
  521. SMS or DMS
  522. Use of port 523 from Control Center
  523. Thoughts about SMS tablespaces
  524. Reset Sequence Procedure to max value of table.column_name
  525. difference in number of records for select count(*) and select *
  526. Equivalent DB2 Datataypes comapred to PostgreSQL
  527. Out of private memory heap
  528. SQL0469 on DB2 stored procedure CALL
  529. Redirected Restore using Veritas NetBackup
  530. writing the text output to a external flat file from a db2 stored procedure
  531. How to insert csv file into clob column
  532. Transaction Ended- application agentid 0
  533. Question on NORETRIEVE option in ROLLFOWARD
  534. IBM DB2 ODBC Driver
  535. Executing multiple db2 scripts
  536. index fragmentation and explain
  537. Sql1035n
  538. The -s option of the db2icrt command
  539. Re-certification for new DB2 Versions
  540. How to Terminate a Load Utility
  541. Date formatting for DB2 load utility
  542. How to pass a value between DB2 SQL scripts in KSH?
  543. Error in db2diag
  544. DATE being returned as math problem
  545. Number of applications only growing
  546. isdigit ?
  547. How to connect to db2 server in Sybase Power Designer?
  548. Problems reading crypted string in DB2 8.2 via JDBC
  549. DB2 Connect 7.1 under Windows
  550. regarding restore