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. Set/Override Application Name using Universal Driver
  2. DB2 update from 32bit to 64bit
  3. SQLJ Connection Context and SP interportability
  4. SQLJ Connection Context and SP interportability
  5. DB2 physical data structures
  6. DB2 physical data structures
  7. Unicode in DB2 7.2
  8. Unicode in DB2 7.2
  9. outsourced Db2 practice tests does not work
  10. outsourced Db2 practice tests does not work
  11. MERGE statement documents
  12. MERGE statement documents
  13. Should a very complex SQL statement crash the instance?
  14. Should a very complex SQL statement crash the instance?
  15. ODBC Net driver throw an exception
  16. ODBC Net driver throw an exception
  17. Perl DBI and DB2 Stored Procedure
  18. Perl DBI and DB2 Stored Procedure
  19. SQL1034C creating a stored procedure on 8.1 Fixpak 5
  20. SQL1034C creating a stored procedure on 8.1 Fixpak 5
  21. what is the memory for agent xxx means?
  22. what is the memory for agent xxx means?
  23. is the error related to fixpack 5 from db2 udb v8.1?
  24. is the error related to fixpack 5 from db2 udb v8.1?
  25. Calling an SP from RPG Using SQL CLI
  26. Calling an SP from RPG Using SQL CLI
  27. SQLSTATE=HY010 Function Sequence Error- Java Stored Procedures - DB2 on AIX
  28. SQLSTATE=HY010 Function Sequence Error- Java Stored Procedures - DB2 on AIX
  29. install error on DB2 UDB v8.1 PE
  30. install error on DB2 UDB v8.1 PE
  31. How to remove data from disk
  32. How to remove data from disk
  33. ETL & Data Mapping
  34. ETL & Data Mapping
  35. Can't register DB as data source
  36. Can't register DB as data source
  37. help load data using import utility
  38. help load data using import utility
  39. Regarding - Windows query tool for DB2/400
  40. Regarding - Windows query tool for DB2/400
  41. why lock escalation happened
  42. why lock escalation happened
  43. collect bufferpool data
  44. collect bufferpool data
  45. calculate package cache hit ratio
  46. calculate package cache hit ratio
  47. package cache overflow
  48. package cache overflow
  49. crash recovery
  50. crash recovery
  51. alter table activate not logged initially
  52. alter table activate not logged initially
  53. alter table activate not logged initially
  54. alter table activate not logged initially
  55. DB2 As Clause question
  56. DB2 As Clause question
  57. Upgrading to 7.2 on AIX
  58. Upgrading to 7.2 on AIX
  59. DB2 Procedure Builder
  60. DB2 Procedure Builder
  61. stored proc error - ADO and DB2
  62. stored proc error - ADO and DB2
  63. Store procedure fails with null exception for SELECT querys for tables with columns >10
  64. Store procedure fails with null exception for SELECT querys for tables with columns >10
  65. IBM DB2 8.0 under Red Hat Linux 9.0
  66. IBM DB2 8.0 under Red Hat Linux 9.0
  67. Replication on DB2 v8
  68. Replication on DB2 v8
  69. UniVerse
  70. UniVerse
  71. hekp updating/moving
  72. hekp updating/moving
  73. hekp updating/moving
  74. hekp updating/moving
  75. use of executeBatch with a CallableStatement (SQL stored procedure)
  76. use of executeBatch with a CallableStatement (SQL stored procedure)
  77. cannot load jdbc driver
  78. cannot load jdbc driver
  79. different version of db2jcc.jar failed to do DB2Binder
  80. different version of db2jcc.jar failed to do DB2Binder
  81. DB2 Connect PE 8.1.4 and MS Access Underscore Problem
  82. DB2 Connect PE 8.1.4 and MS Access Underscore Problem
  83. DB2 Datawarehouse Center Metadata into Rose
  84. DB2 Datawarehouse Center Metadata into Rose
  85. DB2 V8 Express Edition install on SUSE Linux 8.2 Prof
  86. DB2 V8 Express Edition install on SUSE Linux 8.2 Prof
  87. Search odbc driver for udb
  88. Search odbc driver for udb
  89. to present digital library
  90. to present digital library
  91. DB2 Admin performance issue resolved.
  92. DB2 Admin performance issue resolved.
  93. Which OS is the best option to install DB2 Universal DataBase Workgroup Server Unlimited Edition?
  94. Which OS is the best option to install DB2 Universal DataBase Workgroup Server Unlimited Edition?
  95. DB2 & TSM: dsmc q backup usage
  96. DB2 & TSM: dsmc q backup usage
  97. Scripts in DB2 Script Center is lost when upgrade V7 to V8
  98. Scripts in DB2 Script Center is lost when upgrade V7 to V8
  99. empty option for delete records
  100. empty option for delete records
  101. db2uext2.exe not work with db2 database
  102. db2uext2.exe not work with db2 database
  103. Error code ZRC=0x8031006D.
  104. Error code ZRC=0x8031006D.
  105. Timestamp-Format with Java Type 4-Driver
  106. Timestamp-Format with Java Type 4-Driver
  107. Mass SMF Type 101 DB2 Accounting records
  108. Mass SMF Type 101 DB2 Accounting records
  109. How to insert a DBCLOB data?
  110. How to insert a DBCLOB data?
  111. SQL Warning: SQL1271W Database is recovered but...
  112. SQL Warning: SQL1271W Database is recovered but...
  113. I cannot compile embedded SQL in C++ programs with RHEL 3 ES.
  114. I cannot compile embedded SQL in C++ programs with RHEL 3 ES.
  115. db2 and PHP access
  116. db2 and PHP access
  117. transaction log is full
  118. transaction log is full
  119. estimate table size not working?
  120. estimate table size not working?
  121. how to change the bufferpool size correctly?
  122. how to change the bufferpool size correctly?
  123. serious memory problem
  124. serious memory problem
  125. sql error 964: transaction log is full
  126. sql error 964: transaction log is full
  127. DB2 SQL error: SQLCODE: -805, SQLSTATE: 51002, SQLERRMC: NULLID.SYSLH203 0X5359534C564C3031
  128. DB2 SQL error: SQLCODE: -805, SQLSTATE: 51002, SQLERRMC: NULLID.SYSLH203 0X5359534C564C3031
  129. Can I flush bufferpools?
  130. Can I flush bufferpools?
  131. DB2 V8 Fix pack 5 on W2K Professional
  132. DB2 V8 Fix pack 5 on W2K Professional
  133. Need to know FENCED ID details for an existing instance.
  134. Need to know FENCED ID details for an existing instance.
  135. How DB2 UDB v7.2 & v81. talk?
  136. How DB2 UDB v7.2 & v81. talk?
  137. URGENT HELP on NICKNAMES
  138. URGENT HELP on NICKNAMES
  139. function of IDENTITY_VAL_LOCAL problem
  140. how to do row number query
  141. function of IDENTITY_VAL_LOCAL problem
  142. how to do row number query
  143. NULLID.SYSLH203 -805 Solaris 8,1FP3
  144. NULLID.SYSLH203 -805 Solaris 8,1FP3
  145. question about versions
  146. question about versions
  147. row level security
  148. row level security
  149. Simple Query - but answer eludes me
  150. Simple Query - but answer eludes me
  151. Cloudscape/DB2J
  152. Cloudscape/DB2J
  153. Offline Temporary Tablespace
  154. Offline Temporary Tablespace
  155. admin: can this disgusting stuff be deleted?
  156. admin: can this disgusting stuff be deleted?
  157. view with where condition
  158. view with where condition
  159. DB2 Connect ODBC and SQL Server DTS
  160. DB2 Connect ODBC and SQL Server DTS
  161. Delphi Admin-API Inerface Unit
  162. Delphi Admin-API Inerface Unit
  163. Objects dependency
  164. Objects dependency
  165. Need sample DB2 script called by AIX script
  166. Need sample DB2 script called by AIX script
  167. Connect not possible
  168. Connect not possible
  169. Cannot delete table data with db2 connect
  170. List the dependency of a object
  171. Cannot delete table data with db2 connect
  172. List the dependency of a object
  173. IT - Database Administrator - S. California
  174. IT - Database Administrator - S. California
  175. fenced routine communications & import
  176. fenced routine communications & import
  177. MS Access Pass Through Query
  178. MS Access Pass Through Query
  179. Table & Tablespace size
  180. Table & Tablespace size
  181. UDB V8 fp 5 to Datajoiner 2.1.2 fp 13
  182. UDB V8 fp 5 to Datajoiner 2.1.2 fp 13
  183. How do I manually set statistics for a VARGRAPHIC column
  184. How do I manually set statistics for a VARGRAPHIC column
  185. memory question
  186. memory question
  187. how do I configure DB2 Connect for the port?
  188. how do I configure DB2 Connect for the port?
  189. JDBC error codes
  190. JDBC error codes
  191. configuration advisor on buffer pool size
  192. configuration advisor on buffer pool size
  193. Getting an error when running table functions - snapshot_tbs
  194. Getting an error when running table functions - snapshot_tbs
  195. DB2 Client compatibility
  196. DB2 Client compatibility
  197. Creating a sequence alias
  198. Creating a sequence alias
  199. How to for dummies
  200. How to for dummies
  201. How to find a tablespace storage size and containers size via system tables
  202. How to find a tablespace storage size and containers size via system tables
  203. SQL10007N Message "99999" could not be retrieved. Reason code:
  204. is it possible to connect to db2/390 without having db2 connect?
  205. SQL10007N Message "99999" could not be retrieved. Reason code:
  206. is it possible to connect to db2/390 without having db2 connect?
  207. DB2Connect EE to connect to DB2 for z/OS
  208. DB2Connect EE to connect to DB2 for z/OS
  209. Upgrade and License questions
  210. Upgrade and License questions
  211. DB2 daily
  212. DB2 daily
  213. Update Original Installation Media?
  214. Update Original Installation Media?
  215. Transfer Java stored procedures from v7.2 to v8.1 problems
  216. Transfer Java stored procedures from v7.2 to v8.1 problems
  217. Strange access plan
  218. Strange access plan
  219. Update Multiple Rows
  220. Update Multiple Rows
  221. CPU, IO, Application times
  222. CPU, IO, Application times
  223. Control Scripts
  224. Control Scripts
  225. Stored procedures using declared temporary tables: please help!
  226. Stored procedures using declared temporary tables: please help!
  227. DB2 Connect, Dynamic SQL, and chosen Isolation Level
  228. DB2 Connect, Dynamic SQL, and chosen Isolation Level
  229. Restoring from one drive to another
  230. Restoring from one drive to another
  231. failed insert because of duplicate rows and still locks held by application
  232. failed insert because of duplicate rows and still locks held by application
  233. Help with query
  234. Help with query
  235. Routine tasks
  236. Routine tasks
  237. Tools Catalog Location
  238. Tools Catalog Location
  239. Defining External (C) UDF example from Application Development Guide
  240. Defining External (C) UDF example from Application Development Guide
  241. tablespace scan, but not table scan
  242. tablespace scan, but not table scan
  243. Problems creating stored procedure
  244. Problems creating stored procedure
  245. ODBC doesn't support stored procedures? This can't be true
  246. ODBC doesn't support stored procedures? This can't be true
  247. Question about optiload
  248. Question about optiload
  249. disconnect command
  250. disconnect command
  251. disconnect command
  252. disconnect command
  253. disconnect command
  254. disconnect command
  255. Long time before connection
  256. Long time before connection
  257. Is there an easy to copy a table: structure and data?
  258. Is there an easy to copy a table: structure and data?
  259. buffer_pool_services sqlbStartPools Probe:2
  260. buffer_pool_services sqlbStartPools Probe:2
  261. How to resolve foreign key change during import?
  262. How to resolve foreign key change during import?
  263. accessing active log files
  264. accessing active log files
  265. Help with trigger - URGENT!
  266. Help with trigger - URGENT!
  267. Table qualifier in DB2 AS/400
  268. Table qualifier in DB2 AS/400
  269. connecting to as/400 database
  270. connecting to as/400 database
  271. DB2 UDB 8.1 SQLJ precompile: attribute error
  272. DB2 UDB 8.1 SQLJ precompile: attribute error
  273. DB2/UDB on iSeries (AS/400 V5R2) - how to run SQL scripts?
  274. DB2/UDB on iSeries (AS/400 V5R2) - how to run SQL scripts?
  275. sql
  276. sql
  277. Restoring a database to a test system, handling schema differences
  278. Restoring a database to a test system, handling schema differences
  279. about SQL0911 reason code 68
  280. about SQL0911 reason code 68
  281. Invalid packages after dropping Prmary key : URGENT
  282. Invalid packages after dropping Prmary key : URGENT
  283. DB2 UDB 8.1 on AIX, How to View CLOB Sample Contents?
  284. getting encoding of a db2 database by java
  285. db2 (udb) 8.1 install on aix5.2 ml 2
  286. DB2 UDB recovery
  287. CPU utilization
  288. Updated lists: XQuery engines, JDBC and ODBC drivers, OLE DB and .NET providers, DB2 extenders
  289. SQL0359N The range of values for the identity column is exhausted.
  290. SuSE "Partner" Program
  291. Returning NULL for column names
  292. JDBC error
  293. Conflict between DB2 WSE V8.1 and DB2 CONNECT V8.1 ?
  294. SELECTIVITY Clause, ( & when will the optimiser have hints) ?
  295. PHP and DB2
  296. DIA7500E Error encountered in the Generator
  297. Index creation
  298. trigger vs. application code performance
  299. SQLExecute running extremely slow
  300. IBM DB2 Content Manager eClient Version 8.2 Install Problem
  301. Problem with DB2 and Windows 2000
  302. Upgrading DB2 in MSCS environment
  303. DB2 Handle Leak?
  304. NetSearchExtender Question ...
  305. README missing in Fixpak 5
  306. Perfomance hint
  307. DB2 8.1 FP 5 Replication Setup - Source to Target Mapping Issues
  308. DB2MOVE - Strange but true
  309. Scriptability for moving stored procedures
  310. Authorization scopes
  311. sqlj.install_jar issues
  312. Dropping procedure - problem
  313. problems using sqlj and db2-8.1 (SET CURRENT PACKAGESET )
  314. Serious Performance Drop on AIX
  315. Length of source Error while compliling a Java stored procedure in SPB
  316. Store Procedure failure
  317. Ant and DB2
  318. Site for practicing UDB
  319. Sequence in DB2 on OS/390
  320. CPU utilization
  321. Script to delete old files based on creation date
  322. Java Stored Procedures (V7.2)
  323. Error Handling in Java Stored Procedures (V7.2)
  324. SQLCODE -28
  325. why it is exclusive lock
  326. My ConnectionEventListener is not called.
  327. My ConnectionEventListener is not called.
  328. Ordinal record number
  329. Accessing an already existing temporary table
  330. SQL 1042c - unexpected system error occurred with rollforward recovery
  331. db2schex.exe
  332. Executing a text file containing SQL
  333. DB2 for VSE access from 2 guest sharing members
  334. DB2 for VSE access from 2 guest sharing members
  335. Table Locks and Preventing Deadlock
  336. Use ADO shape command with DB2?
  337. what are the db2 users db2fenc1 and dasusr1 for ?
  338. The old raw devices chestnut.
  339. SQL0440
  340. Post installation tasks in db2
  341. copy table & rejected rows
  342. Convert Qualify Rank from Teradata to DB2
  343. Jeremy R (JR)
  344. Installation of IBM DB2 Enterprise server edition on Linux
  345. Record selection takes long time
  346. Does DB2 7.1 take more CPU resources than DB2 5.1 under OS/390?
  347. How to avoid duplcate key insertions in a multi-user DB2 environment?
  348. Lost/compromise db2admin password
  349. Generic Connectiity from ORACLE to DB2
  350. Questions about DB2
  351. soft lock problem
  352. db2 replication vs log shipping
  353. Setting MAXAPPLS DB PARAM
  354. Explain plan on DB2 As/400
  355. Calling UDFs from BEFORE UPDATE trigger
  356. DB2MSCS decluster and cluster
  357. db2ptree
  358. SQL4301N RC4 and DB2ROUTINE_DEBUG
  359. Backup Express
  360. Index on Volatile tables
  361. DB2 configure SMTP server
  362. administrative API
  363. SQLDBDIR lost, recovery-scenarios
  364. Where to put the log files running Linux (SLES 8) ?
  365. [JDBC] PreparedStatement and identity column
  366. restore error
  367. suddenly lost my ODBC drivers for DB2... simple way to recover/re-install???
  368. Memory limits for DB2 V8 on LINUX
  369. zos - exec sql - load
  370. db2sysc
  371. Cursor with Hold
  372. Long: DB2 crash because of logging failure
  373. Connection between DB2 personal and DB2 mainframe
  374. register add-ins
  375. IBM Developerworks: Learn how to write DB2 JDBC tools in Jython
  376. partition load
  377. After Backup I loose connection to TOOLSDB
  378. Language Settings for DB2 UDB 8.1
  379. Marrying SQL, XML, web services, grid computing (2 audio programs)
  380. CREATE USER MAPPING Problem
  381. 32 and 64 bit instances
  382. missing P4211708.msg file
  383. DB2 UDB V8 on Linux
  384. identity column not alterable on 390 < v7
  385. Connection Pool Problem w/ DB2 5 - WAS 5
  386. Replication and structured type
  387. What's your compensation for carrying a pager???
  388. Create Alert for Replication Errors
  389. Poor Performance: High Real Time/CPU Time Ratio
  390. Setting limits on size of result sets
  391. Cardinality of 'where col1 like :hostvar' in static SQL
  392. SQLBindFileToParam and SQLBindFileToCol
  393. Please Help! Logfiles lost, but online-backup could be restored
  394. Connect to AS/400 from .NET
  395. for those who cite URL's and googlits as evidence
  396. db2 jdbc driver eclipse - conection error
  397. How to fix Error 332 ?
  398. Different Datetime delimiters gives me different date format
  399. Full logs
  400. db2java.zip
  401. Tablespace page size
  402. DB2 Increasing the pagesize of an SMS tablespace
  403. Cursor performance, FOR or DECLARED
  404. Strange OutOfMemory errors
  405. Server hangs
  406. is this possible? obtain the min and max of rows with discrete intervals?
  407. Servlet connection to DB2 database that is not cataloged
  408. No more handles error with DBD::DB2 on Linux
  409. I get only USA Date format in CLP! What to do to get local format?
  410. My DB2 V8 SP5 WSE crash on Windows 2003
  411. db2admin Windows Account Losing is Administrator Rights
  412. how to create row lock using db2 app driver
  413. Version 8 contains EEE already?
  414. Exporting data to DEL format
  415. Function(UDF) Problem
  416. Difference between Unix UDB DB2 v8 and z/OS DB2 v7
  417. RAID5 striping
  418. CLI0111E Numeric value out of range. SQLSTATE=22003
  419. Exporting LOB data to multipla files
  420. OS390 - char and varchar
  421. SQL Functions & the Package cache...
  422. 7.2 to 8.1 DB2 migration problems
  423. Set Schema
  424. Prefetching only with >1 container??
  425. Platinum FASTLOAD on OS/390 error...
  426. CLOB length
  427. One small problem, NOT LOGGED INITIALLY
  428. day of week from DATE function?
  429. error found after db2dart
  430. Query No
  431. CPU Util on a Stored Proc
  432. ODBC Memory Leak
  433. Question on SORTHEAP and SHEAPTHRESH and SQL0955
  434. Does DB2 Workgroup Server Edition V8 support Microsoft Cluster?
  435. DB2 UDB equivalents to Informix "Forms" and "Ace"
  436. capture doesn't work properly
  437. DB2 UDB V8 inplace reorg
  438. How to find Log File usage ?
  439. Setting SQLDA variables
  440. decoded values for InstanceType=X
  441. Any good document about DB2 UDB Multi Partition Environment
  442. DB2 Connect Character Conversion Issue
  443. Ques on DB2 Administrative API
  444. Temp space
  445. Owner and Startfiles
  446. Temp space
  447. Short Character Strings using DB2 and Visual Basic
  448. Creating Global Temp Table in UDB DB2 v8
  449. name limits on 390
  450. How to use SQLBindParameter for double or float datatype
  451. db2gov: limiting access to DB2
  452. setting optimizing class on iseries
  453. Force all users to disconnect before backup
  454. What is these messages in the db2diag.log ?
  455. March 15: Rick Cattell, Peter Coffee, Dana Florescu, Jim Gray, Jim Kleewein, Jim Melton discuss XML, services and grid
  456. Suddenly _ZdlPv rellocation error from Base Client Support
  457. Setting queryopt on a per stored proc basis
  458. OneClickRevelation: JDX Provides Instant and Interactive Insight Into Your Data
  459. Setting date format on EXPORT / conversion of date to timestamp
  460. Visual studio 2003
  461. lob, odbc, java and speed
  462. Setting the prefetch size.
  463. Sample script for backups using DB2 v8 on Windows and TSM
  464. Details
  465. Sample script for backups using DB2 v8 on Windows and TSM
  466. recovery on-line backups a question on logs
  467. Db2 Everyplace uni-directional synchronization
  468. Host Variables and Table names = Dynamic SQL ?
  469. Socket Error in DB2
  470. Best Book Explaining Tuning UDB
  471. jdbc problem
  472. Host Variables
  473. LIST ACTIVE DATABASES
  474. "SQL Getting Started" for DB2 8.1.x?
  475. granting db2expln for the public?
  476. Fixpack 5 ADC for Windows changes the decimal separator of decimalcolumns from a dot into a comma
  477. Cannot install Windows Application Development Client Fixpack 5 onWindows XP Professional
  478. DB2 on AS400: Manipulate journaling via JDBC?
  479. Documentation help SQL procedures DB2 v8 linux
  480. How do I know how many times a particular statement was executed UDB V8 on Aix 5
  481. Help : Complex SQL query
  482. interpertting a db2expln
  483. Creating a DB2 7 FP 11 Installation CD
  484. Usage of DB2WWW
  485. Gateway Connections in Control Center DB2 V8
  486. Relational Connect
  487. active logs
  488. How to apply fixpak and patch on DB2 UDB?
  489. caution using restore DB2 database from v7 to v8
  490. DB2 8.1 db2cc DB2JAVIT : RC = 11 Error // SuSE 9.0 Kernel 2.4.25
  491. Nicknames are pointing to what tables????
  492. log files linux
  493. Update without requiring a commit
  494. Scrollable ResultSet
  495. Version 8, FixPak 5 is now available
  496. PC -> Db2 Connectivity Question
  497. ORA8.TO_CHAR function in DB2
  498. private sort VS shared sort
  499. Is nonlinear recursion allowed? Does it leverage index?
  500. EVI in DB2 UDB 8?
  501. create tools catalog failure
  502. DB2 - Unicode Questions
  503. DCLGEN on a PC
  504. Minimum Recovery time on tablespace
  505. Help with DB2 V7.1 Client Installation
  506. transaction logs mirroring
  507. r e: question on embedding literals in load statements
  508. Calling stored procedure from CLP
  509. stress db2 database tool
  510. Restore to new database
  511. Problem registering Stored Procedure
  512. Security in a Web-based application
  513. Increase DB2 catalog space on OS/390
  514. Increase size of DB2 z/OS catalog
  515. Skip scans in DB2
  516. ISeries DB2 UDFs and Stored Procedure
  517. asynchronous open
  518. Get last used date of a view.
  519. Test for numeric value in a varchar field
  520. EMC's Time Finder for DB backup
  521. PEAR DB 1.6.0 has been released
  522. health monitor - partitioned databases
  523. Update more then 600 records - db2 7.2 on Win 2000, programing MS VB6.0
  524. Omegamon for OS/390 help
  525. db2look and dependencies?
  526. db2look and dependencies?
  527. sqldbdir
  528. db2 move not working with administration client
  529. [DB2] No SQL-Delete possible. Need help! Getting sick!
  530. getting started with spatial extender
  531. db2 backup, StorageManager
  532. DB2 UDB v8 on Aix 5.2. Calculating how long to restore?
  533. SQL0804N on db2 connect v8.1
  534. Experience with DB2 II
  535. Memory Sharing between Databases
  536. Problem with DB2 XML Extender and JDBC on AS/400
  537. Error enable database for use with xml extender
  538. LDAP cataloged database
  539. LDAP cataloged database
  540. Query a table?
  541. What's the Difference 8.1, 8.1.2, SBCS, etc ?
  542. dxxadm fatel error --- libicudt20b.so
  543. Database connection
  544. Precision errors when aggregating data
  545. Using a SQL Table function in a view ...
  546. SET Integrity Exception Table - How to use
  547. about recovery
  548. Snapshot monitor, SQL statement question
  549. Oracle statspack Vs DB2 ???
  550. qmail SMTP server rejecting DB2 email notifications