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