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