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