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