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