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