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. SQL6048N/DBI1281E on SuSE 9, doesn't go away after reinstall
  2. Monitoring changes in a database
  3. How many extents does a BLOB need?
  4. How to change to an older JDBC driver
  5. db2diag.log message ....
  6. Uninstall UDB8.1 on windows
  7. merge statements and triggers
  8. copying data from one database to another database
  9. Bind files from NT to 400.
  10. configuring java stored procedure so only 1 sp call processed at a time
  11. Help needed : How to Execute a string SQL statement with DB2
  12. Websites ....
  13. Websites ....
  14. SQL stored procedure on z/OS ....
  15. XML Extender and DAD issue...
  16. Java Stored procedure
  17. DB2 8.1 rtc and MacOs X
  18. DB2 Replication: Change Aggregate Table
  19. update a database
  20. Assistance with Auditing Checklist for IBM DB2
  21. ConnectionString ado.net and iseries
  22. DB2 Crash in the weekend
  23. External UDFs & Embedded SQL
  24. Federated DB, access to remote sequence
  25. db2 first admins
  26. Back with the same DB2/PHP problem
  27. Looking for a development tool
  28. UDFs (written in C)
  29. Error message help
  30. cannot do DB2 operation even though logged in with administrative privileges
  31. Defragmentation and Performance
  32. LOB Locators and DB2CLI
  33. DB2 on OS/390 - Administrative API ??
  34. Easier Object changing in Stinger ?
  35. Alternatives for "OUTER JOIN"
  36. stored procedure
  37. DB2 XML Extender: Error while dxxGenXML()
  38. SQL stored procedure on UDB 8.1.3 ....
  39. Direct reads & In memory Database
  40. Migration toolkit question ....
  41. Error message cause HELP
  42. Quest disappearing HELP EMERGENCY
  43. how to remove the row lock from admin side
  44. Cursor in UDF
  45. SessionId on DB2/AS400 ?
  46. C++ on DB2 express
  47. Table scans for larger rowcounts?
  48. File Permissions for system administor on AIX for DB2 UDB
  49. Java Stored procedures cannot get updated class file recognised
  50. User permissions for the DB2 UDB sysadmin user id on AIX.
  51. Question related to "CREATE TABLE AS SELECT" in DB2
  52. how to connect db2 client to server
  53. restore question
  54. DB2 Mainframe JOB
  55. Unable to create char columns > 254
  56. failure recovery in a cluster?
  57. Shared Library problems on Solaris
  58. X Row locks causing Lock-waits
  59. DBI DB2 Federated
  60. DB2 8.1 and AWE
  61. RTFM, but which one?
  62. Can you have more than one Java Stored Procedure in a Class
  63. Java / C SP migration help
  64. db2fm produces two error messages per second forever...
  65. Do you use Job Scheduling?
  66. Db2 partitions in V4.0.1
  67. DB2 Procedures & Cursors
  68. Transact -SQL in SYBASE ....
  69. SYBASE to DB2 ....
  70. Last committed transaction
  71. Odd Stored Procedure Behavior
  72. Urgent Questions regarding Index usage & VIEWs, sorting, etc.
  73. SQL0444N when calling a stored procedure
  74. SQL0418N error: Untyped parameter markers cannot be used in some cases???
  75. Tuning CLI/ODBC application
  76. SQLJ Vs JDBC ....
  77. db2 + php screwy messages -- HELP, please!
  78. Printing with UDB WSE v8 and Win2000
  79. Num query fields affects num rows
  80. db2set running every 10 seconds
  81. Data compression i DB2
  82. UserExit succeeded manully but failed when loaded automatically by DB2
  83. CURRENT SQLID in CLP ....
  84. Character delimiter ....
  85. SQL0818N Timestamp conflict occurred
  86. Compiling db2uext2.cdisk with Cygwin gcc
  87. xml input into temp table.
  88. Use of MQTs
  89. Deadlock on runstats / reorgchk
  90. CLOSE_CURSORS_AT_COMMIT ....
  91. Inserts And Updates Using An UR-Connection
  92. Returning exceptions from a SP called from a Trigger...
  93. IBM Distributed Debugger ....
  94. Select from different server
  95. Query performance
  96. rebalancing containers
  97. Upcoming OCIUG Meeting & Querix Full Day Workshop -- Updated Agenda
  98. administration server not active udb 7.1 windows 2000
  99. "SQLSTATE" not valid in the context where it is used.
  100. How to reduce dirty page steals?
  101. Command Center script saving ? V7 / V8 changed behaviour
  102. New blog
  103. Transferring Data from Sql Server 2000 to IBM db2 udb
  104. db2icrt is not of the right version
  105. Meaning of direct_writes in tablespace snapshot
  106. Generated DB2 tablespace with datafile
  107. Problem using Control Center to create database from backup
  108. Handling invalid database connections from connection pools
  109. Instance crash on db2 v 8.1.5
  110. Backup and Restore DB
  111. Simple SQLj question ....
  112. After Reorg space is not reclaimed
  113. Returning user defined datatype from stored function.
  114. JDBC Connection on AIX and DB2 7.2.4
  115. Invoke LOAD command?
  116. Stand by server
  117. Sorting primary key
  118. strange "Log Full"
  119. memory error with sqleAddEntryToResync
  120. SQLJ stored procedure ....
  121. How to implement CA Erwin change management?
  122. URGENT HELP - Fixpack 6
  123. what's "share-nothing archtecture"?
  124. Health Center UDB V8.1.4 for Windows start problems
  125. Sync. remote DB
  126. STORED PROCEDURE SETUP???
  127. Errors in first stored procedure
  128. Help - Dynamic Table
  129. INSTEAD OF INSERT ON
  130. INSTEAD OF INSERT trigger
  131. How to do an variant select in a stored procedure?
  132. Incomplete recovery with lost of data
  133. Performance of SQL
  134. cpu time high
  135. DB2 V8.1 System Tables Diagram
  136. index hit
  137. DB2 date format issue
  138. Restoring Backup image problem
  139. sqlcode=-843/SQL0843N why ....
  140. javax.sql package for DataSource interface ....
  141. DataSource interface ....
  142. Returning multiple result sets
  143. how to compare two tables difference
  144. SQL1224N.....SQLSTATE=55032 Problem.
  145. Multiple counts using grouping, ordering, and joins
  146. Is there a view to return path of tablespace
  147. Usage of DB2 8.1 FP4 compression APIs
  148. Obtain only alphabets from table
  149. Urgent Help - Limit to use CPU 1
  150. stinger load question
  151. errors running db2cc .....
  152. problems using own TM
  153. hey folks!! need advice to take up the DB2exam700
  154. Reclaiming LOB space from deleted CLOBs in V8.1.5?
  155. importing XML data
  156. SQL0502N -- open cursor -- jdbc type 2 driver
  157. Download DB2 v7.1
  158. Simple SQLJ program ....
  159. Export to CSV-File
  160. Cryptic JDBC exception
  161. Db2 on Linux
  162. Upgrading from DB2 7.2 to 8.1 on AIX
  163. AVG of Date
  164. how to *really* remove a database
  165. LF example of dbinfo with "language SQL"
  166. Sequence alternative on UDB 7.2
  167. DB2 Development Center: Java stored procedure question ....
  168. DB2 v8.1.5, Linux
  169. Table and/or Database Creation Time
  170. db2 instance
  171. db2 restore problem
  172. Duplicating a table
  173. fixpack5
  174. join view question
  175. Detecting MVS shared subsystems
  176. RESTORE ERRORS on 8.1 WIN2k
  177. What is the publication# for a full DB2 v8 Linux paper documentationset?
  178. Very simple Table Function in a View failing when queried ? ....
  179. Db2 7.1 installation on Suse Linux 9
  180. No result set being returned in SQLJ Stored Procedure ....
  181. Command center, DBA2192 error only when using interactive mode
  182. backup: database configuration parameters
  183. sequences auto-increment
  184. Migrating from MS SQL to DB2 UDB
  185. Identifying IDENTITY columns via the SQLDA
  186. Determining Timestamp for Point in Time Recovery on DB2 UDB
  187. Calling a DB2 Subroutine from a Non DB2 Subroutine
  188. Porblems with WebSphere and DB2 on OS/390
  189. dms with stripe type volume
  190. Fenced SQL PROCEDURES vs Fenced STORED PROCEDURES
  191. DB2 Connection relational: Does it work?
  192. How do I SET PATH ala Universal Driver JDBC connect properties?
  193. SQLJ.REFRESH_CLASSES() ....
  194. invalid column name ....
  195. SYSIBM.SYSPLAN ....
  196. Create BLOB field in DB2 v7.2 on OS/390
  197. Create BLOB field in DB2 v7.2 on OS/390
  198. MIRRORLOGPATH
  199. DB2 Information Center ....
  200. Fixpack 5 on linux and "consider relinking" message
  201. load data into NOT NULL column
  202. command center query limit
  203. DMS, Linux, and iostat?
  204. restore from AIX to WINDOWS - is this possible?
  205. restore db2 problem
  206. Registry Variables
  207. almost no operations on 390 varchar
  208. SQL PL Profiler
  209. Turning off lock escalation in DB2
  210. Archive Logging
  211. [DB2 on AS/400] leave an opened cursor in SP
  212. ssh in place of rsh in V8
  213. SQLJ program question ....
  214. redhat advanced server and db28.1
  215. DB2 load command
  216. DB2 Stored procedure
  217. DROP a package ....
  218. db2 System commands through Command Center ....
  219. db2profc ....
  220. Performance problem ? on a positionned cursor
  221. merge performance
  222. DB2 and Java on Itanium wiith RHEL AS 3
  223. SET SCHEMA command sometimes ignored?
  224. test
  225. bldrtn and embprep
  226. Without rolling forward
  227. DB2 and Win2K shared memory limit
  228. Roles?
  229. DB2 improvement suggestion
  230. data migration question - MS SQL to DB2
  231. db2ckmig failure
  232. Equivalent to LOGIN_PROCEDURE?
  233. DATABASE ADMINISTRATOR - DB2 - Multiple Positions ( 3 )
  234. View with 2 data bases
  235. SQL0104N in Command Center - Interactive
  236. Multi-nodes in one instance in linux
  237. Function to format SQL
  238. calling DB2 load utility from a C program
  239. select rownumber() over(), ... affecting plan very badly.
  240. Max record size?
  241. DB2 Schema Mapping
  242. decimal point comma or period ? from DB2 Connect V8 to DB2 z/OS V7
  243. How to avoid codepage conversion?
  244. charge back
  245. catalog database on the system problem
  246. after ip address changed, get communication error
  247. type 4 driver -- needs runtime client?
  248. Stored Procedure _ Case STMT
  249. Physical Memory
  250. Calling inet_addr from a C++ udf
  251. db2cli.ini file for JDBC ....
  252. Fixpack5
  253. Limiting CPU usage
  254. db2 jdbc trace ....
  255. What is IBM's licensing policy regarding a backup/test DB2 server?Is this legal?
  256. UNIX IDE
  257. tough choices
  258. New bug in v8 FP5 DB2 IMPORT command?
  259. dramatical performance degradation on dynamic sql over night
  260. Using DB2 813 Type 4 drivers with DB2 7.1 server
  261. SQL1042C An unexpected system error occurred.
  262. use import utility when the target table does not exist
  263. USERSPACE1 in a restricted state ....
  264. URGENT: Problème avec CREATE SERVER
  265. DB2 8.1 PE Licence question ....
  266. speed test tools
  267. How do I SELECT multiple columns as one column
  268. Errors in Sample program
  269. How can I safely kill a runaway db2fmp that came from a java UDF?
  270. NEWLOGPATH
  271. SQLSTATE / SQLCODE
  272. How can Permissions affect Performance ?
  273. Arjen Jongeling, een oude bekende
  274. Performance with table millions of rows
  275. db2 TDataSet descendant
  276. A basic question about table addressing
  277. db2 on vse?
  278. SQLCODE: -805 SQLERRMC: NULLID.SYSLH203 WSE 8.1 FP5
  279. Debugging Java stored procedures ....
  280. How to install DB2 for TSM on AIX
  281. iSeries DB2/UDB V5R2 - troubleshooting system triggers
  282. how to show the null value from db2 command window
  283. how to get rid of the null value in the join view
  284. strange response time on one sql
  285. NEED DB2 DBA
  286. Multiple join performance
  287. Installing ICM (IBM Content Manager) under Windows
  288. Java Exception thrown while Updating/ Inserting CLOB field.
  289. Log file size
  290. DB2 Cube Views and DB2 Office Connect
  291. How to write a single update sql statement to update different setof attributes of a table
  292. Undefined name
  293. V7 Alternative to INSTEAD OF Trigger?
  294. Unique ID
  295. DB2 & PHP - SQL commands
  296. Combine 2 databases into 1 database?
  297. Great Company Needs a DB2 DBA and DB2 Systems Programmer (One Position)
  298. Odbc
  299. Can we restore redirect a db2 version 7.2 backup to db2 version 8.1
  300. Client application calling Stored Procedure...
  301. ADO.Net & Locking
  302. LIST APPLICATIONS fails ....
  303. Codepage conversion and FOR BIT DATA
  304. New to DB2
  305. Performance Monitor in V7 doesnot exist in V8
  306. Has type 4 JDBC changed the rules about how FPs must match up?
  307. COM.ibm.db2.jdbc.app.DB2Driver JDBC version compatibility
  308. Client and Server process both seems to be sleeping forever
  309. Space for Reorg Indexes with Read Access
  310. Capture fails to start with ipc error...
  311. How to know history sql queries
  312. Explianation of Windows Services
  313. dynamic sql EXEC SQL EXECUTE
  314. Tools for importing database into DB2 7.1
  315. Content Manager 7.1 with DB2 8
  316. Stored procedure authorization ....
  317. db2_all returns completed rc=0 with no output
  318. Migration problem due to decimal separator keeping being COMMA instead of PERIOD
  319. SQL22205C - DAS problems
  320. php-odbc and dynamic vs forward only cursors
  321. Capture error.
  322. database file and drop a table
  323. unable to load data into long varchar field
  324. Problems with DB2 type 4 driver
  325. Reset Monitor
  326. CREATE TABLE AS - not materialized?
  327. iSeries DB2/UDB V5R2 - UDF not found problem...
  328. how to do index scan
  329. clusters and HA?
  330. Insert Performance Tuning
  331. db2eventlog.000
  332. DB2 V8 Performance
  333. Java stored procedure error ....
  334. Exorbitant execution time
  335. Transaction logs full
  336. DB2 Replication to SQL SERVER 2000
  337. DB2 "ALL" subquery strategy
  338. SYSTEM MANAGEMENT SPECIALIST- DB2
  339. DB2 PE and Debian GNU/Linux
  340. LOCKWAIT table function
  341. com.ibm.db2.jcc.c.DisconnectException
  342. Performance problem after migration to DB2 v8
  343. Backup via Cron
  344. num data sets with a specific value
  345. How can I be getting this message
  346. Best way to check total within row
  347. SQL Procedure Profiler for Stinger
  348. update on running db2 8.1 on rh enterprise server v3.0
  349. Backup
  350. WHERE IN
  351. Configuration Assistant
  352. IBM DB2 bug due to db2cli.ini entries
  353. Universal JDBC Driver ....
  354. Looking for a DB2 expert to come to setup system at my office in Canoga Park, CA.
  355. Help: inserting BLOBs larger than 100k in DB2 8.1
  356. Link re debugger
  357. Force CLP to use another collection than NULLID ?
  358. FOR BIT DATA
  359. [Q] Pb with IDENTITY pointer after LOAD
  360. Runtime client installed ....
  361. "No Suitable Driver" error ....
  362. problem with database since power outage
  363. bitwise
  364. No Cascade on Before Trigger firing other triggers
  365. What secrect to db2cc 7.1 on AIX4.3
  366. Change host name on preexisting DB2 v8 Linux server?
  367. 3rd Party Tools
  368. Throwing errors in UDF scalar functions
  369. Restrictions for SPs
  370. DB2 7.2 Fixpack 8 crashed
  371. obtaining fixpacks for stinger
  372. 8.1 crash - simple code
  373. QUIESCE question (mvs)
  374. Wanted SQL Parser
  375. check if table has a lock before running query
  376. SQLJ BLOB Java and DB2 V7.2
  377. db2 connect or udb
  378. UPDATE CURSOR and LOOP
  379. 500+ Links about DB2 for z/OS and OS/390 (06/01/04)
  380. compiling a db2 program
  381. Column XXXX not in specified tables. (#-206) <--- Please HELP!
  382. case statement
  383. Using DB2 with Visual C++
  384. Lock Escalation - Share Lock
  385. How can I let DB2 to use more CPU
  386. How to connect to db2 database using perl or php
  387. Application hangs while symultaneously running two instances of client on DB2
  388. Explain an error message
  389. Extend Informix (ESQL/4gl) programs with DB2 connection
  390. SQLSTATE=42602
  391. How to define
  392. For a specific tablespace generate all the rebind commands for relevant pkgs & plans
  393. about optimize low cardinality data query
  394. TCP Error on AIX / DB2 7.2
  395. Change DB2 client config from remote system?
  396. Online SPUFI in Batch
  397. Is DB2 7.2 UDB compatible with Win 2000?
  398. Performance Problems with ORDER BY
  399. strange results with executing a query twice!
  400. Connecting to a database got no response
  401. DB2 wish: promoting an existing index from regular to clustered
  402. Why is schema SYSIBM
  403. how to use sql to query from different database
  404. SQL Error via ODBC but not in Command Center
  405. How to list an instances databases
  406. database market share 2003
  407. invoke db2 clp from dos prompt
  408. Sybase to UDB conversion
  409. How to find out uncommited transaction?
  410. DB2 Java Stored Procedure refresh Issues
  411. V5R2 DB2/UDB iSeries: can a system trigger call a SQL stored proc?
  412. Reverse Engineering an iSeries Database with ERWin
  413. QUIESCE RESET DOESNT WORK ON EEE SYSTEM
  414. select for update access plan
  415. All SQL's on a table hang, even a "drop table" statement.
  416. Restricting database backup file size
  417. db2 command line need any env variables
  418. v81 -- tools did not get installed
  419. Insert data into Db2
  420. how to select the last row of the resultset
  421. DAS unresolved symbol (HPUX 32bit)
  422. Executing memberfunction in udf
  423. OPENINGS FOR DB2 DBA'S
  424. Error explanation help
  425. SQL1092N while starting database on linux
  426. Analyzing memory usage by db2agents
  427. how to migrate from 7.2 to 8.1
  428. DB2 V8 certification books
  429. SQL Assist Results ??
  430. UDF Performance
  431. Quest Central: Duplicate database name?
  432. Resource for Stored Procedures ....
  433. Resultset close after commit?
  434. Event Monitor
  435. iSeries DB2/UDB V5R4 - Getting RRN in SQL Trigger?
  436. how to use ibm ole db provider ???
  437. Can two different versions of DB2 Connect be installed on one machine?
  438. "Run SQL Scripts" in iSeries Navigator - an alternative tool?
  439. application bug: db2fm(7272) has SIGCHLD set to SIG_IGN but callswait().
  440. SQL1072C Red Hat Linux 8, DB2 7.2
  441. RUNSTATS & SET SCHEMA bug?
  442. SQL5043N Support for one or more communications ... and SQL8011W
  443. install error db2v8 / redhat 9
  444. Bug in LOAD command?
  445. DB2 V8.1 on Mandrake 9.1/9.2
  446. concise SQL results
  447. Migrazione da Db2V7 a Db2V8
  448. 'Sysbase on Unix' to 'DB2 on OS/390' Data Migration.
  449. Sybase to UDB
  450. J.D. Edwards OneWorld Software Engineer
  451. Does DB2 have conditional rollback?
  452. Data Conversion Error while loading DB2 table.
  453. accidentally removed db from control center - HELP!
  454. multiple runtime clients?
  455. DB2 session information
  456. DB2 Version 7 to DB2 V8 Z/OS Project Plan
  457. java app driver - clob
  458. Visual Explain on UDB DB2
  459. update...where not exists .... on same table -- 390 v7.1.1
  460. SMS Temporary tablespace and files within.
  461. UDB V8.1 fp 5 Updating a table
  462. exception join vs. inner join with <> (is it the same?)
  463. win admin client - uninstall earlier version to upgrade?
  464. Generating Access Plans for Java Stored Procedures
  465. INSERT data-change operation data retrieval
  466. Faltering at first step in UDB PE installation...
  467. Faltering at first step in UDB PE installation...
  468. Faltering at first step in UDB PE installation...
  469. DB2 CONNECT v 8.1 FP 3
  470. Query
  471. Can You Put Tables in USERSPACE1 With Indexes In INDEXSPACE1 ?
  472. VB vs JAVA
  473. db2 java driver file names
  474. SQL3282N
  475. steps to upgrade to 8.1
  476. website for 8.1 admin/runtime client
  477. Query for Locks
  478. Nested Stored Procedures and Packages
  479. Order By statement
  480. 32 bit or 64 bit fixpak?
  481. Control center doesn't start
  482. connect db2 7.1 os/2 warp 3 connect to Win2k
  483. install of java jre for db2setup under linux RH 9.0
  484. client-server with db2
  485. Identity column
  486. simple question
  487. DB2 Development Centre Issue for Developing Java Stored Procedures
  488. newbue: Catalog node vs. catalog admin node
  489. Function to convert for bit data column to string?
  490. com.ibm.db2.jcc.a.SqlException: bug check while fetching from VARCHAR column
  491. Async Processing and DB2 V8
  492. DB2 deadlock on AS400
  493. multi-part keys
  494. Confused by OLAP functions
  495. "connect to dbname" is very slow...
  496. using sequence in select queries
  497. Handling quotation marks and apostrophes
  498. sql0902c reason code 122
  499. db2eventlog.000 in db2dump directory
  500. DB2 Clustering
  501. HELP! Connection does SOMETIMES not work on new installed Win2K Computers!
  502. ODBC driver for DB2 and AS/400
  503. DB2 APIs
  504. Restore database Vs Restore tablespace.....
  505. db2look produces unwanted ddl
  506. CallableStatement.executeBatch() problem
  507. DB2 V8 on Windows Doesnot Respond
  508. Looking for a db schema read/write/synch tool
  509. Error code when using DB2 Command Center
  510. Capture program logic?
  511. Like operand and case sensitivity
  512. toad for db2
  513. Logs and a RAID5 subsystem
  514. rollforward problems understanding CUT
  515. db2 delta backup failure
  516. Suppress Wanring message
  517. Suppress Wanring message
  518. What data loading tool for DB2?
  519. What data loading tool for DB2?
  520. SUM a Column contain NULL value
  521. SUM a Column contain NULL value
  522. DB2, Warehouse Manager + FixPack5
  523. DB2, Warehouse Manager + FixPack5
  524. Simple backup doubt....
  525. Simple backup doubt....
  526. DB2 Implementation - ERD Problems
  527. DB2 Implementation - ERD Problems
  528. Temporary Tables
  529. Temporary Tables
  530. Plea for help creating SQL query
  531. Plea for help creating SQL query
  532. query_heap_sz on client?
  533. query_heap_sz on client?
  534. DB2: Changing Data Type from INT to DEC(6,1)
  535. DB2: Changing Data Type from INT to DEC(6,1)
  536. db2 stored proc. problem -
  537. db2 stored proc. problem -
  538. Apache authentication module for DB2
  539. Apache authentication module for DB2
  540. Tablespace restore...
  541. Tablespace restore...
  542. DB2 v 8.1 universal JDBC Driver Weird behavior in WSAD 5.1.x and WAS 5.0.2
  543. DB2 v 8.1 universal JDBC Driver Weird behavior in WSAD 5.1.x and WAS 5.0.2
  544. Damaged container...
  545. Damaged container...
  546. Configuring Multiple Instances DB2 WINNT
  547. Configuring Multiple Instances DB2 WINNT
  548. query_heap_sz - can't see...
  549. query_heap_sz - can't see...
  550. RUNSTATS taking looong time