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