View Full Version : answers

Pages : 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 [16] 17 18 19 20 21
  1. REXX routines, zpharma
  2. Data Recovery SOURCE CODE ( SOURCE CODES of Professional Data Recovery Software )
  3. Is it possible to create index for temporary table
  4. Large Data Tablespace Page Allocation
  5. Problem when connecting to DB2 from standalone java application
  6. write-back cache on or off?
  7. Slow odbc connection to AIX DB2
  8. Suggestions for configuring a laptop to learn DB2
  9. Having problems with Timestampdiff
  10. Help! my db2 cann't execute custom function. - db2diag.log (0/1)
  11. error after installing cwbodbc32.dll
  12. Restore Method - Delta and Incremental Backups
  13. authentication
  14. Trigger on update of ANY column?
  15. Difference between DB2 for LUW and DB2 for z/Series
  16. Why a simple select all query uses index scan and not table scan ?
  17. Anyone using Enterprise compiler co-processor (PL/I or COBOL) ???
  18. Need a bit of help with temporary tables
  19. registering UDF from shell script
  20. db2move, problem importing data into table with GENERATED ALWAYS identity column
  21. DB2 Compatibility
  22. DTS data from MS SQL 2000 to DB2 7.1 on OS/390
  23. DTS data from MS SQL 2000 to DB2 7.1 on OS/390
  24. DTS data from MS SQL 2000 to DB2 7.1 on OS/390
  25. IF statements in SQL Table Functions & Bad Plans
  26. Server side default JDBC driver
  27. hi
  28. DB2 ALTER TABLE TO UPDATE A COLUMN FOR NOT NULL
  29. Need Help With SQL Statement
  30. Capturing and restoring views and triggers
  31. stored procedure problems
  32. Configuration Advisor, Several Instances
  33. DB2 certification test
  34. SQLSTATE=58004 on rollforward
  35. can I restore a database from one system to another?
  36. Help with stored procedure execution....
  37. Can I see rewritten SQL?
  38. ERROR:Could not switch current DB2INSTANCE to "db2inst1"
  39. DB2 AVOIDING POLLING
  40. dynamically created column names
  41. DB2 authentication : how it works ?
  42. Incremental backup on DB2 7.2
  43. db2 min, max, count functions are very slow
  44. configuration advisor
  45. DB2NOEXITLIST variable does not seem to work?
  46. More Fixpak7a help - space problem
  47. DB2 OLAP 8.1 with iSeries
  48. version compatibility
  49. DB2 7.2 Z/OS - Functions - Where's the Function source text stored
  50. Install Fixpack 7a and stop Db2fmd
  51. Database replication
  52. Let your customer find fast and easy all text he searches !
  53. cics to db2 connection(attachment)cookbook
  54. DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command.
  55. Backup DB2 UDB 7.x on Linux Restore on Windows?
  56. optimization
  57. worst performing dml
  58. no SQL return code / resource name
  59. Another SQL SP bug or feature
  60. SQL30081N - Need solution for solving this problem - URGENT
  61. Carrer in Data Mining?
  62. multiple instance monitoring
  63. filter systables from ado recordset adSchemaTables (repost)
  64. repost: filter systables from ado recordset adSchemaTables
  65. What is the IBM policy on alternate fixpacks ?
  66. filter systables from ado recordset adSchemaTables (repost)
  67. Strange FP 4 installation Problem (DB2 V 8.1)
  68. Archiving blobs
  69. Reorg fails when associated tablespace size reaches 1Gb
  70. Some Basic Questions.
  71. Static SQL
  72. Why isn't ALLOW REVERSE SCANS the default?
  73. Problems with scheduled tasks (SQL22283N)
  74. MERGE syntax error
  75. multi-row parametters + BLOB
  76. Catologing
  77. Equalent to Statspack for DB2..
  78. Cannot modify procedure created by another user
  79. 390/V7 timestamp column auto updated??
  80. Need for UDB DBA
  81. Good Resource on Explain Plan Format
  82. Raw DMS single- vs. multi-table tablespaces
  83. interpreting encrypted data stored on DB2 using Perl
  84. Select statement return result very slow
  85. filter systables from ado recordset adSchemaTables
  86. How do I take table name from user in UDF
  87. Finding out the membername in DB2/ ZOS DATA sharing env.
  88. Select satement return result very slow
  89. System clock vs. DB2
  90. CALL in Trigger, -746 and the WHEN clause ...
  91. Statement Event Monitor Data
  92. How to compare objects between two database?
  93. DB2 Connect vs. DB2 in an AIX environment
  94. Scheduled tasks never run on time
  95. When does a UOW start on the DB2 Log
  96. CURSOR Keeps Closing
  97. Error SQL1265N
  98. IBM human resources may be stealing from you
  99. DB2 Administrative Server and "discover=KNOWN" setting
  100. Sysbase to Db2.
  101. RID Failures
  102. Remote Instance connectivity issue - DB2 8.2.0 on Windows 2000 Server.
  103. exception handling in db2
  104. Exception handling in db2 UDF
  105. Certification Tutorial for Advanced certification (704)
  106. Certification Tutorial for Advanced certification (704)
  107. Certification Tutorial for Advanced certification (704)
  108. a question on "High performance SQL"
  109. Apparent contention issue with DB2 backup
  110. DB2 under win xp
  111. about auto-commit
  112. Federated Database
  113. Federated Database
  114. Quiesce Database and Logs
  115. How to check data integrity of a DB2 instance?
  116. Need Help With a Load
  117. Date column and table scan
  118. content manager - help
  119. Recover Using INCREMENTAL AUTOMATIC
  120. Recover Using INCREMENTAL AUTOMATIC
  121. Need help with unspecific error
  122. How to get a password in V8.2
  123. Breaking News: MySQL beats Oracle in Benchmark
  124. REBIND fails with SQL0029N
  125. Connection contexts in SQLJ routines
  126. SQL OK in 8.1.0 but not in 8.2 ?
  127. Oracle-mode Firebird
  128. NLS Support in DB2 as a configurable parameter
  129. what is true image?
  130. installation de db2 (V 8.1) sous linux suse
  131. reporting errors in a separate transaction
  132. Informix to DB2 Replication Problems
  133. java invocation of db2 clp
  134. DB2 Syntax for Outer join
  135. SET SESSION AUTHORIZATION
  136. License question
  137. Is db2gncol gone?
  138. Is the DB2 server on the local machine?
  139. db2advis not working in 8.2
  140. agent bufferpool hit ratio
  141. RAID 5 is Killing Performance?
  142. Question on userexits
  143. RAID 5 is Killing Performance?
  144. Joining Multiple Members
  145. New AIX DB2 instance requires new user?
  146. Unlogged Deletes in DB2/390 (or zOS)
  147. Unlogged Deletes in DB2/390 (or zOS)
  148. get/put routine
  149. searching on all fields
  150. Floyd's algorithm in SQL
  151. Informix "foreach execute procedure": converting to DB2
  152. Table display in CC
  153. looking for one good HACMP specialist to implement it in AIX / DB2 environment...
  154. shutdown
  155. maximum size of a database/tablespace
  156. DB2 AIX Create Database fails with Memory Allocation Error
  157. Database Administration Service
  158. Bit & SBCS
  159. db2advis not working in 8.2
  160. Db2 Instance owner and SYSADM authority
  161. how to perform muti byte to single byte conversion in DB2
  162. "Bad container path" during Backup?
  163. DB2 slow response on first connection Win 2003
  164. backup time
  165. differences
  166. Windows - DB2 Command Center - Create Database Wizard starts on its own
  167. time measurement
  168. measure recovery time
  169. UDB 7.2 fp9, dynamic-sql plans with parameter-markers
  170. Information Integrator
  171. Microsoft Access as Frontend for DB2
  172. New JARs (e.g.db2jcc_javax.jar) inside \sqllib\java after Fixpack 7a on DB2 v 8
  173. Problem in using DB2 Type 4 driver
  174. table with 7000 columns
  175. watch db activity
  176. Limit on number of params to an SP?
  177. Task Center From name
  178. 64 bit
  179. Trigger calling INVALID SP - strange behaviour ?
  180. Binary values in the database
  181. which registry variable to set ? (updated from 8.1 to 8.2)
  182. db2 corrupts data while loading from a TXT file
  183. Daily Devotion
  184. how to enable user exit
  185. DB2 Runtime Client
  186. Syntaxic statement coloration in Command Editor ?
  187. reorgchk with display full tablename
  188. I FOUND A SOLUTION OF PROBLEM SQLSTATE=HY011
  189. Lock Situation with a special Sql-Statement
  190. connect to a remote DB2 on z os
  191. Package NULLID.SYSLN304
  192. not logged initially - opinion
  193. DB2 Universal Language support
  194. SQL Query Question
  195. Catalog table used by Client when connecting via ODBC
  196. Mirroring to remote server
  197. Extenders don't support long names?
  198. Extenders don't support long names?
  199. about auto-commit
  200. problem with group by and maximum
  201. Need to rebind??
  202. Installing/configuring DB2 Connect V8.1
  203. DB2 version 8 rename command
  204. ID DB2 IDENTITY columns w/ type 4 JDBC DatabaseMetaData?
  205. Message SQL22212N when trying to run a task
  206. db2Backup API and missing SQL1152
  207. pctfree, pctused & data page
  208. estimate log size of "insert into...select * from..."
  209. Lock Escalation, LogRetain & Backup Question.
  210. Crystal Reports 10 connection to DB2 v7.1
  211. DB2 PREP ... PACKAGE USING ... without implicit binding
  212. script to automate instance connect/catalog in client
  213. I found this great little site
  214. Need Information on DB2 Certification
  215. Top DB Site?
  216. table size question!!
  217. Generating unique
  218. Problems running db2setup on Redhat 3 ws
  219. Defragmentation
  220. restore db
  221. Database Administration Server (DAS) -- is there a stealth or IP lockout feature?
  222. many ports
  223. SQL Null handling in predicate evaluation involving IN
  224. How to get TABLE NAME displayed in SYSPUNCH card.
  225. Building DB2 CLI in Borland C++ on Win2K
  226. Searching SQL-Funktion ...
  227. help with database research topic
  228. subtypes
  229. New "High-performance SQL" article on developerWorks/DB2
  230. dms, index destroyed, pls help
  231. DB2 Development Center
  232. sub select
  233. Universal jdbc driver : version ? and where ?
  234. Urgent: Is DB2 7.2 available for z/os?
  235. UNIQUE INDEX bug when Trailling blanks in VARCHAR column
  236. Unexpected SQL0100W
  237. sql0012w
  238. page size error SQL0286N
  239. Optimizer choosing bad plan?
  240. get server date
  241. How to migrate UDB v7.2.9 to UDB V8.1.5 in MSCS
  242. disable isolation level switch
  243. Problem connecting to database directory after installing fixpack 7a
  244. How do identify the source of Sort Overflow?
  245. Impossible to remove error
  246. Generate DDL works only for 30 tables?
  247. I want to monitor all sql statements
  248. db2 problem restarting WAS 5.1 on linux (intel)
  249. need to view all sql statements
  250. Certification Questions
  251. dynamic SQL from Hibernate and SQLCODE -301
  252. OS2 Warp v4.0 and DB2 v2.1.2 Daylight savings time problem
  253. table update with or without indexes enabled?? 390/V7
  254. LOB insert in CLP?
  255. Need recommendations re a good DB2 backup/recovery tool
  256. db2audit checking
  257. logarchmeth1,logarchmeth2,logarchopt1,logarchopt2
  258. Does 'select 1 from mytable where 1 = 0' do a table scan?
  259. UBD upgrade from vs 7.2 to vs 8.1 causing slow inserts.
  260. Udb Db2 Vs 7.2 Vs 8 Upgrade Resulting In Increased Insert Times
  261. Use of ROWID in DB2 on Z/OS v7.1.1
  262. UDB 8.1 and multiple connections
  263. dms management
  264. Query in Prepared statements caching
  265. rownumber() over - which versions support this
  266. SQL Join question
  267. DB2 CPU USAGE
  268. sp in db2
  269. Unicode DB2 Performance
  270. db2set
  271. V8.2 - SQL/PL Continue handlers not working?
  272. Does anyone have experience with the efficiency of global temporary tables?
  273. Is there a straightforward way to export/import an entire schema in DB2 UDB?
  274. DB2 not using all processors
  275. finding CPU utilization per database or instance
  276. windows CLASSPATH in a Java UDF
  277. DB2 z/OS procedures - Nested Block error in Exception Block
  278. [DB2] Erreur CLI0102E Invalid conversion. SQLSTATE=07006
  279. Session tables problem when used from multiple threads
  280. Determining JDK_PATH
  281. reclaim disk space
  282. rename server when DB2 installed
  283. DMS Tablespaces
  284. What is wrong with SQL syntax
  285. UDF on DB2 V7.2 and AIX V5.2
  286. Lock Mode Question
  287. I-Series DB2 Self-referential constraint issue causing locks
  288. Transaction Logs
  289. Options to set will not be saved under DB2 Console
  290. Index usage
  291. obtaining authority to run list applications - ordinary users
  292. hacmp
  293. please let me know the procedure for doing rollfoward mininum recovery using long talbespaces
  294. Searching DB_PATH
  295. How to kill running procedures.
  296. Take a Look at This ...
  297. production and qa
  298. Question to Independent IT Consultants
  299. create users in db2
  300. Problem with DB2 JDBC driver?
  301. Editions from DB2
  302. victim selection
  303. Log Shipping Issue
  304. what is this supposed to mean?
  305. Scoping out the size needed for running DB2 audit facility
  306. Accuracy of Data in /DDEL of db2dart
  307. How to stop FMC?
  308. Integrate and merge multiple data sources
  309. Problem with Catalog database
  310. Can you Fool DB2
  311. Memory is full
  312. How to delete data from a table quickly
  313. Transpose rows to column
  314. Personal Edition
  315. Stored Procedure commit point
  316. stored procedures problem
  317. PROBLEM WITH CLONING A DB2 SUBSYSTEM MORE THAN 1 HLQ FOR VSAM
  318. V8.2 - How to stop SPs always being explained?
  319. Fixpack 7a
  320. Two questions about "alter table tbname activate not logged initially"
  321. db2advis
  322. db2advis
  323. db2Advis
  324. Migrating from DB2 UDB 6.x on Solaris to UDB 7.2 on Linux
  325. Same query, different access plan in Prod. and Dev.
  326. How to find build level or fixpack level?
  327. DB2 8.1 FP 7 on AMD Opteron
  328. db2 v8 on windows
  329. why should temporary table space page size matter?
  330. /usr/lib64
  331. Fifty Thousand Foot View needed for DB2 audit capabilities
  332. DB2 Explain
  333. Database backup & Schedule problem
  334. Problems with setting up replication
  335. Max length name of a database/schema
  336. Time functions in db2
  337. AddNew Fails when too many fields are added
  338. simple csv export db2 with *column names*
  339. Development center
  340. connecting to the DB2 UDB Windows 2003 Server
  341. SQL-Statment that add to strings
  342. ROW_NUMBER on ZOS/OS390
  343. Import and triggers
  344. Adding a column - Column oder a concern?
  345. Load Problem With MDC Table
  346. DB2 8.1 Client
  347. Kernel Parm Settings for DB2 v7.2 On SuSe 9.1
  348. Help with UDB and MQSeries. Can't use the UDF wizard to create MQ UDFs
  349. Where can I get the DB2 backup/restore errors?
  350. Federated Database: performance problem with outer-joins
  351. table index organized ?
  352. Weekend date for given a date
  353. Backup DB2 MVS OS/390 7.2 and Restore to DB2 UDB AIX 8.1.6
  354. Weekend date given a date
  355. How to integrate ForUpdate iterator in Development Center
  356. Floats become decimals when read from a resultset.
  357. Lock Mode QUESTION
  358. UDB 8.1 FP7a / Error DBA 1107
  359. UDB 8.1 FP7a / Error DBA 1107
  360. Online reorg and super exclusive lock cause many problems
  361. Deleted Backups on Control Center
  362. Can I ALTER a column to have a DEFAULT
  363. db2dari processes remaning after db2stop/db2start
  364. Tomcat DB2 connection - No suitable driver
  365. communications error when starting with multiple "nodes"
  366. change log path
  367. licences
  368. Move from Solaris to AIX
  369. Length of Data in CLOB Column
  370. DRDA and accessing a db2 database hosted on Windows 2000 from OS400 V5R2
  371. Is it bad to see "High water mark for database heap = 4291373408" when the server has 4G memory?
  372. DB2 SQL Stored Procedure Build problem
  373. DB2 8.1 installation error
  374. Need to connect to DB2 via a CLIST
  375. aix db2 client
  376. Statement Problem Update
  377. Online SQL query simulation DB2`
  378. any way to obsfucate a stored proc?
  379. Guide to Clustering using Linux and multiple machines
  380. Colocated join question
  381. db2look didnot get all the admin cfg at all
  382. Deleting all Data in a DB
  383. get time in a sp
  384. rollforwaring a database which is NOT is rollforwarding state
  385. How can I resale or return DB2 8 and QMF?
  386. Mystery db2agent Processes
  387. V8.2 - SQL/PL Continue handlers not working?
  388. DB2 8.2 on Linux - Table Functions get_dbm_cfg get_db_cfg
  389. parsing dynamic sql and removing constants
  390. UDB 7.2 DB binary-compatible between OS/2 and Windows?
  391. [IBM][CLI Driver] CLI0112E Erreur d'affectation. SQLSTATE=22005
  392. unixODBC client problems
  393. runaway/zombie fmps slowly starving engine of resources?
  394. Health monitor causing issues!
  395. can't start db2isetup
  396. trigger question
  397. DB2 64-bit fallback to 32-bit
  398. 64-bit to 32-bit fallback
  399. JAVA :: Timestamp from DB2
  400. Need DB2 V7 Sample programs for CLOB and BLOB's
  401. nodes can not be uncataloged
  402. How do i connect UNIX TO UNIX Machines???
  403. How to change a NOT NULL column to allow NULLs?
  404. how to verify
  405. more instances
  406. Apple clients for DB2?
  407. Somewhat obscure Q about clustering
  408. FYI: DB2 UDB V8.2 on the Windows Environment
  409. Bufferpool size Problem
  410. reason code = "54"
  411. Optimizer bad with sparse keys?
  412. 8.2 - recursive sql procedure
  413. DB2 - send mail via SMTP-Server User-ID?
  414. Comparison of DB2 and Oracle?
  415. Error Calling SPROC that returns multiple result sets
  416. runtime.zip and Dev Center
  417. What Next ? A Google DB Engine :)
  418. Automatic Client Reroute with Type 4 Driver
  419. 8.2 registry differences
  420. Help w/ stored proc creation - extract only numeric from alphanumeric
  421. database in an inconsistent status when doing DB2DART
  422. DB2 Linux - AIO and DIO questions
  423. restart replication on new database copied from old database without full refresh
  424. Alert or Preventing data entry?
  425. Warning message in Linux db2 8
  426. Automatic RUNSTATS in 8.2
  427. security holes that have been found.
  428. Row Locking Problem
  429. pagesize increase or longvarchar
  430. Runstats Command Question
  431. Dot in usernames
  432. Using Blue Phoenix for VSE->z/OS?
  433. v8.1 authentication question
  434. Information Integrator 8.2 Download ?
  435. DB2CONNECT "DIA3202C The TCP/IP "
  436. Using a lot of sequences
  437. CAST function and performance
  438. XML Extender result rows prefixed with the <prolog> and <doctype>
  439. Restoring DB's without Backup?
  440. Two Way Replicaiton
  441. Loading Long Varchar for Bit Data
  442. UDF with exception handler possible ?
  443. multiple instances
  444. Does DB2 support inline views?
  445. Help using columns from Left Outer Join in query
  446. Query help - MIN
  447. Very Basic Question: What is the DB2 Admin. Server (DAS) used for and is it ...
  448. How to convert this Oracle SQL(CONNECT BY) to DB2 SQL
  449. View permissions
  450. GRAPHIC and VARGRAPHIC encoding
  451. Copy structure
  452. error with db2udp.dll on db2 version 7
  453. Does DB2 sort an empty resultset?
  454. What does the error (Reason "Can not enforced Maxcard > 1".) mean
  455. "releasing" unused tablespace pages
  456. How to specify column header titles in a SQL CREATE TABLE statement?
  457. stored procedure runs on udb8 but not version 7
  458. An issue with UPDATE via UNION ALL view
  459. How to change Tasks from using local id to domain id?
  460. Row table locked
  461. Java on iSeries: setBinaryStream problem
  462. Cannot create database....SQL1225N
  463. How to get structure of temporary table ?
  464. DB2 Design Advisor with huge workload?
  465. get the right side of string ?
  466. continue handler question
  467. Deadlock on a Prepare?
  468. how good is the information from EXPLAIN?
  469. db2 snapshot database log information
  470. Problems changing the IP address of a W2K3 system with 8.2
  471. .NET integration and development - best version of DB2 to use, tools, etc?
  472. DB2 install on Gentoo Linux
  473. INSERT INTO .. SELECT with BLOB columns
  474. Maximum length for table names, colums etc.
  475. DB2 DBA for UNIX and DB2 DBA for OS/390
  476. SQL correlated subqueries
  477. Calculation of seconds for a month
  478. Redirected restore
  479. DB2 Connect version needed for DB2 v6.1 (Mainframe)
  480. Replacement CD?
  481. SYSCOLUMNS - COLTYPE or TYPENAME?
  482. DBHEAP configuration for buffer pool size
  483. Backup ok but restore not working
  484. Failed SQL statedment w/DB2
  485. Design advisor feedback
  486. Where is the "bit data" flag in the System Tables?
  487. Executed SQL-statements in a logfile?
  488. V8.2 Trigger - NEXTVAL FOR seq -- behaviour change?
  489. how to set variable using dynamic sql
  490. how to set variable using dynamic sql
  491. Merge does not work on 8.1.0
  492. Do u often use OODB?
  493. How many pre-decimal positions/integer digits has a DECimal (5,3) defined field ?
  494. Transferring ODBC Connections from one PC to another
  495. UDB V8.1 Feature
  496. Copy of database
  497. Page fault during backup
  498. CALL in TRIGGER and SQLCODE -746
  499. ordering a long varchar column
  500. Computed columns in DB2
  501. Problems with incremental backup UDB 8.1
  502. Problem with a view
  503. Application Development Client and XP SP2?
  504. SQLCancel not working with UDB?
  505. DB2 V8.1 does not accept the adDBTimeStamp data type
  506. DIA500C in db2diag.log
  507. DB2 Vulnerabilities
  508. Good DB2 book?
  509. db2cc fails on 64 bit AIX 5.2
  510. Proc Language in 8.2
  511. Average Num of Active Connections On DB2 Instance/ Small NUM_POOLAGENTS
  512. Two different versions on DB2 on Window box?
  513. Problem with a simple union
  514. CPU usage in connection concentrator
  515. Parallel incremental index build during load operation
  516. db2.->pam ldap -> edirectory
  517. Arithmetic overflow/other exception - what to do to find the source?
  518. DB2CC and XP SP2
  519. db2 -> AS400 (sql statment error)
  520. copy a db2/zos table with a blob column
  521. two phase commit?
  522. getting a com.ibm.db2.jcc.a.SqlException
  523. Finding locks
  524. db2 import and microsoft host integration server
  525. db2 - indexes
  526. Help with like predicate in update trigger
  527. ?example after insert trigger doing update on inserted row?
  528. SQL help
  529. Problems installing DB2 Contol Center.
  530. simulating ldap with db2?
  531. container recovery
  532. SQL10004C error
  533. How do I redirect ouptut from the List Database Directory command from DB2 CLP on AIX to a file?
  534. Calling a stored procedure from a trigger in DB2 V7.2 FP10
  535. Create a cursor and fill it dynamically
  536. how to drop constraints within a table
  537. Using sequences from external programms
  538. varchar vs char
  539. the market value of SQLJ
  540. Database Manager agent configuration
  541. DB2 Connection Pooling
  542. ruminating on 390 performance vs. VSAM
  543. db2syscs.exe CPU usage 100% & db2empfca failing
  544. DB2 UK Education Conference (16th / 17th November 2004)
  545. See the good, the bad, and the ugly of your DB2 data with OneClickRevelation(tm)
  546. End of service for V7.2??
  547. Checksums question.
  548. v8 FP 6 Affect on Data Warehouse Center
  549. set integrity after load
  550. V8: Difference between FP7 and FP7a?