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