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