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