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