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. Looking for Experiences Running DB2 for OLTP Database (>300GB)
  2. Oracle Net VS DB2 Connect
  3. "Connection is dead" on ODBC insert of decimal into DB2
  4. DB2Connect - JDBC Problem
  5. Linux db2 memory limit
  6. EXPLAIN - Influencing the Optimizer
  7. big difference for the query time cost
  8. Unloading LOBs on DB2 v7.1 on OS/390
  9. Error CLI0129E and use of CLIPKG
  10. DB2 equivalent to Oracle:Trace or SQL Profiler?
  11. certification/validation resp. stability of IBM DB2 UDB for state-of-the-art linux distributions (eg. suse 9.0 professional)
  12. Regarding Online Backup logs
  13. db2-php on linux
  14. Admin API equivalent to "db2 terminate"
  15. Serious DB2 error
  16. SQL1224N A database agent could not be started to service a request
  17. AIXupgrade with Db2/SAP
  18. Severe Problem using JDBC PreparedStatement with IBM DB2 Universal JDBC Driver as Type 4
  19. store binary data in db2
  20. SQL30020N return code 1245 when accessing db2 VM db via .asp
  21. DB2 DASD Storage (MVS)
  22. 64GB limit for 4k page sized tablespace
  23. Trial & beta version limitations?
  24. Does this newsgroup also cover DB2E?
  25. DB2 physical layout - comments needed
  26. Express edition and Novell
  27. drop tablespace in 390
  28. OLEDB and Dates and Timestamps
  29. Upgrade for DB2 7.2 Workgroup edition?
  30. UDB Logging Strategy ?
  31. SQL7032N Store Procedure is not created
  32. Security implications of using set current sqlid
  33. character-based Windows DB2 interface? Recommendations?
  34. Using single processor license on multiprocessor machine
  35. Restore of tablespace
  36. sms tablespace: decrease Size
  37. How does DB2's estimate size tool calculate avg row size when the table is empty?
  38. "USE" statement in AS/400 DB2 SQL
  39. "USE" statement in AS/400 DB2 SQL
  40. Does changing computer name impact WAS ?
  41. Can't get stock Mandrake 9.2 PHP to connect
  42. Parallel tasks during DB2 for Z/OS Copy
  43. LOB SMS file segment allocation increases exponential means more fragmentation?
  44. DB2 Database Uptime
  45. DBCS enabling in DB2
  46. EXT3 as problemsaver
  47. DB2/UDB 7.2EE , db2 admin user db2xy1 password change timing under AIX
  48. When $INSTHOME/sqllib is created and populated?
  50. Authentication at Instance Vs Authentication at Database
  51. Simple FORCE APPLICATION question....
  52. Help with DB2 Client for Linux
  53. Row Number or subset of select.
  54. Maximum number of connections per user
  55. Restore Error - SQL1035N The database is currently in use
  56. Error in db2diag.log V8.1 FP4
  57. Too many items in IN clause?
  58. Identity OR sequence which is better
  59. Database backup in V8
  60. UDB 7.2, LDAP and ODBC Data Sources on Client
  61. page was victimized
  62. Cannot run scripts from Script Center
  63. Missing Summary tables after Restore
  64. Issues with LEFT JOIN through ODBC iclient Access
  65. Error using autoloader config file in V8
  66. DB2 Command Question
  67. Intra-parallelism Parameters
  68. Passing a java array in to a DB2 stored procedure
  69. DB2 FP4, BackupCompression
  70. DB2/UDB 8.1 (64bit) restore to DB2/UDB 7.2EE (64 bit) under AIX
  71. UDB Query
  72. Getting Offset error
  73. db2mtrk
  74. Error running db2 utilities on ZOS
  75. referred more than once in access plan means?
  76. Index on CHAR(N) FOR BIT DATA?
  77. db2 db2wa.war deployment on websphere.
  78. Better index access = worse performance??
  79. unable to get result data using php
  80. FP backout
  81. views and db2look
  82. DB2 capabilities
  84. How to check Application Client installed or not in Solaris?
  85. Can not uninstall DB2 V8.1 FP4 under Windows 2003 Server.
  86. Windows query tool for DB2/400
  87. Unable to allocate new pages in table space
  88. DB2 Stored Procedure in REXX
  89. Updating columns w/ same value - will DB2 optimize for me?
  90. Upgrade DB2 v7 -> v8 and new server h/w. Best approach?
  91. UDB 8.1.4 & VB6/ADO
  92. Equivalent of VARRAYs in DB2
  93. SQL5035N The database requires migration to the current release.
  94. Where can i find Natural for DB2 programmer guide?
  95. Problem with db2mscs
  96. Does anyone use database modeling software?
  97. Unable to See"Sample Contents" of a Table
  98. Pseudo Check Constraint
  99. yipeee!
  100. RI violation. Has somebody ever seen this?
  101. Migrating from MsSQL to DB2/400
  102. RAID5 and tablespaces
  103. importing data from customer workstation
  104. Health Monitor
  105. How to set default schema name?
  106. Intermittent Beep
  107. Problem with locks
  108. Failure while installing Event Database. TEC 3.9
  109. Exporting large tables with a lob column
  110. Union in Views: No Branch Elimination because predicate with NonCor-Subselect ?
  111. Need help with error: The specified driver could not be loaded!
  112. Which tablespce is used when running ALTER TABLE & CREATE INDEX
  113. v8.1 fp2 application server for DB2. Where is it?
  114. How to list tables in order (parent & child relationship)
  115. DB2 Archive Log from Tape to DASD
  116. Create server error ...
  117. Did you know... that IBM's DB2 websites are now "googled"?
  118. checksum question
  119. DB2 suddenly become unable to NIS authenticate?
  120. how UDB reuse the Secondary Log Files
  121. Using GROUP BY and MAX() to ignore NULL ?
  122. Migrating from Solaris to Linux
  123. Recovery after Crash
  125. DIA7523E, Error in Generator?
  126. SQL1092N "" does not have the authority to perform the requested command.
  127. Communication error SQL30081N ?
  128. Import vs Insert into with select
  129. Why no unsigned integers in DB2?
  130. FP4a 32 bit Aix compatibility question
  131. transaction log
  132. Clearification of 32 and / or 64 DB2/UDB 8.X backup restore under AIX 4.3 and AIX5.2
  133. How to determine field length in an unicode database
  134. db2 export - how to make it faster
  135. How to trim leading zeroes when converting decimal() to char()
  136. Uninstalling IBM Distributed Debugger?
  137. Reference books - DB2 C/C++ App development
  138. DB2 8.1 AIX Client Installation Problems
  139. dxxShredXML limitations, dimension limitation?
  140. UNIX UDB V 7 - In db2diag.log interpreting Obj={pool:1;obj:2;type:128}
  141. LDAP to populate SQL 2000/Active Directory
  142. convert rows to columns
  143. Administrating configuration data on clients
  144. backspace and delete button in command center
  145. "SQL1035N No database manager SQL1035N No database manager command was issued. SQLSTATE=57019
  146. Kinds of drivers for connecting to DB2 on os390
  147. Does os390 db2 version 7.1.1 support olap function
  148. jdbc driver for os390 db2 version 7.1.1
  149. Db2 version 8 on os390
  150. pagination
  151. export from DB2/390 as del
  152. DB2 and File Replication
  153. different tablespace containers has same bad index page error
  154. Relative Performance between SQL Procedures & SQL Functions
  155. Problem when migrating DB from v7 to v8
  156. Defragging removed Data Warehouse Center services ??
  157. Websphere DB2 Connection problem
  158. Data modelling tool for UDB 8.1
  159. error from db2dart
  160. error from db2dart
  161. novice question about password
  162. inspection result from db2dart
  163. using smtp on DB2 V8 for windows XP
  164. Slow Trigger
  165. sql can't execute on different condition
  166. How to find the C compiler
  167. help on error from db2diag.log
  168. extract from db2diag.log
  169. listing user created stored procedures
  170. ado updatebatch problem
  171. W2K did not restart DB2 service as specified in the 'Recovery' properties setting
  172. Do you have to always specify schema when using db2 CLP?
  173. replication troubles
  174. SPUFI
  175. how to validate the RETURN CODE in db2_all
  176. the size of db backup image
  177. test
  178. 1
  179. Problems debugging Java Stored Procedures in V7.2 FP9 (WinXP)
  180. Log Mirroring + User Exit AIX
  181. accessing databases
  182. Catalog DB Problem in 7.2
  183. No answer for your problem ?
  184. Case INsensitivity for string comparisons
  185. Control Center - current query opt error
  186. SET CURRENT SCHEMA in a Trigger or Procedure
  187. Please Recommend Books
  188. Backup - without getting an SQL0290N ?
  189. Finding % of used space in container
  190. Control Statements in Command Center
  191. SQL - Update stmt
  192. DB2 server & fixpack installation step
  193. Java Stored Procedures in DB2 V7.2
  195. DB2 Cluster with Peoplesoft
  196. ICM question for searching
  197. stored procedures developers guide
  198. db2 and lotus notes
  199. IDS to DB2 conversion
  200. callerac value or response in REDIRECTED restore
  201. How to find indexes working on a temporary table in UDB AIX.(UDB 8.1)
  202. Server buyers database
  203. Redirected restore, when only Instance is created & cataloged
  204. Count(*)
  205. yo
  206. db2 recepies
  207. Peoplesoft on Federated UDB?
  208. What is the best way for storing lengths in a database?
  209. db2 event log
  210. db2 connect
  211. Rollforward recovery...another question...
  212. Invalid Handle
  213. Remove import file after load
  214. Unable to create test DB2 database
  215. Windows & DB2 - need administrative access?
  216. Change SQL Terminator for SPUFI
  217. Binding after Fixpack Installation
  218. Remote User Defined Functions
  219. Inserting Multiple DATE values into a column.
  220. Problem creating raw container on RedHat
  221. rebind after DB2 client upgrade
  222. Replication
  223. Problems creating a task in DB2
  224. Using common table expressions - in line views
  225. SQL Joins and Cost
  226. Converting from unix timestamp format into db2 timestamp format
  227. Catalog system/database from DB2v8.1 to DB2v7.2 using CCA
  228. SQL1220N The database manager shared memory set cannot be allocated.
  229. column wise array insert hangs !
  230. select on table T1 while importing into table T1
  231. BackUp and Recovery for DB2
  232. Calculating Business Days
  233. SQLERROR -204
  234. Tablespace Design
  235. Max container file size for W2K
  236. Tables without indexes
  237. Trigger to create flat file for new row in table
  238. db2 connect problem
  239. select * from table AND navigation
  240. select * from table AND navigation
  241. text extenders error can't find indexes
  242. Tablespace conteiner I/O statistics
  243. db2 for educational use
  244. Compile-link options for DB2 V8
  245. Scheduling a Task
  246. Problems Converting T-SQL code to SQL PL
  247. rank(), denseRank() etc...
  248. getPrimaryKey on Db2
  249. Java procedure and the "alter sequence" statement
  250. different chr(0) handling in v7.2 and v8?
  251. Export an ixf file to ASCII
  253. SQLZ_DISCONNECT_PROC in V8 FP4 Stored Procedure
  254. ADO performance problems
  255. question on embedding literals in load statements
  256. add dbpartitionnum
  257. Distributed Database for OLTP?
  258. Log write batch performance problem DB2 V8 for AIX
  259. Cobol Stored Procedures in DB2 on Windows
  260. DB restore
  261. resources for preparing db2 interview
  262. is there something similar to Oracl'es metalink for DB2
  263. db2relocatedb trouble
  264. learning mainframe db2 without mainframe
  265. Enabling INTRA_PARALLEL config - does it help?
  266. FixPak Disk Space
  267. C stored Proc problem on AIX
  268. internal db2 rc
  269. Logistics of DB2 Administration Certification
  270. Identity column
  271. XML Extender
  272. Starting DB2 Universal 8.1
  273. User IDs with special Characters
  274. storing in mixed case
  275. How to connect the DB with user created manually?
  276. Used Space for Tablespaces ESE/DPF
  277. DB2 Version 5 - Module DSAA not found error - Please help
  278. Rollforward recovery algorithm...
  279. Works in one environment, not in the other
  280. Need Help Converting MS SQL Server Stored Procedures to DB2
  281. List sequences?
  282. Counting connections per user using sql
  283. Unable to restore a v7.02 saved database into v8.1
  284. DB2 EEE autoload fails due to insufficient storage (SQL3011C)
  285. Multiple queries in a single SQL string
  286. Documentation CD for V8 ???
  287. DB2 Configuration Advisor issue
  288. DB2 Data Provider for .NET
  289. IMPORT'ing XML
  290. SQLprocedures() API performance on UDB 8.1
  291. SQL1131N with INSTALL_JAR on DB2 7.2 FP11
  292. PHP, DB2, iSeries, PASE, binary field question
  293. Loading data and keep available
  294. Bug: SQLGetDiagRec returns SQL_SUCCESS_WITH_INFO
  295. Invalid fullselect specified for MQT, more info available?
  296. DB2 UDB Admin tools
  297. "RenameArray: add unarchived log" and "Common - OSSe - OSSHIPCSemaphore ... Time out" in db2diag.log
  298. Create partitions on FOR BIT DATA column: how to?
  299. How to create a db2 subsystem and then databases for DB2 V7 for OS/390 ZOS
  300. V7 data transfer/load into V8 databases
  301. DB2 install problem
  302. Sybase to UDB conversion
  303. DB2 SNMP Support on V8
  304. Multiple DAS server on the same machine
  305. how to find out this ..?
  306. CTE0190 Executable program "cteadmsv" could not be started
  307. Problem with Fault Monitor Coordinator
  308. Experience witch CLOB ( and COBOL )
  309. DB2/zOS: when VARY WLM,APPLENV=name,REFRESH
  310. How full is my Tablespace Container?
  311. Standard scripts for basic montoring of db2
  312. parallel strategies within db2 udb ?
  313. DB2 UDB 8.1.2 client: problem with SQLGetFunctions
  314. Method which acceses a reference to another object
  316. How can I kill a pending job ?
  317. Beta testers wanted for new "blueshell Data Guy Professional"
  318. Performance improvement for Stored Proc resolution
  319. Problem with installation of DB2 UDB ESE on Solaris2.8
  320. datalink in DB2
  321. db2xml.update problem
  322. Backup using prefetch size for reading.
  323. V8 migration - Control Center errors
  324. Create v8 FP4 DB from v7.2 FP4 bkup
  325. Problem with ResultsetMetaData with DB2 universal jdbc driver(Type4)
  326. delete child table rows based on predicates in a parent table
  327. Memory lack
  328. Deadlock or timeout on executeBatch()
  329. twophase-commit via gateway to host-db
  330. Bug in calculating ISIZE for REORGCHK on indexes??
  331. CLI call SQLTables and RTRIM
  332. Trigger and nickname
  333. ODBC Connection
  334. DB2 Migration from 7.2 to 8.1
  335. DB2 UDF calling external application
  336. SQL Stored Procedure Question
  337. SYSMON
  338. Installing DB/2 8.1 on RedHat Advanced Server Version 3
  339. Performance of SQLProcedureColumns() API in UDB 8.1 ?
  340. How to speed up database scripts
  341. Dynamic SQL in table SQL UDFs
  342. Configuration Advisor
  343. Memory and bufferpool issues
  344. What ARE these HFS datasets for? (Os/390)
  345. aps_general_service
  346. No results in command center
  347. No Call in UDF, what other options?
  348. BLOB in Table
  349. DB2 book suggestions
  350. BETWEEN operation on TIMESTAMP fileds
  351. How to get catalog information ?
  352. kocham was niedorajdy
  353. DML Transaction List
  354. DB2 Security
  355. installing UDB v7 local Administrative authority error
  356. Call Java Stored Procedure fail after Migrate DB2 V7 to V8
  357. DB2 8.1 PE Installation on WinXP -- Invalid User Authority
  358. sysibm.sqlprocedures performance on UDB8.1 (Solaris)
  359. Is there a way DSNZPARM using db2 trace's - DB2 on OS/390 zOS
  360. Connecting to database
  361. VB.Net (OLE) Stored Procedure problem
  362. DARI memory utilisation
  363. Historic data on index utilisation?
  364. DB2 Windows Client
  365. Control Center on Linux
  366. DB2 UDB 8.1 for Windows installation questions
  367. Sample UDF "Counter" -471
  368. Strange JDBC error when retrieving data
  369. DB2/zOS: Recreate DBRMs from remote bounded packages
  370. CPF5257
  371. is there a recover "db2 subsystem" command in DB2 for OS/390 ..?
  372. db2diag.log error : sqm.sqlm_log_ev_err
  373. Which gain better performance : multiple columns or use SQL built-in function?
  374. Equivalent of Oracle "@" in db2
  375. using Admin API from within Java
  376. Are people using db2 on Windows?
  377. db2 hangs when connecting with jdbc
  378. Delphi + IBM DB2 UDB (under MS Win 32) with Ado
  379. Bufferpool access on insert
  380. DMS vs. SMS on RAID 5
  381. Error establishing simultaneous DB connections in UDB 8.1.
  382. Net Search
  383. is it possible to pass 2 SQL statements in a single call ?
  384. external scheduling in datawarehouse center
  385. problems creating a simple stored procedure in DB2
  386. How to decrease primary log space usage during restore?
  388. indexing documents with datalink datatype
  389. [V7] Problem with memory ?
  390. Possible to update a file for all w2k servers via script?
  391. db2 api sqlesetc() not connecting to catalog node
  392. Version Control
  393. parsing a comma-separatinf list
  394. db2 full-incremental-delta restore/recovery question
  395. SQL Stored Procedure
  396. DB2 UDB 8.1 on HP-UX 11i installation problem resolved
  397. db2javit.dll error starting Control Center (or any GUI app) with DB2 8.1 on Windows
  398. More than 254 chars in text DB2 client
  399. jdbc-error from linux udb81.4-client to windows udb 8.1.4 server
  400. No nicknames shown in control center V8.1.4
  401. What means SBDB?
  402. Diag.log. data protection sqlpghck
  403. v8.1.4 new features
  404. Archived log path directory
  405. Unable to load data that has * value
  406. UDB 8.1.4 and MS DB2OLEDB driver
  407. db2connect to connect Windows client to a DB2 database on Unix platform ?
  408. Can a COBOL batch program CALL to COBOL batch db2 program?
  409. Strange 'cnv' ?
  410. CPU usage of DB2_USE_ALTERNATE_PAGE_CLEANING setting in V8.1.4
  411. DB2 SQL Statement Optimization
  412. DB2 on Mac OSX ?
  413. Drop and Create alias statements took a long time (7.2 FP7, AIX)
  414. Double datatype value display in select statament
  415. CASE problem
  416. ODBC drivers, .NET providers, OLE DB providers, JDBC drivers: updated lists
  417. newbe question: convert codepage
  418. DB2 OLAP vs Hyperion Essbase (version, package)
  419. Update 'db cfg' to all servers via script
  420. Table statistics
  421. Web Tools
  422. one server, two version, instances with different vision-- is this possible
  423. SQL0501N during import
  424. How to change the isolation level of a database alias
  425. data space missing in user defined tablespace
  426. -805 Error
  427. SQL PATH?
  428. Redirected Restore of DB With Stored Procedures
  430. SQL0805N
  431. Windows installer error when installing fixpak 4
  432. Function "1"
  433. data space missing in user defined tablespace
  434. -805 Error
  435. SQL PATH?
  436. Redirected Restore of DB With Stored Procedures
  438. SQL0805N
  439. Windows installer error when installing fixpak 4
  440. Function "1"
  441. about replicated summary table on two base tables
  442. What means this db2diag.log?
  443. Control center problem with remote accees from terminalserver
  444. Allow DB2 acces through db2connect only from delimited clients
  445. Where is DB2_BDINFO ?
  446. Problem with stored procedure
  447. how to create additional instance in different diretory----Help
  448. How could the optimizer choose to use the MQT
  449. Auto updating field created from the value of an IDENTITY field
  450. Exporting Records from AS400 file to an ASCII delimited file
  452. sql0444
  453. bufferpool
  454. DTS from SQL Server to DB2
  455. V7 client and V8 client on same machine
  456. Retrieve and display unicode data using ADO and DB2 V7.2
  457. Message: data protection sqlpghck
  458. Can system catalog tables be pruned?
  459. drop schema problems
  460. INCLUDE in index
  462. cataloging database after unistalling -> installing db2
  463. SQL1651N exporting to/from db2 v8.1
  464. Message : DIA8309C Log file was full.
  465. problem while creating sample database
  466. Stop DB2 instance
  467. db2mtrk and instance crash
  468. Restore..why?
  469. LogPrimary
  470. Overflowlogpath
  471. 8.1 win and non-java command center (db2cctr)
  472. SQLForeignKeys ODBC call
  473. db2 resources on linux
  474. Suggestions for the DB2 Information Center
  475. copying logs then roll forward problems
  476. erwin and Db2 version 8
  477. [Google] DB2 query
  478. Good and up-to-date book on DB2
  479. DSNZPARM - New Bie's Quiestion
  480. db2 connect migration from v6 to v8
  481. Development Center
  482. Pattern to ensure executing ONLY required SQL statements ?
  483. ISERIES driver for AS400 return erroneous data for NULL Values
  484. DB2 Performance Issue
  485. Problem in V8 : db2 ? command
  486. Date roll over functionality
  487. DB2 major migration from V7 to V8
  488. Agent not allocated, sqlcode = -1223
  489. (no subject)
  490. US-IL-Springfield: DB2 DBA, 3-6 mo., analyze DB performance with native tools, Jan. start
  491. call db2dari proc pb on V8.1 FP4
  492. IBM looking for Feedback on Installation and Packaging - DB2 andWebsphere
  493. Creating a SP using the control manager
  494. data from several rows in one field
  495. db2 crash
  496. List or Force Applications by Auth ID
  497. Trigger Advice ? - Thnx
  498. How can I create groups?
  499. SQL Stored procedures
  500. SOAP-Interface for DB2
  501. test
  502. any community for db2 certified people
  503. DB2 multiple trigger activation order for column UPDATEs
  504. DB2 on As400 ADO.NET compatibality
  505. DB2 on As400 ADO.NET compatibality
  506. nonequijoin
  507. MVS DB2 tables - connecting with PC
  508. execute DB2 VSE operator commands from user program
  509. DBI1222W error when migrate the instance from 5.2 to 7.2
  510. Inserting CLOB data to OS/390 DB2 6.1
  511. SQL Stored Procs
  512. Advice sought on best way to get data into a Linux db2 8.1.4 database
  513. ESQLC --- Function Parameters as Host Variables
  514. UDB Commands
  515. Local or remote instances.
  516. 2nd CFV: comp.databases.etl
  517. proper way to shutdown db2
  518. Binding after FixPack installation?
  519. Problems when binding DBConnect against OS/390
  520. DB2 8.1.4 I/O Performance
  521. Problem with DB2 field type CHAR(n) FOR BIT DATA
  522. IMS database migration
  523. db2 language
  524. DB2Driver; rollback closing resultsets
  525. How to remove constraint
  526. DB2 Cube Views
  527. DB2 8.3.1 on RedHatLinux AS2.1 problems
  529. DATE function problems
  530. Moving SQLJ Stored Procedures
  531. Turn On/Off Foreign Key Constraints?
  532. db2batch from windows client: SQL1427N An instance attachment does not exist
  533. Date parameter as a criteria for data in db2 accessed from msquery returns error
  534. DB2-SQL questions (grant...)
  535. Calling Stored Procedures
  536. translation error on windows services ?
  537. DB2 connect - user id question
  538. Backups for e commerce site
  539. Resolve Error for SMCODE: -28 relative to DBA4730E
  540. shared memory - can't backup
  541. DB2 SELECT COUNT(*) problem
  542. Memory hogging after restore with a warning
  543. Where can I download the DB2 V7.x personal edition?
  544. DB2 table space too big problem
  545. ListCleaner (winpure)....Opinions / Recommendations???
  546. Problem installing V8 FP4 on W2K
  547. load data with embeded New Line character
  548. UNION to implement default values
  549. DB2LOOK & Tablespace Containers
  550. DB2 V8.1.4 and backup compression