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