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. Performance problems when inserting into a large table
  2. Questions regarding large MDC tables
  3. Please take a look at this great program
  4. Is the Database Administration Service part of the standard installation or an option?
  5. No Keys on Federated tables
  6. DB2 Backup Error
  7. Finding if a character is alphanumeric
  8. Database Administration Survey
  9. create triggers
  10. Any DDL Information on the DB2 Logs?
  11. deleting records without writing to the transaction logs
  12. Reason Code: negative number
  13. E monografia Administração E
  14. questions on Design Advisor after FP8 apply
  15. Question on FP8 install process
  16. Detecting the INSERT format for DATE database fields?
  17. ODBC update error with DB2 timestamp data
  18. Full-time DB2 UDB DBA position in downtown Portland, OR
  19. db2jcc driver issue with getting an empty resultset
  20. sqltypes.h compile error?
  21. Issue with a stored procedure
  22. Statment too long or too complex
  23. Full Backup of DB2 V8.2
  24. How to use collect statistics for temporary index?
  25. Which DB2 on IBM xSeries 346-8840 with SuSE Enterprise 9 ?
  26. DMS tablespace size calculations
  27. .net installers
  28. Trigger porting problem
  29. SQL Code Beautifier for DB2
  30. I dont think y can
  31. Before delete triggers
  32. Federated Table Errors
  33. Access DB2 UDB thru teriminals
  34. Access DB2 UDB thru teriminals
  35. db2_all/rah completed rc=-10 on Windows 2000
  36. DROP error level (20) on iSeries UDB
  37. vargraphic column Question.
  38. Using SQL against Non DDS files?
  39. Memory Visualizer?
  40. create trigger -> invalidates stored procedure
  41. Can a table UDF modify SQL data?
  42. revoking select from all tables
  43. DB2,UDF,modifies sql data
  44. Reading triggering table data in trigger (without error SQL0746N)
  45. 3390 mod3 vs. mod9 performance
  46. DB2 V8.1.4 aix 32-bit to 64-bit migration
  47. Client for DB2 UDB 07.02.0007 database
  48. Large table redesign
  49. How to find actual LENGTH of a CHAR string
  50. Fixpack 6b?
  51. Is there a rule for determining number of Page Cleaners?
  52. Windows
  53. SQL0204N
  54. Multiple Tablespaces
  55. Washington (DC) Area user Group Meeting - January 27, 2005
  56. Will we be able to apply FP8 directly ?
  57. SQL0104N An unexpected token "END-OF-STATEMENT" was found
  58. updating a lob
  59. how to read exported files?
  60. db2 conf. on HP UX problem
  61. IBM DB2 Connector throws exception with .Connect() in .net
  62. Decrease database size
  63. How to determine what table got offline?
  64. Bufferpool reduces performance.
  65. Suppressing DB2 logon prompt
  66. SQL output, do I need recursive SQL todo this?
  67. Copying an existing DB2 database
  68. db2 block archtiecture
  69. DB2 Basic queries..
  70. DB2 Basic queries..
  71. Need help decrypt db2diag.log
  72. Where does one find a DB2 UDB DBA?
  73. Insert with RR causes Table Lock (DB2 z/OS V7)
  74. jsp - jdbc connection to db2v8 failing
  75. Stored Procedure Question
  76. How to retrieve FK reference infomation
  77. DB2 redbooks RSS feed
  78. AIV Extenders - where can I find it?
  79. db2 connect 7.2 on Linux with OS400 V5R3
  80. DB2 Personal Edition License Question
  81. IBM Visual Studio Add-in v8.2 , Problem when trying to compile a stored procedure
  82. db2look spools DDL in the ascending order of DB objects Timestamp only
  83. Connection to other database
  84. Problem to build Java stored procedures on DB2 V8.2
  85. multiple DB2 instances under one OS userid?
  86. DB2 8.1 Work group Edition Pricing/Licensing
  87. Multithreading in java stored procedure
  88. CLI0108E Communication link failure
  89. Branch elimination for a query on a UNION ALL View does not work as expected
  90. check constraint questions
  91. FP8
  92. DB2 error using the command with USERID/PASSWORD
  93. Not logged initially for Simulation catalog tables ?
  94. Uniqueness in a Nullable Column
  95. Question on reorgs
  96. Data moving from iSeries to DB2 UDB
  97. A VoIP usergroup
  98. Dont visit this site
  99. Error Reading DB2 BLOB field : Please Help
  100. Insert Clob using Perl into DB2 v8 on OS/390
  101. How to find the number of threads ?
  102. udb cursor (or curser)
  103. automatic statistics
  104. DB2 error using the command with USERID/PASSWORD
  105. GROUP BY question on standard
  106. log files full autocommit
  107. Windows UDB Question
  108. Functional Index.. How to?
  109. DB2 error using the command with USERID/PASSWORD
  110. memory leak in APPLHEAPSZ ?
  111. Cross-endian DB2 backup compatibility?
  112. the database with many inserts vs less reads
  113. Control Centre - Create -> Text Index (V8.2) , can you do it?
  114. Redirecting DB2 output in Korn shell
  115. Type 4 driver licencing error message ....
  116. Creating UTF-16/UCS-2 database in AIX
  117. How to log the source IP address of DB2 connection?
  118. db2advis -m C?
  119. SQL Compiler for Linux on AMD/Opteron-64 bit machine
  120. am I too tight on memory?
  121. How to find the version of the client...
  122. Can we use ORDER BY clause inside a SQL UDF
  123. db2diag error - "oper system services sqloWaitInterrupt Probe:10 "
  124. util_heap_sz - optimum value?
  125. Second call: third edition of SQL FOR SMARTIES
  126. Bookish Question Regarding DYNAMIC RESULT SETS
  127. LOADing BLOB
  128. Problem while using PUT Routine.
  129. Increase Decimal length in v7.x
  130. DB2 v MySql
  131. Triggers fire before commits... and can not be rolled back?!?
  132. where to buy udb 8.2 express
  133. Reg 704 - DB2 UDB V8.1 for Linux, UNIX and Windows Advanced Database Administration certification
  134. SQLCode -512
  135. REXX routines, zpharma DB2
  136. REXX routines, zpharma
  137. Data Recovery SOURCE CODE ( SOURCE CODES of Professional Data Recovery Software )
  138. Is it possible to create index for temporary table
  139. Large Data Tablespace Page Allocation
  140. Problem when connecting to DB2 from standalone java application
  141. write-back cache on or off?
  142. Slow odbc connection to AIX DB2
  143. Suggestions for configuring a laptop to learn DB2
  144. Having problems with Timestampdiff
  145. Help! my db2 cann't execute custom function. - db2diag.log (0/1)
  146. error after installing cwbodbc32.dll
  147. Restore Method - Delta and Incremental Backups
  148. authentication
  149. Trigger on update of ANY column?
  150. Difference between DB2 for LUW and DB2 for z/Series
  151. Anyone using Enterprise compiler co-processor (PL/I or COBOL) ???
  152. Why a simple select all query uses index scan and not table scan ?
  153. Need a bit of help with temporary tables
  154. registering UDF from shell script
  155. DB2 Compatibility
  156. db2move, problem importing data into table with GENERATED ALWAYS identity column
  157. DTS data from MS SQL 2000 to DB2 7.1 on OS/390
  158. DTS data from MS SQL 2000 to DB2 7.1 on OS/390
  159. DTS data from MS SQL 2000 to DB2 7.1 on OS/390
  160. IF statements in SQL Table Functions & Bad Plans
  161. Server side default JDBC driver
  162. hi
  163. DB2 ALTER TABLE TO UPDATE A COLUMN FOR NOT NULL
  164. Need Help With SQL Statement
  165. Capturing and restoring views and triggers
  166. stored procedure problems
  167. Configuration Advisor, Several Instances
  168. DB2 certification test
  169. SQLSTATE=58004 on rollforward
  170. can I restore a database from one system to another?
  171. Help with stored procedure execution....
  172. Can I see rewritten SQL?
  173. ERROR:Could not switch current DB2INSTANCE to "db2inst1"
  174. DB2 AVOIDING POLLING
  175. dynamically created column names
  176. DB2 authentication : how it works ?
  177. Incremental backup on DB2 7.2
  178. db2 min, max, count functions are very slow
  179. configuration advisor
  180. DB2NOEXITLIST variable does not seem to work?
  181. More Fixpak7a help - space problem
  182. DB2 OLAP 8.1 with iSeries
  183. version compatibility
  184. DB2 7.2 Z/OS - Functions - Where's the Function source text stored
  185. Install Fixpack 7a and stop Db2fmd
  186. Database replication
  187. Let your customer find fast and easy all text he searches !
  188. cics to db2 connection(attachment)cookbook
  189. DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command.
  190. Backup DB2 UDB 7.x on Linux Restore on Windows?
  191. optimization
  192. worst performing dml
  193. no SQL return code / resource name
  194. Another SQL SP bug or feature
  195. SQL30081N - Need solution for solving this problem - URGENT
  196. Carrer in Data Mining?
  197. multiple instance monitoring
  198. filter systables from ado recordset adSchemaTables (repost)
  199. repost: filter systables from ado recordset adSchemaTables
  200. What is the IBM policy on alternate fixpacks ?
  201. filter systables from ado recordset adSchemaTables (repost)
  202. Strange FP 4 installation Problem (DB2 V 8.1)
  203. Archiving blobs
  204. Reorg fails when associated tablespace size reaches 1Gb
  205. Some Basic Questions.
  206. Static SQL
  207. Why isn't ALLOW REVERSE SCANS the default?
  208. Problems with scheduled tasks (SQL22283N)
  209. MERGE syntax error
  210. multi-row parametters + BLOB
  211. Catologing
  212. Equalent to Statspack for DB2..
  213. Cannot modify procedure created by another user
  214. 390/V7 timestamp column auto updated??
  215. Need for UDB DBA
  216. Good Resource on Explain Plan Format
  217. Raw DMS single- vs. multi-table tablespaces
  218. interpreting encrypted data stored on DB2 using Perl
  219. Select statement return result very slow
  220. filter systables from ado recordset adSchemaTables
  221. How do I take table name from user in UDF
  222. Finding out the membername in DB2/ ZOS DATA sharing env.
  223. Select satement return result very slow
  224. System clock vs. DB2
  225. CALL in Trigger, -746 and the WHEN clause ...
  226. Statement Event Monitor Data
  227. How to compare objects between two database?
  228. Scheduled tasks never run on time
  229. DB2 Connect vs. DB2 in an AIX environment
  230. When does a UOW start on the DB2 Log
  231. Error SQL1265N
  232. CURSOR Keeps Closing
  233. IBM human resources may be stealing from you
  234. DB2 Administrative Server and "discover=KNOWN" setting
  235. Sysbase to Db2.
  236. RID Failures
  237. exception handling in db2
  238. Remote Instance connectivity issue - DB2 8.2.0 on Windows 2000 Server.
  239. Exception handling in db2 UDF
  240. Certification Tutorial for Advanced certification (704)
  241. Certification Tutorial for Advanced certification (704)
  242. Certification Tutorial for Advanced certification (704)
  243. a question on "High performance SQL"
  244. Apparent contention issue with DB2 backup
  245. DB2 under win xp
  246. about auto-commit
  247. Federated Database
  248. Federated Database
  249. Quiesce Database and Logs
  250. How to check data integrity of a DB2 instance?
  251. Need Help With a Load
  252. Date column and table scan
  253. content manager - help
  254. Recover Using INCREMENTAL AUTOMATIC
  255. Recover Using INCREMENTAL AUTOMATIC
  256. Need help with unspecific error
  257. How to get a password in V8.2
  258. Breaking News: MySQL beats Oracle in Benchmark
  259. REBIND fails with SQL0029N
  260. Connection contexts in SQLJ routines
  261. SQL OK in 8.1.0 but not in 8.2 ?
  262. Oracle-mode Firebird
  263. NLS Support in DB2 as a configurable parameter
  264. what is true image?
  265. installation de db2 (V 8.1) sous linux suse
  266. reporting errors in a separate transaction
  267. Informix to DB2 Replication Problems
  268. java invocation of db2 clp
  269. DB2 Syntax for Outer join
  270. SET SESSION AUTHORIZATION
  271. License question
  272. Is db2gncol gone?
  273. Is the DB2 server on the local machine?
  274. db2advis not working in 8.2
  275. agent bufferpool hit ratio
  276. RAID 5 is Killing Performance?
  277. Question on userexits
  278. RAID 5 is Killing Performance?
  279. Joining Multiple Members
  280. New AIX DB2 instance requires new user?
  281. Unlogged Deletes in DB2/390 (or zOS)
  282. Unlogged Deletes in DB2/390 (or zOS)
  283. get/put routine
  284. searching on all fields
  285. Floyd's algorithm in SQL
  286. Informix "foreach execute procedure": converting to DB2
  287. Table display in CC
  288. looking for one good HACMP specialist to implement it in AIX / DB2 environment...
  289. shutdown
  290. maximum size of a database/tablespace
  291. DB2 AIX Create Database fails with Memory Allocation Error
  292. Database Administration Service
  293. Bit & SBCS
  294. db2advis not working in 8.2
  295. Db2 Instance owner and SYSADM authority
  296. how to perform muti byte to single byte conversion in DB2
  297. "Bad container path" during Backup?
  298. DB2 slow response on first connection Win 2003
  299. backup time
  300. differences
  301. Windows - DB2 Command Center - Create Database Wizard starts on its own
  302. time measurement
  303. measure recovery time
  304. UDB 7.2 fp9, dynamic-sql plans with parameter-markers
  305. Information Integrator
  306. Microsoft Access as Frontend for DB2
  307. New JARs (e.g.db2jcc_javax.jar) inside \sqllib\java after Fixpack 7a on DB2 v 8
  308. Problem in using DB2 Type 4 driver
  309. table with 7000 columns
  310. watch db activity
  311. Limit on number of params to an SP?
  312. Task Center From name
  313. 64 bit
  314. Trigger calling INVALID SP - strange behaviour ?
  315. Binary values in the database
  316. which registry variable to set ? (updated from 8.1 to 8.2)
  317. db2 corrupts data while loading from a TXT file
  318. Daily Devotion
  319. how to enable user exit
  320. DB2 Runtime Client
  321. Syntaxic statement coloration in Command Editor ?
  322. reorgchk with display full tablename
  323. I FOUND A SOLUTION OF PROBLEM SQLSTATE=HY011
  324. Lock Situation with a special Sql-Statement
  325. connect to a remote DB2 on z os
  326. Package NULLID.SYSLN304
  327. not logged initially - opinion
  328. DB2 Universal Language support
  329. SQL Query Question
  330. Catalog table used by Client when connecting via ODBC
  331. Extenders don't support long names?
  332. Mirroring to remote server
  333. Extenders don't support long names?
  334. about auto-commit
  335. problem with group by and maximum
  336. Need to rebind??
  337. Installing/configuring DB2 Connect V8.1
  338. DB2 version 8 rename command
  339. ID DB2 IDENTITY columns w/ type 4 JDBC DatabaseMetaData?
  340. Message SQL22212N when trying to run a task
  341. db2Backup API and missing SQL1152
  342. pctfree, pctused & data page
  343. estimate log size of "insert into...select * from..."
  344. Lock Escalation, LogRetain & Backup Question.
  345. Crystal Reports 10 connection to DB2 v7.1
  346. DB2 PREP ... PACKAGE USING ... without implicit binding
  347. script to automate instance connect/catalog in client
  348. I found this great little site
  349. Need Information on DB2 Certification
  350. Top DB Site?
  351. table size question!!
  352. Generating unique
  353. Problems running db2setup on Redhat 3 ws
  354. Defragmentation
  355. restore db
  356. Database Administration Server (DAS) -- is there a stealth or IP lockout feature?
  357. many ports
  358. SQL Null handling in predicate evaluation involving IN
  359. How to get TABLE NAME displayed in SYSPUNCH card.
  360. Building DB2 CLI in Borland C++ on Win2K
  361. Searching SQL-Funktion ...
  362. help with database research topic
  363. subtypes
  364. New "High-performance SQL" article on developerWorks/DB2
  365. dms, index destroyed, pls help
  366. DB2 Development Center
  367. sub select
  368. Universal jdbc driver : version ? and where ?
  369. Urgent: Is DB2 7.2 available for z/os?
  370. UNIQUE INDEX bug when Trailling blanks in VARCHAR column
  371. Unexpected SQL0100W
  372. sql0012w
  373. page size error SQL0286N
  374. Optimizer choosing bad plan?
  375. get server date
  376. How to migrate UDB v7.2.9 to UDB V8.1.5 in MSCS
  377. disable isolation level switch
  378. Problem connecting to database directory after installing fixpack 7a
  379. How do identify the source of Sort Overflow?
  380. Impossible to remove error
  381. Generate DDL works only for 30 tables?
  382. I want to monitor all sql statements
  383. db2 problem restarting WAS 5.1 on linux (intel)
  384. need to view all sql statements
  385. Certification Questions
  386. dynamic SQL from Hibernate and SQLCODE -301
  387. OS2 Warp v4.0 and DB2 v2.1.2 Daylight savings time problem
  388. table update with or without indexes enabled?? 390/V7
  389. LOB insert in CLP?
  390. Need recommendations re a good DB2 backup/recovery tool
  391. db2audit checking
  392. logarchmeth1,logarchmeth2,logarchopt1,logarchopt2
  393. Does 'select 1 from mytable where 1 = 0' do a table scan?
  394. UBD upgrade from vs 7.2 to vs 8.1 causing slow inserts.
  395. Udb Db2 Vs 7.2 Vs 8 Upgrade Resulting In Increased Insert Times
  396. Use of ROWID in DB2 on Z/OS v7.1.1
  397. UDB 8.1 and multiple connections
  398. dms management
  399. Query in Prepared statements caching
  400. rownumber() over - which versions support this
  401. SQL Join question
  402. DB2 CPU USAGE
  403. sp in db2
  404. Unicode DB2 Performance
  405. db2set
  406. V8.2 - SQL/PL Continue handlers not working?
  407. Does anyone have experience with the efficiency of global temporary tables?
  408. Is there a straightforward way to export/import an entire schema in DB2 UDB?
  409. DB2 not using all processors
  410. finding CPU utilization per database or instance
  411. windows CLASSPATH in a Java UDF
  412. DB2 z/OS procedures - Nested Block error in Exception Block
  413. [DB2] Erreur CLI0102E Invalid conversion. SQLSTATE=07006
  414. Session tables problem when used from multiple threads
  415. Determining JDK_PATH
  416. rename server when DB2 installed
  417. reclaim disk space
  418. DMS Tablespaces
  419. What is wrong with SQL syntax
  420. UDF on DB2 V7.2 and AIX V5.2
  421. Lock Mode Question
  422. I-Series DB2 Self-referential constraint issue causing locks
  423. Transaction Logs
  424. Options to set will not be saved under DB2 Console
  425. Index usage
  426. obtaining authority to run list applications - ordinary users
  427. hacmp
  428. please let me know the procedure for doing rollfoward mininum recovery using long talbespaces
  429. Searching DB_PATH
  430. How to kill running procedures.
  431. Take a Look at This ...
  432. production and qa
  433. Question to Independent IT Consultants
  434. create users in db2
  435. Problem with DB2 JDBC driver?
  436. Editions from DB2
  437. victim selection
  438. Log Shipping Issue
  439. what is this supposed to mean?
  440. Scoping out the size needed for running DB2 audit facility
  441. Accuracy of Data in /DDEL of db2dart
  442. How to stop FMC?
  443. Integrate and merge multiple data sources
  444. Problem with Catalog database
  445. Can you Fool DB2
  446. Memory is full
  447. How to delete data from a table quickly
  448. Transpose rows to column
  449. Personal Edition
  450. Stored Procedure commit point
  451. stored procedures problem
  452. PROBLEM WITH CLONING A DB2 SUBSYSTEM MORE THAN 1 HLQ FOR VSAM
  453. V8.2 - How to stop SPs always being explained?
  454. Fixpack 7a
  455. Two questions about "alter table tbname activate not logged initially"
  456. db2advis
  457. db2advis
  458. db2Advis
  459. Migrating from DB2 UDB 6.x on Solaris to UDB 7.2 on Linux
  460. Same query, different access plan in Prod. and Dev.
  461. How to find build level or fixpack level?
  462. DB2 8.1 FP 7 on AMD Opteron
  463. db2 v8 on windows
  464. why should temporary table space page size matter?
  465. /usr/lib64
  466. Fifty Thousand Foot View needed for DB2 audit capabilities
  467. DB2 Explain
  468. Database backup & Schedule problem
  469. Problems with setting up replication
  470. Max length name of a database/schema
  471. Time functions in db2
  472. AddNew Fails when too many fields are added
  473. simple csv export db2 with *column names*
  474. Development center
  475. connecting to the DB2 UDB Windows 2003 Server
  476. SQL-Statment that add to strings
  477. ROW_NUMBER on ZOS/OS390
  478. Import and triggers
  479. Adding a column - Column oder a concern?
  480. Load Problem With MDC Table
  481. DB2 8.1 Client
  482. Kernel Parm Settings for DB2 v7.2 On SuSe 9.1
  483. Help with UDB and MQSeries. Can't use the UDF wizard to create MQ UDFs
  484. Where can I get the DB2 backup/restore errors?
  485. Federated Database: performance problem with outer-joins
  486. table index organized ?
  487. Weekend date for given a date
  488. Backup DB2 MVS OS/390 7.2 and Restore to DB2 UDB AIX 8.1.6
  489. Weekend date given a date
  490. How to integrate ForUpdate iterator in Development Center
  491. Floats become decimals when read from a resultset.
  492. Lock Mode QUESTION
  493. UDB 8.1 FP7a / Error DBA 1107
  494. UDB 8.1 FP7a / Error DBA 1107
  495. Online reorg and super exclusive lock cause many problems
  496. Deleted Backups on Control Center
  497. Can I ALTER a column to have a DEFAULT
  498. db2dari processes remaning after db2stop/db2start
  499. Tomcat DB2 connection - No suitable driver
  500. communications error when starting with multiple "nodes"
  501. change log path
  502. licences
  503. Move from Solaris to AIX
  504. Length of Data in CLOB Column
  505. DRDA and accessing a db2 database hosted on Windows 2000 from OS400 V5R2
  506. Is it bad to see "High water mark for database heap = 4291373408" when the server has 4G memory?
  507. DB2 SQL Stored Procedure Build problem
  508. DB2 8.1 installation error
  509. Need to connect to DB2 via a CLIST
  510. aix db2 client
  511. Statement Problem Update
  512. Online SQL query simulation DB2`
  513. any way to obsfucate a stored proc?
  514. Guide to Clustering using Linux and multiple machines
  515. Colocated join question
  516. db2look didnot get all the admin cfg at all
  517. Deleting all Data in a DB
  518. get time in a sp
  519. rollforwaring a database which is NOT is rollforwarding state
  520. How can I resale or return DB2 8 and QMF?
  521. Mystery db2agent Processes
  522. V8.2 - SQL/PL Continue handlers not working?
  523. DB2 8.2 on Linux - Table Functions get_dbm_cfg get_db_cfg
  524. parsing dynamic sql and removing constants
  525. UDB 7.2 DB binary-compatible between OS/2 and Windows?
  526. [IBM][CLI Driver] CLI0112E Erreur d'affectation. SQLSTATE=22005
  527. unixODBC client problems
  528. runaway/zombie fmps slowly starving engine of resources?
  529. Health monitor causing issues!
  530. can't start db2isetup
  531. trigger question
  532. DB2 64-bit fallback to 32-bit
  533. 64-bit to 32-bit fallback
  534. Need DB2 V7 Sample programs for CLOB and BLOB's
  535. JAVA :: Timestamp from DB2
  536. nodes can not be uncataloged
  537. How do i connect UNIX TO UNIX Machines???
  538. How to change a NOT NULL column to allow NULLs?
  539. how to verify
  540. more instances
  541. Apple clients for DB2?
  542. Somewhat obscure Q about clustering
  543. FYI: DB2 UDB V8.2 on the Windows Environment
  544. Bufferpool size Problem
  545. reason code = "54"
  546. Optimizer bad with sparse keys?
  547. 8.2 - recursive sql procedure
  548. DB2 - send mail via SMTP-Server User-ID?
  549. Comparison of DB2 and Oracle?
  550. Error Calling SPROC that returns multiple result sets