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