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. Apple clients for DB2?
  2. Somewhat obscure Q about clustering
  3. FYI: DB2 UDB V8.2 on the Windows Environment
  4. Bufferpool size Problem
  5. reason code = "54"
  6. Optimizer bad with sparse keys?
  7. 8.2 - recursive sql procedure
  8. DB2 - send mail via SMTP-Server User-ID?
  9. Comparison of DB2 and Oracle?
  10. Error Calling SPROC that returns multiple result sets
  11. and Dev Center
  12. What Next ? A Google DB Engine :)
  13. Automatic Client Reroute with Type 4 Driver
  14. 8.2 registry differences
  15. Help w/ stored proc creation - extract only numeric from alphanumeric
  16. database in an inconsistent status when doing DB2DART
  17. DB2 Linux - AIO and DIO questions
  18. restart replication on new database copied from old database without full refresh
  19. Alert or Preventing data entry?
  20. Warning message in Linux db2 8
  21. Automatic RUNSTATS in 8.2
  22. security holes that have been found.
  23. Row Locking Problem
  24. pagesize increase or longvarchar
  25. Runstats Command Question
  26. Dot in usernames
  27. Using Blue Phoenix for VSE->z/OS?
  28. v8.1 authentication question
  29. Information Integrator 8.2 Download ?
  30. DB2CONNECT "DIA3202C The TCP/IP "
  31. Using a lot of sequences
  32. CAST function and performance
  33. XML Extender result rows prefixed with the <prolog> and <doctype>
  34. Restoring DB's without Backup?
  35. Two Way Replicaiton
  36. Loading Long Varchar for Bit Data
  37. multiple instances
  38. UDF with exception handler possible ?
  39. Does DB2 support inline views?
  40. Help using columns from Left Outer Join in query
  41. Query help - MIN
  42. Very Basic Question: What is the DB2 Admin. Server (DAS) used for and is it ...
  43. How to convert this Oracle SQL(CONNECT BY) to DB2 SQL
  44. View permissions
  45. GRAPHIC and VARGRAPHIC encoding
  46. Copy structure
  47. error with db2udp.dll on db2 version 7
  48. Does DB2 sort an empty resultset?
  49. What does the error (Reason "Can not enforced Maxcard > 1".) mean
  50. "releasing" unused tablespace pages
  51. How to specify column header titles in a SQL CREATE TABLE statement?
  52. stored procedure runs on udb8 but not version 7
  53. An issue with UPDATE via UNION ALL view
  54. How to change Tasks from using local id to domain id?
  55. Row table locked
  56. Java on iSeries: setBinaryStream problem
  57. Cannot create database....SQL1225N
  58. How to get structure of temporary table ?
  59. DB2 Design Advisor with huge workload?
  60. get the right side of string ?
  61. continue handler question
  62. Deadlock on a Prepare?
  63. how good is the information from EXPLAIN?
  64. db2 snapshot database log information
  65. Problems changing the IP address of a W2K3 system with 8.2
  66. .NET integration and development - best version of DB2 to use, tools, etc?
  67. DB2 install on Gentoo Linux
  68. INSERT INTO .. SELECT with BLOB columns
  69. Maximum length for table names, colums etc.
  70. DB2 DBA for UNIX and DB2 DBA for OS/390
  71. SQL correlated subqueries
  72. Calculation of seconds for a month
  73. Redirected restore
  74. DB2 Connect version needed for DB2 v6.1 (Mainframe)
  75. Replacement CD?
  77. DBHEAP configuration for buffer pool size
  78. Backup ok but restore not working
  79. Failed SQL statedment w/DB2
  80. Design advisor feedback
  81. Where is the "bit data" flag in the System Tables?
  82. Executed SQL-statements in a logfile?
  83. V8.2 Trigger - NEXTVAL FOR seq -- behaviour change?
  84. how to set variable using dynamic sql
  85. how to set variable using dynamic sql
  86. Merge does not work on 8.1.0
  87. Do u often use OODB?
  88. How many pre-decimal positions/integer digits has a DECimal (5,3) defined field ?
  89. Transferring ODBC Connections from one PC to another
  90. UDB V8.1 Feature
  91. Copy of database
  92. Page fault during backup
  93. CALL in TRIGGER and SQLCODE -746
  94. ordering a long varchar column
  95. Computed columns in DB2
  96. Problems with incremental backup UDB 8.1
  97. Problem with a view
  98. Application Development Client and XP SP2?
  99. SQLCancel not working with UDB?
  100. DB2 V8.1 does not accept the adDBTimeStamp data type
  101. DIA500C in db2diag.log
  102. DB2 Vulnerabilities
  103. Good DB2 book?
  104. db2cc fails on 64 bit AIX 5.2
  105. Proc Language in 8.2
  106. Average Num of Active Connections On DB2 Instance/ Small NUM_POOLAGENTS
  107. Two different versions on DB2 on Window box?
  108. Problem with a simple union
  109. CPU usage in connection concentrator
  110. Parallel incremental index build during load operation
  111. db2.->pam ldap -> edirectory
  112. Arithmetic overflow/other exception - what to do to find the source?
  113. DB2CC and XP SP2
  114. db2 -> AS400 (sql statment error)
  115. copy a db2/zos table with a blob column
  116. two phase commit?
  117. getting a
  118. Finding locks
  119. db2 import and microsoft host integration server
  120. db2 - indexes
  121. Help with like predicate in update trigger
  122. ?example after insert trigger doing update on inserted row?
  123. SQL help
  124. Problems installing DB2 Contol Center.
  125. simulating ldap with db2?
  126. container recovery
  127. SQL10004C error
  128. How do I redirect ouptut from the List Database Directory command from DB2 CLP on AIX to a file?
  129. Calling a stored procedure from a trigger in DB2 V7.2 FP10
  130. Create a cursor and fill it dynamically
  131. how to drop constraints within a table
  132. Using sequences from external programms
  133. varchar vs char
  134. the market value of SQLJ
  135. Database Manager agent configuration
  136. DB2 Connection Pooling
  137. ruminating on 390 performance vs. VSAM
  138. db2syscs.exe CPU usage 100% & db2empfca failing
  139. DB2 UK Education Conference (16th / 17th November 2004)
  140. See the good, the bad, and the ugly of your DB2 data with OneClickRevelation(tm)
  141. End of service for V7.2??
  142. Checksums question.
  143. set integrity after load
  144. v8 FP 6 Affect on Data Warehouse Center
  145. V8: Difference between FP7 and FP7a?
  146. Lock-waits don't get logged ... but
  147. Basic DB2 transaction diagnosis question
  148. Rollforward after online backup
  149. IDUG 2004 - Europe Hosts Industry Leading Vendors
  150. date format in snapshots
  151. development center build fails
  152. SQLException on
  153. v8.1 Alternate FP7 installation quesiton
  154. Database release level a.00
  155. Where has Fixpack 6 gone ?
  156. Missing dll
  157. serial equivalent in DB2
  158. SQL help
  159. SYSPROC.SYSINSTALLOBJECTS not found in one DB but exist in another DB in the same instance
  160. DB2 version without connection
  161. V7.2, Linux - Join between multiple DB
  162. Replacing a function referenced in a view
  163. Avoiding Table Scan on Update with correlated subselect
  164. collect sub-element statistics
  165. snapshot on all db partitions
  166. Does IBMJava2-SDK-1.4.2-0.0 work with DB2 8.2?
  167. LOAD via a Stored Procedure
  168. DB2 hangs...(7.2)
  169. Ruined my dear db2
  170. Deadlocking in Java program
  171. qmf - alternative query columns
  172. No double quote in UDB Export DEL file
  173. Adding a generated column
  174. INT. Entertainment Company in S. California needs Data Warehouse Specialist
  175. Database Physical Location in UDB 8.1
  176. Accessing DB2 database via Java?
  177. Cannot create view using jdbc
  178. SPs from Triggers in V8.2 - Performance?
  179. Using "load" to migrate a database to db2
  180. DB2 ver 5.2 and windows 2003 server
  181. Build java stored procedure error
  182. High Execution Time--Low CPU time for statements
  183. DB2 Locking Scheme Problem.
  184. updating table from temp table
  185. SQL Question
  186. CCSID problem on iDB2DataAdapter
  187. Opening more than 1 table via the iDB2DataAdapter
  188. Openings in Chennai for DB2 DBA Professionals
  189. Opening for TPF/ALCS Professionals
  190. Need DB2/AS400 consultant in Silicon Valley
  191. Need DB2/AS400 consultant in Silicon Valley
  192. Any tool to monitor db2diag.log?
  193. Any tool to monitor db2diag.log?
  194. RUNSTATS from SQL for UDB
  195. backup log on DB2 6 to TSM
  196. How to delete tables completely?
  197. Alter column from NOT NULL to NULL
  198. load needs more than 1 second per table for empty tables
  199. Temporary Space during LOAD
  200. Is there a way to add new item in health indicator.
  201. Syantax support
  202. db2sql92 segmentation fault
  203. DB2 8.1, Copy Stored Proc's from one db to
  204. Embedded SQL and Multithreading Question on 8.1.5
  205. restore to another machine fialed
  206. restore database to another server failed
  207. date formatting to use in stored procedures
  208. casting and padding problem
  209. Installation : An Error Has Occured. DER!
  210. INSTALL HELP.....AIX 4.3.3
  211. What is the overhead for the backup compress option ?
  212. DB2 Clob Serach case insensitive
  213. help! install DB2 On Redhat9 Segmentation Fault
  214. Net Search Extender Problems
  215. Is Stinger downloadable yet?
  216. Two New Versions of the Perl DBD::DB2 Driver Released
  217. Very slow delete using GUI
  218. DB2 V8.1 + W2K: Connection to local DB with domain user not possible
  219. IBM Support for DB2 V8 FP4
  220. How to avoid hash loops
  221. IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager Express Edition v1.3.2 Win, IBM Tivoli System Automati
  222. IBM DB2 ODBC-driver for download
  223. EXPORT problem
  224. Running a HADR script outside of the HADR Wizard
  225. DB2 Catalog tables poster?
  226. ERROR [40003] [IBM][CLI Driver] SQL30081N A communication error has been detected. Communic
  227. How to delete sequences
  228. DB2 UDB LUW: values current groups?
  229. DB2 Connect install problem
  230. DB2 8.2 (FP7 upgrade)
  231. Change schema name
  232. export IBM UDB (7.2) database into DB2 Mainframe
  233. Needing db2 udb version 6.5 or 7.x for windows (desesperately)
  234. V8 DPF feature and instance creation
  236. UDB Gui Tools
  237. Client connection crash and Rollback..
  238. Clustering two instances on one server
  239. DB8.1 - FP7 trouble ...
  240. DB2 Replication having slow apply (update) at the target server
  241. RI drop performance gains issue
  242. combine db2uext2.cdisk & db2uext2.ctsm together?
  243. SQLStatistics driver bug?
  244. Question Regarding Auto Increment Field
  245. Opinion on most stable release
  246. tablespace container design
  247. How to backup and restore from tape device
  248. accessing multiple schemas -- 390 & cobol
  249. DB2 8.1.5 SQL1224N Error
  250. URGENT SQL help
  251. How can I force DB2 to advance to next logical log?
  252. Is there a restriction for an index creation?
  253. using a stored procedure to compare tables
  254. Tablespace Offline / Corrupt Quandry
  255. Temporary table performance problem on UDB 8 on Linux
  256. Cant find sequences...
  257. How to get specified between dates
  258. "where not in " doesn't work
  259. Problem with redirected restore
  260. budgeting for a new database?
  261. DB2 UDB configured to run at least near optimally at what percentage of sites?
  262. Anything newer than DB2 version 5 client
  263. Calling COBOL sub-routines from Stored procedures written in SQL
  264. Switch from Oracle to DB2
  265. Finally: SQL procedure tracing
  266.<clinit>(Unknown Source)
  267. DB2 equiv. to setDefaultFixedString [oracle]
  268. MLN: alter bufferpool on subset of MLNs
  269. DB2 Replication and updates
  270. Client Access screen does not respond, system request no problem
  271. quick question: Stinger and FP7 the same?
  272. Creating Function refering to sequence
  273. Converting Stored Process to other DBMS?
  274. Disappointed with IBM's new APAR search engine
  275. SQL2000 linked server with new 5.3 Client Tools
  276. SQL how to
  277. How do I get DB2 to know I have a C compiler?
  278. New DB2 responsibilities
  279. DB2 1.2 - Plea for help
  281. user defined function
  282. uninstall cube views code ???
  283. Control Center access across firewall
  284. Tablespaces on backup image (UDB v8.1)
  285. questions on udf_mem_sz.
  286. "Package Cache Overflow" in db2diag.log?
  287. Database Log-file
  288. DB2-PHP Memory problem
  289. Dynamic SQL - "MERGE INTO......"
  290. SQL -2650 when running Capture
  291. Create concatenated string from a result set using SQL
  292. Upgrade AIX
  293. IDUG 2004 Europe 11-14 October 2004 Prague, Czech Republic
  294. i18n'ed Character Set in DBMS and tables
  295. db2start : error ...
  296. Numerous Very Small Log Files
  297. FP7 size on linux
  298. VIRTUALIZATION ENGINE CONSOLE A RUNTIME 1.1 - IBM (3 CDs), WEBSPHERE BUSINESS INTEGRATION CONNECT ADVANCED v4.2.2 - IBM, other 16,000 more CDs, [ no dongles, no activations, etc ... needed ! ]
  299. confusion with number of processors using ESE
  300. Loading data from a .DAT file
  301. Doubt About Unix server Authentication
  302. DB2 data locked away forever?
  303. remote access on the same instance
  304. used pages increase after deleting and loading again
  305. db2licm
  306. DB2 8 + DB2 7, Can they co-exist??
  307. Data Warehouse Specialist - S. California
  308. howto keep two db2 in sync ?
  309. CCA3061N error connecting to new databased only
  310. Using a response file to restore a UDB v7.2 server on a new box
  311. Client connection fails with SQL0973N Not enough storage in MON_HEAP_SZ
  312. Extremely slow Administrative Server
  313. DB2 UDB 64-bits
  314. Moving from AIX to Windows
  315. SQLCODE error when trying to access temporary table
  316. update transmogrifies to insert/delete
  317. Size of indexes in a particular tablespace?
  318. Redirected Restore
  319. catalog cache heap question
  320. recursive queries
  321. db2cctr will not initialize if XP SP2 is installed
  322. Please HELP .. instance crash ver 8.2
  323. V8.1 FP7
  324. query
  325. DB2 UDB LUW: (c1,c2) = ('10000','01/16/2004'): OK ( c1,c2) >= ('10000','01/16/2004'): NOK
  326. Sorting
  327. How many memory for the connect gateway with 10.000 connect users
  328. db2iupdt
  329. Bind Needed for remote remote PC Access to DB2 for OS/390
  330. SP problem: SQL0727N with type "1". and SQLCODE "-551", SQLSTATE "42501"
  331. Stinger server vs. FP6 admin client compatibility
  332. db2advis in DB2 Version 8 Fixpax 7
  333. more thoughts on 8.2
  334. problem converting DOUBLE to CHAR
  335. fyi load csv file from windows
  336. connect UDB V8 client to 390 V6 instance
  337. URGENT - DB2 Client 8.1.2?
  338. bufferpool content
  339. Db2 v5.2 on NT4 crashed
  340. DB2 8.1 ESE Win32 installation problem
  341. 8.2 maintenance wizard ??
  342. Snapshot Missing Dynamic SQL Total Execution Time
  343. current user id
  344. DB2 connection Pooling
  345. federation problems
  346. federation problems
  347. Db2 load API options
  348. debugger options not showing up in develpment centre
  349. DB2 DLFM
  350. sqlj.install_jar problem on both Solaris and Linux
  351. DB2 Stored Procedures and Dynamic SQL returning a Result Set
  352. db2expln and federated
  353. db2 vs oracle
  354. Beef with 8.1 Information Center
  355. Create database from a client
  356. Backup and Export
  357. Backup Performance
  358. Anybody Using Power4 or Power5 platforms?
  359. Determine Database Name or Instance Name from SQL in DB2
  360. debugging options don't show up for SQL stored procedures
  361. LEFT OUTER JOIN's possible in DB2?
  362. SQLCODE -817
  363. How to uninstall DB2 Connect v. 7?
  364. DB2 SQL Procedural Language Outside Procedure
  365. db2cctr - trap under Win XP SP2
  366. Using Transactions to Insert Data to Db2 Database
  367. slow connections with DB2DataSource
  368. unexpected result from COALESCE
  369. db2_all : escape * ' ( " in ksh
  370. Need Updated List of DB2 CLI PATCH2 Keyword Values
  371. Identity column Equivalent for DB2?
  372. DB2 V8 Fixpack 7 (akaV8.2)
  373. Not more than 5 Threads
  374. application status question
  375. SQL Server inked server to as400 - for the love of god please help.
  376. DB2 V8 FP7 problem
  377. DB2 UDB Error Message
  378. DB2 ContentManager Windows Programming App. Search Method
  379. nested select question
  380. as400 and sql via ODBC
  381. PHP - DB2 weird error while refreshing page
  382. Java Stored procedures 8.1.6
  384. DB2 V7 z/OS and ODBC CLI optimization
  385. Check temporary table existing
  386. Search Criteria for Windows Programming
  387. load with "allow read access" gives -911 on UDB v8 FP 5 on AIX
  388. query timeout
  389. Huge estimated cost for a simple delete statement with cascade
  390. Snapshot function?
  391. Deletes way slower on AIX, two questions
  392. DB2 READLIMIT parameter : where is it documented ?
  393. list database partition......
  394. DB2 8.01 - need help with deadlock problem (Event Monitor Log Attached)
  395. Proc1 result set with proc2
  396. DB2 v8 performance improvement for Stored Proc resolution
  397. db2 function error! help
  398. Direct Access Without Index ?
  399. db2diag.log not writing
  400. DBA command
  401. Catalog Cache vs. Buffer Pool for SYSCATSPACE
  402. Catalog Cache vs. Buffer Pool for SYSCATSPACE
  403. order by issue
  404. Intermittant user authentication error
  405. Bind Error while using ALIAS on VIEW with other owner (DB2 OS/390)
  406. SQL0407N occurs when binding files from older version (DB2 v7.2 @ OS/2)
  407. DB2 UDB 8.1 Exam 700
  408. Catalog Cache Overflow
  409. Runstats manipulation
  410. Setup for MQSeries functions
  411. Statement event monitor doesnt report statement text
  412. Latest version number on Windows?
  413. problem using java packages in jdbc stored procedures
  415. Scratchpad in SQL UDF
  416. db2licd stopping
  417. iODBC vs unixODBC ?
  418. Stored Procedure
  419. Stored procedure question
  420. EEE partitions process performance are different
  421. Dynamic SQL in UDF
  422. db2eventlog.000
  423. SQL0444 received when executing a stored procedure
  424. static and dynamic SQL
  425. DB2 Runtime Client Lite Installation Problems
  426. Prefetchers
  427. Log arhiving Frequency (Rule of thumb)
  428. Solaris kernel parm sd_max_throttle
  429. OK, Based on the few responses I got, TSM is not a problem in other shops? Really?
  430. Java UDF problem
  431. DB2 v8 32 bit on Solaris 64 bit
  432. db2 fixpak overwriting symbolic link
  433. looking for db2 expert 8.1 win2003 or win2000
  434. backup/restore nTs data
  435. Thanks!
  436. Locale issue with db2
  437. how to set/configure ip for DB2 on windows for remote JDBC
  439. Oracle to DB2 Migration issues
  440. Severe memory problem with V8
  441. Linked DB2 table in MSAccess 2000 shows #Deleted on every record
  442. How to change a column name.
  443. Reading sql script - newbe question
  444. Use of 'LIKE' in SQL 'WHERE' statement in Batch COBOL program
  445. encryption data with replication
  446. JDBC Error
  447. migrate DB2 table to MS SQL server with GIF fields
  448. DB2 V7.2 fixpak 12 / UTF-8 db doing extra Unicode -> UTF-8 conversion on client?
  449. Issues with Index, Full Scans instead
  450. CA issues million dollar challenge to open source community
  451. Passing data from one stored procedure to another
  452. Insert is slow are there tweaks?
  453. Obese Table
  454. TSM Troubles
  455. can no longer view APARS
  456. ROWID Equivalent
  457. connection error from .net to as400 db2 database
  458. ODBC from Linux
  459. sql update from stage tables with two column keys db2 V8
  460. Compile tool for procedure builder in windows
  461. Cannot create an instance after deinstall DB2. Was told the instance already exists
  462. Logging speed.
  463. Perl and DB2 Stored Procedures
  464. UDB8.2 - Debugging SQL Procedures
  465. about the system temporary tablespace
  466. Need to improve my stored procedure , your comments are welcome!!
  467. DB2MOVE problem between AIX and Windows
  468. Many Direct Writes to SYSCATSPACE, and each very slow.
  469. problem setting up a client
  470. applname in db2 govenor cfg
  471. Online migration of a DB2 table across tablespaces
  472. db2fmp process
  473. Corrupted connections using DB2 Gateway
  474. Coarsification of colums: not generated colums but row-value constructors in DB2 UDB
  475. Getting IBMdadb2 error : Access Denied when configuring linked server in sql2000
  476. sqlurlog question
  477. Tivoli - News groups?
  478. Backup db to TSM only use one session
  480. HELP - Need to connect to DB2 database on AIX from NT server. Also AS/400 from NT Server
  481. set integrity and testing DATE format
  482. Can I use a sub query to define the contents of the FROM clause of a query?
  483. Nested SP:s and result sets
  484. Cursor Not In Prepared State
  485. looking for a sql editor
  486. Help with group by
  487. limiting number of rows returned in a cursor select
  488. Creating a sequence alias
  489. UPDATE problem
  490. /job/ DB2 UDB warehouse manager (former Visual Warehouse)...
  491. Single table restore
  492. 911 deadlock
  493. Partitioning In DB2
  494. some health indicator questions
  495. JOINS
  496. DB2 on Network Mounted Filesystems (Linux) ...
  497. reorg using system temporary table space for table in tablespaceswith variable page size
  498. create table .... not logged initially error or not?
  500. Performance problem on Linux
  501. DB2 UDB LUW: Upgrade all type-1 in indices to type-2, check (afterwards)
  502. Trigger error ....
  503. backup consideration
  504. How to fix an extremely slow restore
  505. MS SQL stored proc., linked server, DB2, incomplete txfrs
  507. Concurrent I/O on Aix: When?
  508. how to release locks when the application ends with error
  509. Very important table (partition) design question: DB2 UDB EEE V8.1 on AIX 5.2
  510. db2diag error
  511. Application heap size
  512. DB2 on Windows or Linux ?
  513. How can I know to which column a null value has been assigned? (SQL0407N)
  514. C Stored Procedure error SQL0444N
  515. db2 replication
  516. SQL SP ....
  517. update statement
  518. Copying data between databases
  519. Why SQL2036N error (path not valid) when Load utility uses SMB networkdrive as source ?
  520. Odd query hang
  521. SQL Question, Stored Procedure
  522. Instead of Trigger results into SQL1424N
  523. Video extender - Java samples?
  524. db2look question
  525. generated by default or as always
  526. Debugging Stored Procedures
  527. Client Configuration Information
  528. JDBC: How to determine an invalid connection
  529. SQL-procedure-statement ....
  530. OUTER JOIN problem
  531. Mass copy data from db2 in OS/390 to udb db2 running NT
  532. SQL join/UNIQUE question?
  533. Arnold Schwarzenegger loses Recall Vote and returns to full-time body building, only to finish 2nd in Mr. Galaxy to Pat Paulsen.
  534. stored procs in cobol?
  535. DB2 Admin client failing
  536. LOB Locator Limit Exceeded
  537. installing DB2 on Linux
  538. Arnold Schwarzenegger Commits Suicide
  539. Adminclient ...
  540. lock escalation question
  541. IBM DB2 Personal Connect
  542. Creating Aliases across Databeses in an Instance
  543. Problem with procedure ...
  544. Delay between SQL statements in DB2
  545. NSE index updating problem
  546. DB2 Admin client failing
  547. Why does FETCH FIRST slow down query?
  548. lock conversion U-Locks
  549. Indexing mode "autoselect"
  550. CLI problem