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