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