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