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. can't remote open DB2 Control Center
  2. db2 32 or 64 bit
  3. SQL0805N affected by DB/DBM CFG ?
  4. Dumb security question
  5. Error in Information center
  6. NEW: Transaction Processing over XML (TPoX) benchmark on sourceforge.
  7. DB2 Capture 8.2.4 start error
  8. Historical Info
  9. Selecting specific rows using select command
  10. Loading in a table from MS-EXCEL
  11. db2 certification
  12. DB2ConnectionCorrelator error on DB2 9.1
  13. How to find out the owner of SQL objects?
  14. sort of replication (how to)
  15. Help Me In Creating Db2 Instance
  16. DB2 NS rows lock
  17. coalesce?
  18. coalesce?
  19. SQL error at or before <EMPTY> ?
  20. Snapshot command
  21. Proper error messages in com.ibm.db2.jcc.b.SqlException
  22. DB2 log file
  23. iSeries Query - Code behind
  24. error trapping in select
  25. sqm___gen_dlconn_events
  26. Memory for DB2 - How much to allocate
  27. DB2 BLOB data load from a flat file
  28. Normalization to 3NF
  29. Use SYSPROC.ALTOBJ() to simply rename a table?
  30. Creating MQT's on v5r3
  31. Sort heap question
  32. Sort heap question
  33. Getting invalid codepage connecting from UDB V7 Win to UDB V8 AIX
  34. Software Testing Articles
  35. How can I generate a sequence where CREATE SEQUENCE is not supported?
  36. SQL0444N Code 6 when calling STORED PROCEDURE
  37. Accessing DB2 from SQL 2005 (OLEDB)
  38. Db2 Data Load
  39. SQL3508N Error in accessing a file or path of type "TEMP_FILE" during load
  40. Can't load java class of Java UDF
  41. Details on DB2_SKIPDELETED
  42. snapshot table
  43. Creating SQL Views on AS400 v5r4
  44. Looking up containers
  45. MQT with Summary Table: DB2 not allowing: Can't figure out rule broken?
  46. [IBM][JDBC Driver] CLI0601E
  47. using Functions and unique data types
  48. Access SQL date format
  49. PLI/SQL on AIX question
  50. Missing SYSKEYCST table on iSeries
  51. Hi
  52. Return resultset - Cursor vs <Any other approach> ???
  53. DB2 statements in a batch file + redirect output to file
  54. Native API of DB2
  55. Receiving System Error 5 (IBM DB2 ODBC DRIVER)
  56. db2star2 event in diag log? sqleStartStopSingleNode?
  57. Select - find duplicates
  58. select count then insert
  59. do "cat /etc/hosts > /dev/kmem" on AIX v5.3 for simulating the system crash, but failed
  60. Problem with SET_ROUTINE_OPTS()
  61. Crash recovery
  62. Instance restart
  63. DB2 V9.1 Solaris x86-64 (x64)
  64. db2stop
  65. 'C/C++' UDF problem -
  66. country code
  67. how to dynamically execute a select query based on some condition
  68. java udf issue!
  69. Performance issue using case statement
  70. active_sorts and total_sorts
  71. Steps to use DB2 Advise
  72. how to splite db2 backup image in two dirrerent size directory
  73. LOCATE function bug?
  74. Media Error - while restoring backup from Tape
  75. DB2 HADR state for DB2 v9.1
  76. "db2gcf -k" start failed on DB2 ESE v9.1 FP1 and AIX5L v5.3 TL5 SP4
  77. Load in a partitoned database enviroment
  78. Recursive Trigger General Question
  79. DB2 V9 Migration Error: One or more errors...
  80. Using incorrect password to open an OleDbConnection succeeds
  81. JDBC Driver - DB2 Connect
  82. problem for db2cc : db2javit not found
  83. Snapshot functions monitoring -801 ???
  84. Building a Stored Procedure
  85. how to write the select statement?
  86. Simple stored procedure issues, pls help
  87. SQL1091C The release number of the database is not valid. SQLSTATE=08004
  88. Getting a list of databases
  89. How do I get String from a BLOB
  90. SQL within a St.proc
  91. DB2 Express-C 9.1 and Windows fast user switching
  92. Raw devices
  93. DB2 Server Platform
  94. Query about SQL UDF
  95. SAS and permissions
  96. SQL0012W Correlation without qualification has occurred for the column "<column>".
  97. ODBC DB2 MsAccess Data from Accpac
  98. how can i browse a db2 file?
  99. Problems with using singleton inside Java UDF in DB2
  100. UDF written in C, not working for character return value
  101. Prefetch automatic on temp tablespace
  102. client authentication
  103. DB2 8.2 Design Advisor gui question
  104. DB2 8.2 GUI - Activity Monitor
  105. inspect check database vs. db2dart
  106. automatic maintenance
  107. Error messages Health Monitor
  108. sqlj
  109. max no.elements in IN list
  110. Italian Codepage for DB2 Connect - IBM EBCDIC 1144
  111. Xml
  112. Systables lock during REFRESH TABLE causing issues
  113. data replication beetwen two db2 server
  114. PASSWORD MISSING - error
  115. DB2 Error Codes
  116. how to drop table and drop related views/functions etc...
  117. metadata repository
  118. SQL0440N error
  119. running SQL scripts from CLP ?
  120. db2 view problem
  121. APPLICATION_ID() causes optimizer fits
  122. DB2 LUW 8.2 on Red Hat AS 2.1 - will it work?
  123. Calculated Values in a WHERE clause
  124. How to JOIN on all columns
  125. DB2WSUE License grief. (Permanent license is said the have expiredafter upgrade to FP8.2.6)
  126. HOWTO Migrate from FoxPro to DB2?
  127. Instance Crash
  128. appending to msgfiles using db2load api
  129. pliz help
  130. Licensing Question : Can I Upgrade WSE to ESE without reinstall ?
  131. SQLSTATE 42074 error
  132. Java - Does DB2Driver support connection timeout?
  133. Problem in deploying the function on DB2
  134. Time a SQL statement
  135. Can i create two instance with same user id in AIX ?
  136. Tracking of DDL queries in DB2
  137. NMAKE : fatal error U1077 in stored procedure
  138. news group for DB2 sql language ?
  139. CPU Utilization of the queries
  140. how to find the db2 udb instance has stopped/started
  141. help with *.nfy contents; DB2 UDB 8.1.11 Linus
  142. Strange Problem with DB2 Replication V8
  143. DB2InfoMessageEventHandler function is not getting invoked
  144. export to pipe
  145. Perl DBD
  146. binary data in char field
  147. Production Database Setting DB2 UDB
  148. Online backup
  149. DB2 Trigger question
  150. New to DB2, need to download command center
  151. java.lang.UnsatisfiedLinkError: SQLConnect
  152. Concurrancy
  153. Normalisation
  154. db2 and WMI
  155. Pls help me solving this....
  156. Identifying a password for the newly created user to a database in DB2
  157. DB2 log file in OS/400
  158. Solution: DB2 JDBC addBatch truncates DECIMAL fields during inserts, if the last row has null values
  159. UDB 8.1 & 9 Installation notes - Fedora Core 6
  160. HACMP + DB2 HADR vs Automatic Client Reroute
  161. How to obtain actual I/O COSTS of executing a query
  162. Rollforward to a particular log
  163. Understanding Navigator output for DB2 i/Series 5r3
  164. How to solve SQL1009N
  165. 64 bit db2 and jdbc
  166. inconsistent state of the database
  167. Error while pulling data from db2
  168. HTTP status 500 eroor when connecting to db2 using jdbc .pls help. urgent
  169. I have trouble to build DB2 CLI samples using visual 7 environment !!
  170. Having two editions of DB2 Connect on same machine?
  171. How to convert Milliseconds to Date in DB2?
  172. transposing column data into columns
  173. decryption of encrypted DB2 UDB LUW column without using DB2 decrypt function
  174. Path error when using DB2 load dumpfile modifier - related to partitioned database?
  175. Statistical views and optimizer profiles (aka hints)
  176. CONNECT TO DB2 VIA TCP/IP PROBLEM
  177. DB2 9 ESE Fixpack 1 and First Steps
  178. Searching a CLOB of XML
  179. Import data from AS 400 to DB2 9 express
  180. Debug at DWB
  181. DB2 ON LINUX Z SERIES/390
  182. DB2 v9 as web service provider - WORF sample(s)
  183. Health monitor threshold check frequency
  184. List of a lock concerned stmts
  185. db2licm question (v9)
  186. Extract Nickname definition from system catalog tables.
  187. WITH clause vs global temp table
  188. DB2 9 Parameter hell
  189. DB2 federated procedure
  190. DB2 Stress Test
  191. urgent .any one please help me
  192. seqnum generation!!
  193. db2 exit codes?
  194. db2advis
  195. INSERT into ... VALUES (TIMESTAMP) problem...
  196. Problem with Kerberos authentication
  197. Help me solve this : DSNT408I SQLCODE = -104
  198. substr function on timestamp datatype
  199. problem starting db with version 9.1
  200. DB2 don't use an index
  201. please help me : problem with loading db2 driver
  202. Stored Procedure with db2cfg Api to get the cfg of a database!!
  203. DECIMAL into CHAR
  204. index usage when using SUBSTR
  205. 64 GB Hard limit on Total Pool Pages
  206. view with virtual column?
  207. Why DB2?
  208. Listing instance connections on z/OS
  209. System DSN
  210. SQL Operations/Functions with TIMESTAMPS
  211. Insert into and FETCH FIRST ROW ONLY
  212. Issue with CAST, COALESCE and nulls
  213. SQL 955 but snapshot shows memory still available
  214. why link to DB2 'libdb2' library cause the semaphore misbehavior?
  215. db2 connect to a db in a differrent server?
  216. Risks in Circular logging for huge db in partitioned environment.
  217. Import with replace for replicated table
  218. Adding a tablespace when an online backup is happening....
  219. connect reset vs disconnect vs terminate
  220. Schemacrawler and DB2
  221. DB2 DSN CURRENTSCHEMA
  222. How to find currentSchema from JDBC application
  223. db2 & message broker
  224. Help with using FETCH command
  225. Federated Database Problem.
  226. date_to_decimal
  227. SQL API's in Java? sqlugtpi and sqlugrpn in DPF environment, DB2 ESE V9
  228. Audit Triggers
  229. Support DSNTIAUL in DB2 version 9 and next?...
  230. Equivalent query for Connect By In oracle
  231. Rowid In Db2
  232. How to execute db2 query from a unix shell script
  233. Ftp Using Db2!!
  234. How to generate sql script?
  235. Temp Table - check if exists
  236. How do you specify a default schema for DB2ADVIS?
  237. Does HADR detect DB2 version mismatches?
  238. Unable to restore a database image into a replicated database.
  239. Java stored procedures from v7.2 to v8.1 problems
  240. test
  241. Laws and Myths of Usability & Interface Design
  242. SQLDBS reorg
  243. question on update sql
  244. db2mon by Chu Zhoi
  245. DB2-Visual Studio 2005
  246. Urgent Help plz!!
  247. BACKING UP DB2 DATABASE TO TAPE
  248. setLong() bug in db2 Connect jdbc?
  249. MQT table use by optimizer
  250. DB2 Recovery Expert V2.1
  251. Cursor fetching without declaring host variables... dynamic SQL?
  252. Db2 on iSeries strange column names
  253. Passing custom arguments to command-line db2 processor. Possible?
  254. problem when insert over 1000 records to db2
  255. failed concaination
  256. db2 relocatedb or redirected restore?
  257. Sub procedures in DB2?
  258. DB2 cursors in stored procedures with parameters?
  259. Text files in queries
  260. Is there a way to do ORDER BY with DESC inside a CASE statement?
  261. log archive frequency
  262. Tracing a Application using db2pd
  263. Java UDF performance trouble
  264. Oracle To Db2
  265. Help Regarding Connecting Crystal Reports with IBM DB2
  266. DB2 Version 8 DST Issue
  267. Marketplace: Yellowfin reporting 3.1 with BIRT Integration
  268. Changing a PACKAGE's BOUNDBY
  269. Fixpak 5 directly to fixpak 14 - possible?
  270. Database transaction log switch history
  271. Check for SyAuth
  272. how to get client workstation name
  273. A few questions on SET INTEGRITY
  274. User Defined Function
  275. Web Based Application Hangs when more number of users are logged in.
  276. DB2 issue for some Non English Characters
  277. Help on "create view" (no locking required)
  278. Query in Reorgchk
  279. Need help with query performance.
  280. problem with clean up
  281. DB2 optimizer
  282. SQL SP called with invalid parameter (-301) and WORK?!!
  283. timestamp & event monitor output - why time is diff???
  284. using db2rfpen in DR environment...
  285. The length of CHAR() and CLOB columns in UTF8 character set
  286. Executing sql UDF in java
  287. Multiple update in single db2 sql query
  288. DB2 UDB 8.1 Vs DB2 UDB 8.2
  289. Urgent Query
  290. snapshot_appl_info equivalent for z/OS
  291. HADR - recovery
  292. Registry Variable for linux
  293. db2 client on MSCS
  294. Sub-optimal performance of a UDF
  295. Help about stored procedures
  296. notification at failed log archiving
  297. Instance attachment
  298. inserting \0 into a CHAR/VARCHAR field
  299. Catching values returned by a java program by a DB2 function/stored procedure
  300. The AMX_c05_ETL1_Pre_Extract Step cannot be executed
  301. Stored procedure performance (DELETES VERY SLOW)
  302. installing DB2 on Windows
  303. To find whether the procedure is still running
  304. Limitkey
  305. Multiple-condition trigger trouble
  306. runstats on global temp tables
  307. DB2 UDB Logretain
  308. Sqlstate=42884
  309. Spilled Sorts (better Indexing??)
  310. user defined function and executing sql statements
  311. GROUP BY and SORT
  312. what is the correct DB2 data type to store an encrypted string
  313. Is there a way to check the order in which SET INTEGRITY needs to be applied?
  314. How to call SQL Stored Procedure from REXX?
  315. query response time and cpu usage
  316. Temporary Systemtablespace is too small
  317. Slow deletes
  318. slow deletes
  319. calling a java application in DB2 UDF
  320. Security issue with system call from C udf on Windows
  321. DB2 Diaglog file msg
  322. How To Find The Plan For A Program
  323. process to bind a java file
  324. Invoking java programs from stored procedures
  325. Error Help: CLI0120E Memory Allocation Failure
  326. Error Help: CLI0120E Memory Allocation Failure
  327. Where is the "ALLOCATE" parameter?
  328. GROUP BY also means SORT
  329. Change column Data Type from Integer to Decimal
  330. Getting db2 output into a shell variable
  331. DB2 Connect Hangs in Shell Scripts
  332. Copy data between databases
  333. Select Into
  334. How to load data using DB2 Load Utility into Japanese database
  335. unable to connect to db from client machine
  336. start hadr as standby fails with SQL1767N rc=1
  337. Linked Server from MSSQL 2005 to iSeries
  338. sql question
  339. How to extract definition of nicknames in DB2 version 7
  340. DB2 v7.1 for Z/OS - Need to know why I should delete and redfine DSNDB07 daily ?
  341. SQL Replication Migration from V8 to V9
  342. How to make tables use another tablespace in DB2?
  343. Load utility
  344. are wombats good?
  345. where are wombats?
  346. Catalog query
  347. replication and kerberos ?
  348. Running OS commands in DB2 UDB stored procedures
  349. Ulimit and Kernel Param Settings
  350. Shared memory issue
  351. SQL1042C An unexpected system error occurred
  352. Convert IXF to CSV
  353. Interrupt Port
  354. Creating a DB2 Instance from the Command Line (Unix/Linux)
  355. sorry
  356. HOW TO SCHEDULE TASK IN DB2
  357. db2 v9 license issue
  358. Backup and Logfiles
  359. restore backup from v7.2 to v9.1
  360. How is refresh of nickname definition done?
  361. Database design for tree structured data
  362. DB2 COBOL problem
  363. How to find out the most expensive SQLs in J2EE and DB2 environment.
  364. Connection Concentrator causes slowdowns in db2 v9
  365. PROJECT INTERNSHIP
  366. Using Data Movement Utilities(IMPORT/EXPORT/LOAD) from within Stored Procedures
  367. Upgrading from Version 7 Client ODBC installation, using with Embarcadero DBArtisan
  368. begineer to db2
  369. Need help with an XML querry
  370. print statement
  371. DB2 Proper Case User Defined Function
  372. Optimized statement for subquery using count(*)
  373. optimization challenge
  374. Problems with Database move - Windows to Linux
  375. EDU process dieing
  376. How to combine multiple input fields as single output field
  377. Trying to link to DB2\Linux
  378. output of DATE function
  379. Reorg : Require Urgent Response Plz
  380. IBM DB2 support in oXygen XML Editor
  381. Packages (Package "NULLID.SYSLH214 0X5359534C564C3031" was not found.)
  382. monitoring questions
  383. Convert Null in Date field to String
  384. correlation between ipcs -mb and db2mtrk
  385. Error code for Export
  386. SQL4304N RC=1
  387. SQLCODE: -443
  388. Net Search Extender
  389. Forum 2006 - Ambuj Goyal, GM IBM Information Management, keynoteat user group meeting
  390. how to shutdown only 1 database in a
  391. Is this possible with SQL?
  392. DB2 index related qusn
  393. Finding running SQL
  394. SOA - The movie
  395. Yellowfin leads the new players in taking business intelligence mainstream.
  396. Data Warehouse: Invoke a user defined program
  397. Benchmark comparisons of IDMS and DB/2
  398. NoClassDefFoundError:sqlj.framework.ClassFileReade r
  399. Determining same row in update trigger
  400. DPSIs: Materialisation of column values for DPSI use
  401. how to convert clob to other data type ?
  402. index on global temp table
  403. SQL Procedure Question
  404. correlated update headache (db2 unix)
  405. host variables in cobol program
  406. How to delete some DB2 packages
  407. com.ibm.db2.jcc.b.SQLException - URGENT
  408. Howto refresh cataloged database?
  409. DB2 UDB for Windows needs to emulate a DB2 UDB for z/OS function
  410. UNION ALL and OR Predicate optimising vastly differently ?
  411. db2advis giving trouble
  412. data clustering.
  413. INDEXREC set to access : Poor Performance
  414. How to signal a warning inside a trigger ?
  415. DB2 v9 web services sample doesn't work?
  416. slow connection to DB2/LINUX 8.2.3
  417. DB2 Java INSERT-Statement / truncate
  418. DB2 job in Brussels Still open
  419. DB2 trigger HELP
  420. Connecting to DB2 from MS Query
  421. DB2 connectivity with WAS
  422. how to release appropriate locks using CLP
  423. how to release appropriate locks using CLP
  424. Implicit Commit On DB2-Transaction On Termination Of Process
  425. Strange IMPORT warning
  426. Partial Transactional Integrity?
  427. php code is not running after migrating the DB2 Connect EE from V7 to V8
  428. Conversion of packed data to db2 date
  429. DB2 on Z/OS - SQL w/o SPUFI / QMF kinda tool
  430. how to reset tablespace high watermark counters?
  431. I/O cost of an NLJOIN
  432. Backup in Db2 Linux and Restore in DB2 Windows
  433. Statement monitor output as db2 table
  434. connect to UDB from host AR
  435. DB2 Command Line Processor (CLP) - How to turn autocommit off within CLP?
  436. SQLCODE -1078918717
  437. DB2 WSE 9.1 och RH AS 4 x86-64
  438. Syntax to Create MDC Table
  439. Variable in SQL-Script
  440. Replicating multple tables
  441. Replicating multple tables
  442. Using DW tools on DB2 Version 7
  443. can anyone suggest a more elegant solution to this?
  444. Test backup image
  445. Kerberos / Windows authentication
  446. Snapshot problem for dynamic-sql: zero cpu counters
  447. sql for db2 list db directory and db2 list node directory
  448. Optimizer's use of check Constraints ... ?
  449. dbsize
  450. DB2 query
  451. jak usunac zawartosc logów
  452. Does DB2 V8 support PMML?
  453. SQL error 805
  454. -30081 Solution
  455. How to administer multiple DB2 instances
  456. daemon for db2
  457. Autostart DB2 v9 on Linux
  458. IMPORT with some defaults
  459. Mesure Instances Usage in a DB2 server
  460. ALTER TABLE ALTER COLUMN
  461. Create multiple output files during a single unload on z/OS DB2 v8
  462. Db restore
  463. deploying java stored procedures using non standard jars
  464. db2expln output and operator information
  465. Possibly dumb IBM DB2 v8 triggers question
  466. Rebind operation locks up
  467. archive log backup doesnt happen
  468. DB2 GetSnapshot API
  469. DB2 job in Brussels
  470. ADMIN_CMD IMPORT and CODEPAGE
  471. Federation issue, DB2 to Oracle
  472. DB2 auto rebind lock-up
  473. Info-messages i db2diag.log even if diaglevel set to 3
  474. Use ODBC API to retrieve indexes and keys on AS/400
  475. MQTs and UDFs
  476. Strange problem after use coalesce()
  477. Connect & Disconnect
  478. Broken Pipe
  479. Creating User Defined functions in DB2 v7.1.2 OS/390
  480. two-phase commit in DB2
  481. Reg:db cfg parameters
  482. Create user in DB2 v8.1 FP11
  483. Performance issue in a partitioned database
  484. SQL Reporting Services (SRS) and DB2
  485. Hepl please - Product stop to work on DB2 v9.1!
  486. Erwin Reverse Engineering from IBM DB2
  487. Suggestion for select statement
  488. Connection from Rational Application Developer -> IBM v9.1
  489. Object creation
  490. Forum 2006 - A two-day IBM Informix and DB2 User Group TechnicalConference
  491. Forum 2006 - A two-day IBM Informix and DB2 User Group TechnicalConference
  492. db2pfchr taking lot of memory
  493. Transaction failed under DPF
  494. FYI: Technical whitepaper on compression a DSS environment
  495. Domestic Alternative To Offshore Outsourcing
  496. IMPORT with MESSAGES ON SERVER
  497. Unbelievable SQL0811N on scalar subselect
  498. concatenating historical records
  499. multiple tablespaces containers on SAN
  500. row-counts to BLOB size ratio
  501. question about java routines
  502. DB2 and extended ASCII table
  503. List tablespaces work, but not SQL
  504. case issue in fetchrow_hashref
  505. build index from key field
  506. Result set from ADMIN_CMD
  507. Non-Case-Sensitve LIKE Operator
  508. Back-Up of DB2 on 32Bit Windows, Restore on 64Bit Windows
  509. db2 command
  510. weird SELECT privilege issue
  511. Error formatting event log
  512. Error accessing Package SYSLH203
  513. Strange Archive Issues with the Netbackup.
  514. reorgchk_ix_stats and reorgchk_tb_stats
  515. How can I connect from DB2 to ORACLE Version 7.1 on VMS
  516. New hardware, copy databases?
  517. SQLWARN output
  518. Microsoft Cluster
  519. How to check DAS start up use ps command
  520. Yellowfin BI Suite are now validated on IBM's popular DB2 9 database
  521. Db2 invalid pool id error
  522. db2 hangs when using snapshot monitor on linux
  523. problem with udf
  524. How do I backup IDM DB2 database configuration parameters?
  525. querying from sysibm or syscat tables
  526. HADR: Automatic Takeover on Windows systems
  527. Express-C and Remote Desktop
  528. Bufferpool tuning hint
  529. Governor incorrectly forces processes
  530. recursive sql
  531. DB2 LUW on Linux
  532. Problem with VARCHAR FOR BIT DATA
  533. DB2 health checkup - help needed
  534. DB2 health checkup script
  535. Compilation error, stored procedure, sql, iseries v5r4 (as400), urgent help plz.
  536. SQL10004C An I/O error occurred while accessing the database directory.
  537. Trouble connecting to databases from DB2 9 - Command Center
  538. Upgrade IBM DB2 7.2 to 8.2 - Issues with Autocommit
  539. DB2 Scheduler on Windows stops scheduling.
  540. error logging functionality
  541. Developing application for DB2 Mainframe
  542. DB2 fixpak quite install
  543. db2 version 8.1 client fails on Windows 2000 server - help?
  544. Using WHERE condition in UNLOAD or LOAD
  545. Configuring Database
  546. switchover cluster
  547. I can't put a subquery into a coalesce in Z/OS DB2
  548. Testing for a Connection
  549. MQ Listener - anyone using this in a production and/or mission critical fashion
  550. db2ckbkp with leagto