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