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. UNION to implement default values
  2. DB2LOOK & Tablespace Containers
  3. DB2 V8.1.4 and backup compression
  4. SQL0902C with Kernel 2.4.23
  5. Strange authentication, when account is disabled
  6. Unable to have a key for trial version
  7. DB2, LINUX & WWW
  8. What is UOW Waiting in DB2 LIST APPLICATIONS?
  9. about incremental backup
  10. stored proc lenght limitaion
  11. 2ibmteam: SQL stored procedures call in statement monitor
  12. Strange suggestion in Health Center
  13. Hyperthreading / Linux / DB2 V8.1 FP4 - performance
  14. UDF for z/OS v7 Select value from a table
  15. Archive log
  16. UPDATE statement and unique constraints.
  17. DB2 and dbUnit
  18. storing DMS on RAID
  19. ADO and DB2 8.1 performance tuning
  20. trap in snapshot table fonction V8 FP4
  21. DBD::DB2 Bug - negative REAL causes Numeric value out of range
  22. Converting Informix SP to DB2
  23. new to DB2 and CLI0621E Unsupported JDBC server configuration.
  24. DB2Connect - SQL8002N Error
  25. db2ii_8 + WebSphereStudio_5 problem...
  26. UDB Log
  27. Using CachedRowSet Selecting a BLOB Column
  28. data migration from SQL server to DB2
  29. Sql DB2
  30. Can lock timeouts be logged to a file in DB2 V8?
  31. DB2 backup error
  32. dangling message queues
  33. VIEW based on Stored Procedure
  34. is it normal that capture can t read archived log ?
  35. SQLCODE -497 -how to resolve?
  36. Bad performance with like in cursor
  37. DB2_SCATTERED_IO vs DB2BPVARS (v8 fp4)
  38. DB2 Commit vs. autocommit performance problems
  39. problem with db2
  40. Export LOB's in different files
  41. Unique constraint or index as in Oracle and "alter table alter column"
  42. Delays in between UDF invocations
  43. DB2 7.2 EE and Redhat 9 Question
  44. Enable DIO option in DB2 V8 FP4 For AIX
  45. How get info about table use by application?
  46. DB2 V8.1 FP4 JDBC-Performance-Issue
  47. DB2 CHECK for names?
  48. Ist es normal das es mit der Version 8.1 Performance Probleme gibt?
  49. Gibt es eine DB2 Funktion/Abfrage oder View um die User/User Group abzufragen?
  50. Nach Installation der DB2 Version von 8.1 werden Datentypen nicht meht angezeigt.
  51. db2jstrt: 0403-006 Execute permission denied.
  52. db2jstrt: 0403-006 Execute permission denied.
  53. SQL1088W - V7 to V8 database migration failure.
  54. Current date - n days
  55. unexplained performance drop
  56. Select @@ identity ???
  57. Siebel query question..help
  58. Mail di prova
  59. Why would tweaking SORTHEAP, SHEAPTHRES, and bufferpool sizes disables prefetch?
  60. SQL help with clearing out old plans and packages
  61. cannot create DAS, already present
  62. Federated database
  63. DB SAMPLE
  64. Index usage on db2 v7 for os390
  65. move DB with LOB's from NT4, DB2 V7.2FP3 to AIX5, DB2 V8.1 FP3
  66. BLOB fields trouble
  67. Database marked bad. One more time.
  68. Tempspace full at MQT refresh in DB2 V8 for Solaris
  69. Connection Logging
  70. Is there a v8 equiv of v7 db2_kill??
  71. Do I still need a C compiler on production server?
  72. Change SP query optimization level
  73. NFS-Home and runtimeclient
  74. SQL Error Code -443, SQL State 38553 - what does this error mean?
  75. Finding Last Backup Timestamp
  76. db2 reset monitor question
  77. Migrating from SQL Server
  78. db2dart - should db be activated or not?
  79. Building Java SP for debug
  80. GET DIAGNOSTICS statement....
  81. creating triggers in db2
  82. No "POSSTR" after migrate of V7 DB to V8
  83. UK DB2 UDB Users Group (LUW and z/OS)
  84. Portland, OR DB2 user's group
  85. db2relocatedb error
  86. Cannot find ibmdadb2.h file
  87. Problem installing NSE on Linux.
  88. UDB's scheduler keeps going to sleep resulting in automation not running.
  89. poor select performance
  90. identifying which logs to ship to stand-by server
  91. db2start error on 2-node cluster
  92. Possible Export bug ? (May be IY44569 ? )
  93. DB2 Connect EE, just the drivers?
  94. Adding a parameter to a Java SP
  95. UDB session and db2flsn
  96. Can't connect to db
  97. Event monitor creation in Control Center
  98. SQL1086C An operating system error "" occurred on databasemetadata.getcolumns()
  99. DB2 grant permission steps
  100. Migrating from 5.1 to 8.1: Locking problems (isolation level ?)
  101. MSProject -> ODBC -> DB2
  102. Dot Net OleDB data provider ....
  103. Query Number of VSAM Datsets of a nonpartitioned Tablespace
  104. SQL question: how to select multiple row into one row
  105. how to create a default tablespace
  106. "Database Home" and "Instance Home" (the difference)
  107. Recovery on UDB
  108. problem with UDF
  109. running db2jstrt and jdbc type 3
  110. installing a java sytored procedure from windoze development centre
  111. Bitwise functions available
  112. DB2 CLOB datatype
  113. Export/Import functionality
  114. check-constraint
  115. Data transfer
  116. Declared Temporary Table in Cobol
  117. Temporal functionality in DB2?
  118. db2 table editor?
  119. SQL1131N DARI (Stored Procedure)
  120. Accessing DB schema ...
  121. db2ckbkp
  122. db2set problem - DBI1360N
  123. Execution failed due to a distribution protocol error that caused deallocation of the conversation
  124. wrong node names
  125. how to specify timeout for CLI SQLConnect?
  126. INSERT from existing records of the same table
  127. How to get rid of dummy entry from System Database Directory
  128. Granting User-id's with special characters on a UDB database.......
  129. DB2 7.2 restore generating system error 1326
  130. one query question
  131. replication problem: target database cannot be accessed during replication
  132. DB2 ICE ( Integrated Cluster Environment )
  133. VIEW with specified columns for update?
  134. Problem with replication
  135. Issuing a SET SCHEMA command in a trigger..
  136. increase UDF_MEM and APP_CTL_HEAP_SZ size
  137. UDB Questions
  138. Select sometimes returning subset of qualifying rows.
  139. any help for DB2 installation on AIX
  140. Package Cache Overflow
  141. foreign key defs 390/v6 vs. 390/v7
  142. help needed for installing DB2 on AIX
  143. Reorg on UDB
  144. 2 concerns on FP4
  145. Previous Versions of UDB
  146. instance crash during select
  147. [SQL] Problem with group by and max
  148. DB2 vs MySQL - performance on large tables
  149. SYSPROC.SET_ROUTINE_OPTS exists?
  150. Database marked bad.
  151. UDB 8.1 PE and Distributed Debugger
  152. Migration DB2 V7.1 to DB2 V8.1.4 (both Linux)
  153. DB2/UDB on UNIX:
  154. the performance of jdbc driver
  155. DB2 V8.1 FP 4
  156. IBM DB2 Version 2.0
  157. Concurrent update of two child rows locks one out.
  158. BCD from NT to MF somtimes garbled, sometimes not
  159. DB2: Oracle equivalent of Autonomus transaction
  160. How to get the dependency tree for functions and procs
  161. parameter markers - SQLBindParameter issue
  162. db2 v7 zos archive logging
  163. Second instance in local node
  164. log shipping using ftp
  165. Improve query performance on large table
  166. *urgent* [LOAD] UDB v 7.1 OS/390 DATE problem
  167. index limits ?
  168. Authentication problem
  169. compatibility question
  170. bookmark in resultset
  171. 390 databases in visio
  172. why the table create in different tablespace
  173. Determining fixpack level programmatically?
  174. db2 application error ADM5530E
  175. db2 XML extender & Performance
  176. Create wrapper error with udb v8.1 FP3 on Linux
  177. RUNSTATS and JDBC
  178. reason codes
  179. SQL3089N
  180. Create index filled up transaction log
  181. SYSIBM tables corrupted.
  182. Call Stored Procedures via ADO
  183. PHP connecting to DB2
  184. db2 mainframe SQL question
  185. database monitor snapshot on partitioned db
  186. Number of Containers on a RAID Device
  187. Retruning the first five rows of a query statement result
  188. DB2 V7 TS Partition level reorg with NPIs
  189. Federated Informix - how to djxlink?
  190. ALTER TABLE ... ALTER COLUMN ... SET DATA TYPE
  191. [LOAD] UDB v.7 statement: correct?
  192. How much space does a certain Data-Type need?
  193. Test ignore!
  194. aliases/nicknames for fields?
  195. Java stored procedures on different dbs on same server
  196. User Contingency in DB2 UDB 7.2?
  197. Warehouse job schedule error
  198. SQLJ - DefaultContext Synchornization
  199. export table without string characters delimiter
  200. Improve query time
  201. Low Performance...
  202. A simple question: How to echo a newline in script
  203. Help needed with DB2 UDB 8.1 ESE on HP-UX 11i
  204. Restoring DMS DB from multipe backup files
  205. JDBC, DB/2, Apache and TomCat
  206. JDBC, DB/2, Apache and Tomcat
  207. Error running SQLJ.INSTALL_JAR
  208. Desupport Date for UDB V6 on z/OS
  209. a short connection problem
  210. Recursive stored procs
  211. Exceptions from ESQL/C to DB2
  212. Is GENERATE_UNIQUE unique only within a database?
  213. NEED HELP - Query Conversion
  214. Delimiting Single and Double Quotes
  215. SQL0632N. Why can't a child table be related to multiple parents on multiple FK columns with the on delete set null option?
  216. DB2 Client v8 access DB2 v7
  217. PATCH1 settings not taking affect
  218. DATE: valid expression
  219. Problem running simultaneous queries DB2 v8
  220. Using a lot of Tempspace
  221. foreign key constraint slows down UPDATE performance
  222. DB2 CAF DISCONNECT and re-CONNECT
  223. store java class files
  224. french characters in file
  225. does DB2 (UNIX/Windows, S390 and 400) support dead connection detection
  226. DB2 fixpack == forklift upgrade?
  227. JVM start failed
  228. Access 2000 ole db use of DB2
  229. Command Center multiple databases
  230. Table and Column naming conventions
  231. ORDER BY - how to sort on different ranges?
  232. NET SEARCH EXTENDER
  233. Agent Memory, how to determine
  234. Import update from files in a directory
  235. Error SQL0035N when creating stored procedure
  236. What to do when you see error DES0333N with DB2 Text Extender
  237. Development Center
  238. transform row into col
  239. Federated Join EE to EEE
  240. Status Change Time
  241. jdbc type 4
  242. DB2 for Linux - Backup to NFS filesystem?
  243. Understand the big picture ...
  244. CLI to get database directory
  245. Health Monitor Emails and SQL Functions
  246. SQL question
  247. IBM DB market share
  248. Load Pending status
  249. db2 installation failure
  250. db2 load from
  251. Log command in history file question
  252. Syntax of the string representation of a datetime value is incorrect SQLSTATE=22007
  253. Can I do a revoke select on table in a stored procedure?
  254. DB2 7.2 workgroup edition: problem with installation on W2K
  255. DB2 7.2 workgroup edition: problem with installation on W2K
  256. DB2 - Include files for API create Databse EBCDIC
  257. syscat.packagedep
  258. capture access plans ...
  259. DB2 commit synchronization
  260. capture the access plans
  261. trigger updating another table gives SQL0206N
  262. When will FP 4 for DB2 8.x be released to the public?
  263. File writing performance
  264. CURRENT SCHEMA/QUALIFIER for DB2 Z/OS 8.1?
  265. Why DB2 creats so many new folders, like: "db2admin.MACHINENAME.026"?
  266. Soft permissions?
  267. insert fails - accessing AS/400 from MS SQL Server linked server
  268. Build of SP from SPB fails
  269. How to find out database state ?
  270. test ... please ignore...
  271. Selecting from a view built using UDFs
  272. Listing DB2 Constraints
  273. Create Table DDL: WITH DEFAULT question
  274. Exception handling within triggers
  275. Test - Please ignore
  276. SQL status '02000' too early!
  277. DB2 Everyplace
  278. udf that doesn't run in wlm environment ???
  279. How to use parameter markers for "for bit data" columns?
  280. Which one got problem? MDC or the optimizer ...
  281. How to change interface language?
  282. DB2/UDB 8.1 HA Failover
  283. How to find out the SQL statements causing deadlock?
  284. Problem on Linux OS/390 for Db2 Connect
  285. asnmig8 problem
  286. RunTimeClient vs. AppDevClient
  287. sqlureot (reorg api) in a stored procedure (w2k, v6.1, fp11)
  288. FW: Check the patch from MS Corporation
  289. SQL_ATTR_CONNECTION_DEAD
  290. SQL0401N on Check constraint on UDT column.
  291. Support for RedHat Enterprise v3
  292. COM.ibm.db2.jdbc.net.DB2RowObject.getDataFromBuffe r
  293. Oracle VS DB2 White Paper // Request For Comments
  294. Only 1 of 3 columns per row can ever be populated!
  295. DB2 UDB V7 & V8 codepage difference - DB2 z/OS ?
  296. How to tell if a MQT is maintained by USER or SYSTEM
  297. error 99999
  298. ODBC question
  299. measuring internodal communication time on Linux
  300. DB2 (Common Servers) data layout in containers
  301. Stored Procedure Builing Problems
  302. Dump Files?
  303. Help me please
  304. PHP on RedHat 7.2 connecting to DB2 V6.1 database on Solaris
  305. DB2 Certification
  306. DB2 6.1 on RedHat 7.2
  307. How to get the last N records from a table
  308. LOAD question
  309. internal lock
  310. IX lock not released
  311. Insert Performance on a Partitioned DB
  312. information integrator & informix
  313. performance tools
  314. DB2 Connect Error SQL20081N
  315. DB2 Connect Error SQL20081N
  316. row level lock
  317. log shipping tables
  318. DB2 SQL Extracting and reusing labels from existing fields
  319. Running application from VB environment and .exe - differences
  320. Search many tables
  321. Stored proc compile error
  322. How to setup custom location for db2 source?
  323. Windows Domain Problems
  324. Windows domain problems?
  325. Asynchronous index reads
  326. Commits on sql questions
  327. sql error 911
  328. DB2 dropped into first gear?
  329. new to db2 - need help to get started
  330. Web Report Tools For DB2?
  331. Help me
  332. Where Can I locate current db2 connections by a client
  333. sqlcodes for failover
  334. multiple containers for a tablespace on the same file systems
  335. buffer pool hit ratio
  336. Performance problem (maybe cos of Terminal services?)
  337. Dont read!!
  338. Environment Variables
  339. yyyy from timestamp
  340. CAN WE USE AST(summary tables) in DB2 OS/390
  341. db2 installation
  342. Temporary Tablespace type to encrease performance
  343. ODBC Connection options from Windows Server to DB2 on AS/400
  344. DB2 V7 Replication performance
  345. DB2 shared memory and extended storage
  346. who can explain this?
  347. Snapshot from DB2 to Oracle
  348. lock escalation
  349. DB2 UDB V7: Ignoring a set of parameters problem
  350. Using JDBC batch
  351. stale cursor???
  352. ESE parallel db - how to drop a node from nodegroup
  353. joining several tables
  354. Heap used by process reported through pmap
  355. How can know the transaction per second
  356. copy db2 tables from region to region
  357. urgent ---SQLCODE: -805, SQLSTATE: 51002, SQLERRMC: NULLID.SYSLH203 0X5359534C564C3031
  358. db2jdbcbind
  359. transaction log is full
  360. db2_striped_containers
  361. configure parameter
  362. Information_schema
  363. Stored Procedure, C, OS/390, DB2
  364. fixpack question
  365. UDB 8.1 CLI/ODBC Schema Support for DB2/VM 7.2
  366. pmap on Solaris to monitor memory usage for DB2 and ipcs
  367. List of Instances on a machine
  368. Using Net Search Extender
  369. db2 connect with no response
  370. Access 2000 does not see summary table in DB2 UDB
  371. CLI connection failed. SQL0902C. A system error (reason code="6029321") occurred.
  372. 2nd try: embedded newlines in SQL in Java/JDBC v8 changed things?