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