View Full Version : answers

Pages : 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 [20] 21
  1. How to trim leading zeroes when converting decimal() to char()
  2. Uninstalling IBM Distributed Debugger?
  3. Reference books - DB2 C/C++ App development
  4. DB2 8.1 AIX Client Installation Problems
  5. dxxShredXML limitations, dimension limitation?
  6. UNIX UDB V 7 - In db2diag.log interpreting Obj={pool:1;obj:2;type:128}
  7. LDAP to populate SQL 2000/Active Directory
  8. convert rows to columns
  9. Administrating configuration data on clients
  10. backspace and delete button in command center
  11. "SQL1035N No database manager SQL1035N No database manager command was issued. SQLSTATE=57019
  12. Kinds of drivers for connecting to DB2 on os390
  13. Does os390 db2 version 7.1.1 support olap function
  14. jdbc driver for os390 db2 version 7.1.1
  15. Db2 version 8 on os390
  16. pagination
  17. export from DB2/390 as del
  18. DB2 and File Replication
  19. different tablespace containers has same bad index page error
  20. Relative Performance between SQL Procedures & SQL Functions
  21. Problem when migrating DB from v7 to v8
  22. Defragging removed Data Warehouse Center services ??
  23. Websphere DB2 Connection problem
  24. Data modelling tool for UDB 8.1
  25. error from db2dart
  26. error from db2dart
  27. novice question about password
  28. inspection result from db2dart
  29. using smtp on DB2 V8 for windows XP
  30. Slow Trigger
  31. sql can't execute on different condition
  32. How to find the C compiler
  33. help on error from db2diag.log
  34. extract from db2diag.log
  35. listing user created stored procedures
  36. ado updatebatch problem
  37. W2K did not restart DB2 service as specified in the 'Recovery' properties setting
  38. Do you have to always specify schema when using db2 CLP?
  39. replication troubles
  40. SPUFI
  41. how to validate the RETURN CODE in db2_all
  42. the size of db backup image
  43. test
  44. 1
  45. Problems debugging Java Stored Procedures in V7.2 FP9 (WinXP)
  46. Log Mirroring + User Exit AIX
  47. accessing databases
  48. Catalog DB Problem in 7.2
  49. No answer for your problem ?
  50. Case INsensitivity for string comparisons
  51. Control Center - current query opt error
  52. SET CURRENT SCHEMA in a Trigger or Procedure
  53. Please Recommend Books
  54. Backup - without getting an SQL0290N ?
  55. Finding % of used space in container
  56. Control Statements in Command Center
  57. SQL - Update stmt
  58. DB2 server & fixpack installation step
  59. Java Stored Procedures in DB2 V7.2
  60. comp.databases.ibm-db2
  61. DB2 Cluster with Peoplesoft
  62. ICM question for searching
  63. stored procedures developers guide
  64. db2 and lotus notes
  65. IDS to DB2 conversion
  66. callerac value or response in REDIRECTED restore
  67. How to find indexes working on a temporary table in UDB AIX.(UDB 8.1)
  68. Server buyers database
  69. Redirected restore, when only Instance is created & cataloged
  70. Count(*)
  71. yo
  72. db2 recepies
  73. Peoplesoft on Federated UDB?
  74. What is the best way for storing lengths in a database?
  75. db2 event log
  76. db2 connect
  77. Rollforward recovery...another question...
  78. Invalid Handle
  79. Remove import file after load
  80. Unable to create test DB2 database
  81. Change SQL Terminator for SPUFI
  82. Windows & DB2 - need administrative access?
  83. Binding after Fixpack Installation
  84. Remote User Defined Functions
  85. Inserting Multiple DATE values into a column.
  86. Problem creating raw container on RedHat
  87. rebind after DB2 client upgrade
  88. Replication
  89. Problems creating a task in DB2
  90. Using common table expressions - in line views
  91. SQL Joins and Cost
  92. Converting from unix timestamp format into db2 timestamp format
  93. Catalog system/database from DB2v8.1 to DB2v7.2 using CCA
  94. SQL1220N The database manager shared memory set cannot be allocated.
  95. column wise array insert hangs !
  96. select on table T1 while importing into table T1
  97. BackUp and Recovery for DB2
  98. Calculating Business Days
  99. SQLERROR -204
  100. Tablespace Design
  101. Max container file size for W2K
  102. Tables without indexes
  103. Trigger to create flat file for new row in table
  104. db2 connect problem
  105. select * from table AND navigation
  106. select * from table AND navigation
  107. text extenders error can't find indexes
  108. Tablespace conteiner I/O statistics
  109. db2 for educational use
  110. Compile-link options for DB2 V8
  111. Scheduling a Task
  112. Problems Converting T-SQL code to SQL PL
  113. rank(), denseRank() etc...
  114. getPrimaryKey on Db2
  115. Java procedure and the "alter sequence" statement
  116. different chr(0) handling in v7.2 and v8?
  117. Export an ixf file to ASCII
  118. BACKUP DATABASE
  119. SQLZ_DISCONNECT_PROC in V8 FP4 Stored Procedure
  120. ADO performance problems
  121. question on embedding literals in load statements
  122. add dbpartitionnum
  123. Distributed Database for OLTP?
  124. Log write batch performance problem DB2 V8 for AIX
  125. Cobol Stored Procedures in DB2 on Windows
  126. DB restore
  127. resources for preparing db2 interview
  128. is there something similar to Oracl'es metalink for DB2
  129. db2relocatedb trouble
  130. learning mainframe db2 without mainframe
  131. Enabling INTRA_PARALLEL config - does it help?
  132. FixPak Disk Space
  133. C stored Proc problem on AIX
  134. internal db2 rc
  135. Logistics of DB2 Administration Certification
  136. Identity column
  137. XML Extender
  138. Starting DB2 Universal 8.1
  139. User IDs with special Characters
  140. storing in mixed case
  141. How to connect the DB with user created manually?
  142. Used Space for Tablespaces ESE/DPF
  143. DB2 Version 5 - Module DSAA not found error - Please help
  144. Rollforward recovery algorithm...
  145. Need Help Converting MS SQL Server Stored Procedures to DB2
  146. Works in one environment, not in the other
  147. List sequences?
  148. Counting connections per user using sql
  149. Unable to restore a v7.02 saved database into v8.1
  150. DB2 EEE autoload fails due to insufficient storage (SQL3011C)
  151. Multiple queries in a single SQL string
  152. Documentation CD for V8 ???
  153. DB2 Configuration Advisor issue
  154. DB2 Data Provider for .NET
  155. IMPORT'ing XML
  156. SQLprocedures() API performance on UDB 8.1
  157. PHP, DB2, iSeries, PASE, binary field question
  158. SQL1131N with INSTALL_JAR on DB2 7.2 FP11
  159. Loading data and keep available
  160. Bug: SQLGetDiagRec returns SQL_SUCCESS_WITH_INFO
  161. Invalid fullselect specified for MQT, more info available?
  162. DB2 UDB Admin tools
  163. "RenameArray: add unarchived log" and "Common - OSSe - OSSHIPCSemaphore ... Time out" in db2diag.log
  164. Create partitions on FOR BIT DATA column: how to?
  165. How to create a db2 subsystem and then databases for DB2 V7 for OS/390 ZOS
  166. V7 data transfer/load into V8 databases
  167. DB2 install problem
  168. Sybase to UDB conversion
  169. DB2 SNMP Support on V8
  170. how to find out this ..?
  171. Multiple DAS server on the same machine
  172. CTE0190 Executable program "cteadmsv" could not be started
  173. Problem with Fault Monitor Coordinator
  174. Experience witch CLOB ( and COBOL )
  175. DB2/zOS: when VARY WLM,APPLENV=name,REFRESH
  176. How full is my Tablespace Container?
  177. Standard scripts for basic montoring of db2
  178. parallel strategies within db2 udb ?
  179. DB2 UDB 8.1.2 client: problem with SQLGetFunctions
  180. Method which acceses a reference to another object
  181. SQL STORED PROCEDURE
  182. How can I kill a pending job ?
  183. Beta testers wanted for new "blueshell Data Guy Professional"
  184. Performance improvement for Stored Proc resolution
  185. Problem with installation of DB2 UDB ESE on Solaris2.8
  186. datalink in DB2
  187. db2xml.update problem
  188. Backup using prefetch size for reading.
  189. V8 migration - Control Center errors
  190. Create v8 FP4 DB from v7.2 FP4 bkup
  191. Problem with ResultsetMetaData with DB2 universal jdbc driver(Type4)
  192. delete child table rows based on predicates in a parent table
  193. Memory lack
  194. Deadlock or timeout on executeBatch()
  195. twophase-commit via gateway to host-db
  196. Bug in calculating ISIZE for REORGCHK on indexes??
  197. CLI call SQLTables and RTRIM
  198. Trigger and nickname
  199. ODBC Connection
  200. DB2 Migration from 7.2 to 8.1
  201. DB2 UDF calling external application
  202. SQL Stored Procedure Question
  203. SYSMON
  204. Installing DB/2 8.1 on RedHat Advanced Server Version 3
  205. Performance of SQLProcedureColumns() API in UDB 8.1 ?
  206. How to speed up database scripts
  207. Dynamic SQL in table SQL UDFs
  208. Configuration Advisor
  209. Memory and bufferpool issues
  210. What ARE these HFS datasets for? (Os/390)
  211. aps_general_service
  212. No results in command center
  213. No Call in UDF, what other options?
  214. BLOB in Table
  215. DB2 book suggestions
  216. How to get catalog information ?
  217. BETWEEN operation on TIMESTAMP fileds
  218. kocham was niedorajdy
  219. DML Transaction List
  220. DB2 Security
  221. installing UDB v7 local Administrative authority error
  222. Call Java Stored Procedure fail after Migrate DB2 V7 to V8
  223. DB2 8.1 PE Installation on WinXP -- Invalid User Authority
  224. sysibm.sqlprocedures performance on UDB8.1 (Solaris)
  225. Is there a way DSNZPARM using db2 trace's - DB2 on OS/390 zOS
  226. Connecting to database
  227. VB.Net (OLE) Stored Procedure problem
  228. 64 bit - Windows Liberty 64bit, Windows Limited Edition 64 Bit,Microsoft SQL Server 2000 Developer Edition 64 Bit, IBM DB2 64 bit - new!
  229. DARI memory utilisation
  230. Historic data on index utilisation?
  231. DB2 Windows Client
  232. Control Center on Linux
  233. DB2 UDB 8.1 for Windows installation questions
  234. Sample UDF "Counter" -471
  235. Strange JDBC error when retrieving data
  236. DB2/zOS: Recreate DBRMs from remote bounded packages
  237. CPF5257
  238. is there a recover "db2 subsystem" command in DB2 for OS/390 ..?
  239. db2diag.log error : sqm.sqlm_log_ev_err
  240. Which gain better performance : multiple columns or use SQL built-in function?
  241. Equivalent of Oracle "@" in db2
  242. using Admin API from within Java
  243. Are people using db2 on Windows?
  244. db2 hangs when connecting with jdbc
  245. Delphi + IBM DB2 UDB (under MS Win 32) with Ado
  246. Bufferpool access on insert
  247. DMS vs. SMS on RAID 5
  248. Error establishing simultaneous DB connections in UDB 8.1.
  249. Net Search
  250. is it possible to pass 2 SQL statements in a single call ?
  251. external scheduling in datawarehouse center
  252. problems creating a simple stored procedure in DB2
  253. How to decrease primary log space usage during restore?
  254. SQLCODE -104 in CREATE TRIGGER
  255. indexing documents with datalink datatype
  256. [V7] Problem with memory ?
  257. Possible to update a file for all w2k servers via script?
  258. db2 api sqlesetc() not connecting to catalog node
  259. Version Control
  260. parsing a comma-separatinf list
  261. db2 full-incremental-delta restore/recovery question
  262. SQL Stored Procedure
  263. DB2 UDB 8.1 on HP-UX 11i installation problem resolved
  264. db2javit.dll error starting Control Center (or any GUI app) with DB2 8.1 on Windows
  265. More than 254 chars in text DB2 client
  266. jdbc-error from linux udb81.4-client to windows udb 8.1.4 server
  267. No nicknames shown in control center V8.1.4
  268. What means SBDB?
  269. Diag.log. data protection sqlpghck
  270. v8.1.4 new features
  271. Archived log path directory
  272. Unable to load data that has * value
  273. UDB 8.1.4 and MS DB2OLEDB driver
  274. db2connect to connect Windows client to a DB2 database on Unix platform ?
  275. Can a COBOL batch program CALL to COBOL batch db2 program?
  276. Strange 'cnv' ?
  277. CPU usage of DB2_USE_ALTERNATE_PAGE_CLEANING setting in V8.1.4
  278. DB2 SQL Statement Optimization
  279. DB2 on Mac OSX ?
  280. Drop and Create alias statements took a long time (7.2 FP7, AIX)
  281. Double datatype value display in select statament
  282. ODBC drivers, .NET providers, OLE DB providers, JDBC drivers: updated lists
  283. CASE problem
  284. newbe question: convert codepage
  285. DB2 OLAP vs Hyperion Essbase (version, package)
  286. Update 'db cfg' to all servers via script
  287. Table statistics
  288. Web Tools
  289. SQL0501N during import
  290. one server, two version, instances with different vision-- is this possible
  291. How to change the isolation level of a database alias
  292. data space missing in user defined tablespace
  293. -805 Error
  294. SQL PATH?
  295. GRANT BLOCKING IP
  296. Redirected Restore of DB With Stored Procedures
  297. SQL0805N
  298. Windows installer error when installing fixpak 4
  299. Function "1"
  300. data space missing in user defined tablespace
  301. -805 Error
  302. SQL PATH?
  303. Redirected Restore of DB With Stored Procedures
  304. GRANT BLOCKING IP
  305. SQL0805N
  306. Windows installer error when installing fixpak 4
  307. Function "1"
  308. about replicated summary table on two base tables
  309. What means this db2diag.log?
  310. Control center problem with remote accees from terminalserver
  311. Allow DB2 acces through db2connect only from delimited clients
  312. Where is DB2_BDINFO ?
  313. Problem with stored procedure
  314. how to create additional instance in different diretory----Help
  315. How could the optimizer choose to use the MQT
  316. Auto updating field created from the value of an IDENTITY field
  317. Exporting Records from AS400 file to an ASCII delimited file
  318. CLASSPATH
  319. sql0444
  320. bufferpool
  321. DTS from SQL Server to DB2
  322. V7 client and V8 client on same machine
  323. Retrieve and display unicode data using ADO and DB2 V7.2
  324. Message: data protection sqlpghck
  325. Can system catalog tables be pruned?
  326. drop schema problems
  327. INCLUDE in index
  328. RESTORE FROM
  329. cataloging database after unistalling -> installing db2
  330. SQL1651N exporting to/from db2 v8.1
  331. Message : DIA8309C Log file was full.
  332. problem while creating sample database
  333. Stop DB2 instance
  334. db2mtrk and instance crash
  335. Restore..why?
  336. LogPrimary
  337. Overflowlogpath
  338. 8.1 win and non-java command center (db2cctr)
  339. SQLForeignKeys ODBC call
  340. db2 resources on linux
  341. Suggestions for the DB2 Information Center
  342. copying logs then roll forward problems
  343. erwin and Db2 version 8
  344. [Google] DB2 query
  345. Good and up-to-date book on DB2
  346. DSNZPARM - New Bie's Quiestion
  347. db2 connect migration from v6 to v8
  348. Development Center
  349. Pattern to ensure executing ONLY required SQL statements ?
  350. ISERIES driver for AS400 return erroneous data for NULL Values
  351. DB2 Performance Issue
  352. Problem in V8 : db2 ? command
  353. Date roll over functionality
  354. DB2 major migration from V7 to V8
  355. Agent not allocated, sqlcode = -1223
  356. (no subject)
  357. US-IL-Springfield: DB2 DBA, 3-6 mo., analyze DB performance with native tools, Jan. start
  358. call db2dari proc pb on V8.1 FP4
  359. IBM looking for Feedback on Installation and Packaging - DB2 andWebsphere
  360. Creating a SP using the control manager
  361. data from several rows in one field
  362. db2 crash
  363. List or Force Applications by Auth ID
  364. Trigger Advice ? - Thnx
  365. How can I create groups?
  366. SQL Stored procedures
  367. test
  368. SOAP-Interface for DB2
  369. any community for db2 certified people
  370. DB2 multiple trigger activation order for column UPDATEs
  371. DB2 on As400 ADO.NET compatibality
  372. DB2 on As400 ADO.NET compatibality
  373. nonequijoin
  374. MVS DB2 tables - connecting with PC
  375. execute DB2 VSE operator commands from user program
  376. DBI1222W error when migrate the instance from 5.2 to 7.2
  377. Inserting CLOB data to OS/390 DB2 6.1
  378. SQL Stored Procs
  379. Advice sought on best way to get data into a Linux db2 8.1.4 database
  380. ESQLC --- Function Parameters as Host Variables
  381. UDB Commands
  382. Local or remote instances.
  383. 2nd CFV: comp.databases.etl
  384. proper way to shutdown db2
  385. Binding after FixPack installation?
  386. Problems when binding DBConnect against OS/390
  387. DB2 8.1.4 I/O Performance
  388. Problem with DB2 field type CHAR(n) FOR BIT DATA
  389. IMS database migration
  390. db2 language
  391. DB2Driver; rollback closing resultsets
  392. How to remove constraint
  393. DB2 Cube Views
  394. DB2 8.3.1 on RedHatLinux AS2.1 problems
  395. FOREIGN KEY CHECK ON INSERT
  396. DATE function problems
  397. Moving SQLJ Stored Procedures
  398. Turn On/Off Foreign Key Constraints?
  399. db2batch from windows client: SQL1427N An instance attachment does not exist
  400. Date parameter as a criteria for data in db2 accessed from msquery returns error
  401. DB2-SQL questions (grant...)
  402. Calling Stored Procedures
  403. translation error on windows services ?
  404. DB2 connect - user id question
  405. Backups for e commerce site
  406. Resolve Error for SMCODE: -28 relative to DBA4730E
  407. shared memory - can't backup
  408. DB2 SELECT COUNT(*) problem
  409. Memory hogging after restore with a warning
  410. Where can I download the DB2 V7.x personal edition?
  411. DB2 table space too big problem
  412. ListCleaner (winpure)....Opinions / Recommendations???
  413. Problem installing V8 FP4 on W2K
  414. load data with embeded New Line character
  415. UNION to implement default values
  416. DB2LOOK & Tablespace Containers
  417. DB2 V8.1.4 and backup compression
  418. SQL0902C with Kernel 2.4.23
  419. Strange authentication, when account is disabled
  420. Unable to have a key for trial version
  421. DB2, LINUX & WWW
  422. What is UOW Waiting in DB2 LIST APPLICATIONS?
  423. about incremental backup
  424. stored proc lenght limitaion
  425. 2ibmteam: SQL stored procedures call in statement monitor
  426. Strange suggestion in Health Center
  427. Hyperthreading / Linux / DB2 V8.1 FP4 - performance
  428. UDF for z/OS v7 Select value from a table
  429. Archive log
  430. UPDATE statement and unique constraints.
  431. DB2 and dbUnit
  432. storing DMS on RAID
  433. ADO and DB2 8.1 performance tuning
  434. trap in snapshot table fonction V8 FP4
  435. DBD::DB2 Bug - negative REAL causes Numeric value out of range
  436. Converting Informix SP to DB2
  437. new to DB2 and CLI0621E Unsupported JDBC server configuration.
  438. DB2Connect - SQL8002N Error
  439. db2ii_8 + WebSphereStudio_5 problem...
  440. UDB Log
  441. Using CachedRowSet Selecting a BLOB Column
  442. data migration from SQL server to DB2
  443. Sql DB2
  444. Can lock timeouts be logged to a file in DB2 V8?
  445. DB2 backup error
  446. dangling message queues
  447. VIEW based on Stored Procedure
  448. is it normal that capture can t read archived log ?
  449. SQLCODE -497 -how to resolve?
  450. Bad performance with like in cursor
  451. DB2_SCATTERED_IO vs DB2BPVARS (v8 fp4)
  452. DB2 Commit vs. autocommit performance problems
  453. problem with db2
  454. Export LOB's in different files
  455. Unique constraint or index as in Oracle and "alter table alter column"
  456. Delays in between UDF invocations
  457. DB2 7.2 EE and Redhat 9 Question
  458. Enable DIO option in DB2 V8 FP4 For AIX
  459. How get info about table use by application?
  460. DB2 V8.1 FP4 JDBC-Performance-Issue
  461. DB2 CHECK for names?
  462. Ist es normal das es mit der Version 8.1 Performance Probleme gibt?
  463. Gibt es eine DB2 Funktion/Abfrage oder View um die User/User Group abzufragen?
  464. Nach Installation der DB2 Version von 8.1 werden Datentypen nicht meht angezeigt.
  465. db2jstrt: 0403-006 Execute permission denied.
  466. db2jstrt: 0403-006 Execute permission denied.
  467. SQL1088W - V7 to V8 database migration failure.
  468. Current date - n days
  469. unexplained performance drop
  470. Select @@ identity ???
  471. Siebel query question..help
  472. Mail di prova
  473. Why would tweaking SORTHEAP, SHEAPTHRES, and bufferpool sizes disables prefetch?
  474. SQL help with clearing out old plans and packages
  475. cannot create DAS, already present
  476. Federated database
  477. DB SAMPLE
  478. Index usage on db2 v7 for os390
  479. move DB with LOB's from NT4, DB2 V7.2FP3 to AIX5, DB2 V8.1 FP3
  480. BLOB fields trouble
  481. Database marked bad. One more time.
  482. Tempspace full at MQT refresh in DB2 V8 for Solaris
  483. Connection Logging
  484. Is there a v8 equiv of v7 db2_kill??
  485. Do I still need a C compiler on production server?
  486. Change SP query optimization level
  487. NFS-Home and runtimeclient
  488. SQL Error Code -443, SQL State 38553 - what does this error mean?
  489. Finding Last Backup Timestamp
  490. db2 reset monitor question
  491. Migrating from SQL Server
  492. db2dart - should db be activated or not?
  493. Building Java SP for debug
  494. GET DIAGNOSTICS statement....
  495. creating triggers in db2
  496. No "POSSTR" after migrate of V7 DB to V8
  497. UK DB2 UDB Users Group (LUW and z/OS)
  498. Portland, OR DB2 user's group
  499. db2relocatedb error
  500. Cannot find ibmdadb2.h file
  501. Problem installing NSE on Linux.
  502. UDB's scheduler keeps going to sleep resulting in automation not running.
  503. poor select performance
  504. identifying which logs to ship to stand-by server
  505. db2start error on 2-node cluster
  506. Possible Export bug ? (May be IY44569 ? )
  507. DB2 Connect EE, just the drivers?
  508. Adding a parameter to a Java SP
  509. UDB session and db2flsn
  510. Can't connect to db
  511. Event monitor creation in Control Center
  512. SQL1086C An operating system error "" occurred on databasemetadata.getcolumns()
  513. DB2 grant permission steps
  514. Migrating from 5.1 to 8.1: Locking problems (isolation level ?)
  515. Dot Net OleDB data provider ....
  516. MSProject -> ODBC -> DB2
  517. Query Number of VSAM Datsets of a nonpartitioned Tablespace
  518. SQL question: how to select multiple row into one row
  519. how to create a default tablespace
  520. "Database Home" and "Instance Home" (the difference)
  521. Recovery on UDB
  522. problem with UDF
  523. running db2jstrt and jdbc type 3
  524. installing a java sytored procedure from windoze development centre
  525. Bitwise functions available
  526. DB2 CLOB datatype
  527. Export/Import functionality
  528. check-constraint
  529. Data transfer
  530. Declared Temporary Table in Cobol
  531. Temporal functionality in DB2?
  532. db2 table editor?
  533. SQL1131N DARI (Stored Procedure)
  534. Accessing DB schema ...
  535. db2ckbkp
  536. db2set problem - DBI1360N
  537. Execution failed due to a distribution protocol error that caused deallocation of the conversation
  538. wrong node names
  539. how to specify timeout for CLI SQLConnect?
  540. INSERT from existing records of the same table
  541. How to get rid of dummy entry from System Database Directory
  542. Granting User-id's with special characters on a UDB database.......
  543. DB2 7.2 restore generating system error 1326
  544. one query question
  545. replication problem: target database cannot be accessed during replication
  546. DB2 ICE ( Integrated Cluster Environment )
  547. VIEW with specified columns for update?
  548. Problem with replication
  549. Issuing a SET SCHEMA command in a trigger..
  550. increase UDF_MEM and APP_CTL_HEAP_SZ size