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. HTTP Web Service Consumer
  2. db2 inplace reorg and log space
  3. Online Reorg of LOB data
  4. Federated Systems Question
  5. Accessing data from an intermediate results table
  6. Protocol specific error code(s): "10060", "*", "*". SQLSTATE=08001
  7. DB 2 content manager replication
  8. SQL1131N DARI (Stored Procedure) process has been terminated abnormally.
  9. db2 object comparison tool
  10. DB2 version 7 having paging space issue
  11. WIN XP Pro SP2 Db2 V8 install/setup message invalid password
  12. I Don't Need The Data I Need Only The Syspunch
  13. DB2 logging options
  14. DB2 HADR Logging options
  15. qurey for ibm db2
  16. Problem while calling java stored procedure which connects to db2.
  17. Unable to connect to DB2 v7.2 using JDBC Universal driver 4
  18. beginner XML extract question
  19. Oracle to DB2 DRDA connectivity
  20. DB2 Viper 2 beta - compatibility features Feedback needed
  21. [DB2 V9] Problem with Unicode in XML fields
  22. DB2 Viper 2 Open Beta - Enjoy
  23. Can anybody give me the exact syntax to rename a column in DB2??
  24. How to convert: Oracle to DB/2
  25. Event monitor db2detaildeadlock
  26. DB2Express conenct existing database
  27. DB2 Express 9.1.2 failed to install on Fedora 6.
  28. How can I bulk-load a typed table?
  29. How can I bulk-load a typed table?
  30. Error in reader
  31. Oportunidade DB2
  32. Create Function
  33. instance owner can't stop the instance
  34. Connection to DB2 using ODBC
  35. Int to Date in DB2 SQL on AS400
  36. Not all archive (offline active) logs are getting backed up
  37. How to install Fix Pack without stopping instance and das?
  38. Transaction Processing over XML (TPox): New Release (1.1).
  39. SQLSTATE 25501 invoking SPs from a J2EE DataSource connection
  40. Hibernate -- JDK 1.5 -- DB2 SQL CODE -4700
  41. Global Temporary Table and 'AS' clause
  42. db2 control center
  43. A recovery scenario
  44. db2 audit user activity
  45. delete with join - is it possible ??
  46. fullymaterializeLobData property for db2 jdbc driver
  47. Number of bufferpools.
  48. DB2 Database Management Services
  49. "Auto number" within a combination key
  50. DB2 protocol connection infomation
  51. Where Statement?
  52. Governor Question Iddle
  53. Differing query results based on access path
  54. problem facing in enabling the automatic db2 backup maintenance
  55. DB2 Books
  56. Load the PS data into DB2 tables
  57. Load the PS data into DB2 tables
  58. Error :- SQL1052N The database path "c:\mhi" does not exist.
  59. DB2 on Solaris X86
  60. Can Anyone Give Dumps For Db2-703 Exam
  61. DB2 User Defined Function
  62. Declared Global Temporary Table on z/os v7
  63. HADR questions
  64. query
  65. reading xml using stored procedure
  66. How to get the Optimization level?
  67. bulk loading into a table with "not null" column constraints
  68. Page Size
  69. embedded sql application fails on Suse (powerPC)
  70. IBM DB2 Content Manager eClient v 8.3 installation fails
  71. SET statement in a stored procedure
  72. Package "NULLID.SYSLN30F 0X5359534C564C3031" was not found.
  73. How to use NULLS first
  74. hi all
  75. snapshot monitor performance issue.
  76. MAINFRAME/ DB2 DATA MODELER/ CONTRACT/ MO
  77. Select query with column positions insted of column names
  78. getProcedures() interface method doesn't return the functions
  79. CAST sql statement
  80. Problems Updating via Oracle DB link to AS400/DB2
  81. Stored procedure failing on nightly cycle
  82. Software Testing
  83. long running query
  84. Arithmetic overflow
  85. Create a stored procedure that will load a csv file
  86. Unicode and UTF-16
  87. combining results by unique id
  88. Automatic Timestamp
  89. TesterQA is a Leading Software Testing site
  90. Reporting On DB2 Performance
  91. SQLCODE: -904, SQLSTATE: 57011, SQLERRMC: 00C90090;00000801;NULLID.SYSSTAT.5359534C56
  92. Counting in SQL with breaks
  93. Automated Testing
  94. ADMIN_LIST_HIST table function
  95. Maximum size of table is 512G??
  96. HADR and REORGS
  97. Sorting weirdness?
  98. Space being used by a table with long data and lob fields
  99. Software Testing tool Rational Robot Tutorial
  100. How to get unicode value from aN UTF-8 character
  101. db2pd: "Changing data structure forced command termination"
  102. SQL to get table names from view
  103. Merge statement in db2
  104. external db2 UDF in C compiled on AIX
  105. Question about table space rebalance
  106. using level number 49 in dynamic sql for declaring group variables
  107. Aunthentication Question
  108. advise for INTRA_PARALLELISM
  109. trigger with delete statement gives error "DIA8309C Log file was full."
  110. fixpak 15?
  111. Setting locktimeout value
  112. Migrate 4K Tablespace to 8K Tablespace in DB2 v8
  113. connect from host(z/os) to a mssql server
  114. Blocked SYSIBM.SYSTABLES
  115. throwing error when creating procedure
  116. Reg : File transfer using SCP script
  117. How to simply insert or update to a BLOB column using data from file
  118. SQL Query to list table(s) in LOAD PENDING
  119. load stored proc from ant.
  120. STMM with multiple instances/databases
  121. Call Procedure
  122. Set Declared Variables...
  123. db2gov - idle....
  124. Strange Reorg response time
  125. DB2 V9 Installation Problem
  126. Advanced SQL Query - Grouping Results from One Column into Multiple Columns
  127. Custom Software Development
  128. increase sequence value more than one
  129. Express-C V9.1, JCC Driver and SQLException.getMessage()
  130. DB2 Access with Unix Shell Scripts
  131. How to set langauge environment of machine(Windows) to french in DB2?
  132. Migrating from 7.2 to 8.1
  133. db cfg: CATALOGCACHE_SZ obscurites.
  134. SQL - Sum of rows containing non-numeric values
  135. Question on DB2 Fetch
  136. ADD DBPARTITIONNUM fails on Linux
  137. Getting SQLCODE -302 after migrating DB2 V7 to V8 IN ibm z/os
  138. Data type convert issue
  139. Overflow error????
  140. ANNOUNCE: Altova 2007 Release 3 available
  141. problem with db2 commit on aix (lock and cuncurrency)
  142. Invoking excel APIs through DB2 with any native interfaces
  143. rollback load by cursor
  144. Dynamic SQL
  145. syntax differences from oracle to db2
  146. Version of DB2 9 Information Center that doesn't require admin authority to install is now available.
  147. Redirected Restore and container removal
  148. DB2 Page Cleaners
  149. problem with memory heap
  150. DB2 views - Read Only
  151. SQL - Select ALL rows
  152. Vsam
  153. Convert TIMESTAMP to DATE
  154. DB2 Connect
  155. Count() and count(*) in DB2
  156. load in db2
  157. Anybody using DB2 9 on Linux x86, please, examine...
  158. Interpreting dynamic SQL snapshot
  159. query to compare two dates
  160. [db2 v7 windows] lob and delphi application using ADO
  161. If exist ?
  162. Undocumented error message -
  163. z/OS DB2 catalog backup question
  164. DB2 Exception thrown after processing 600 odd rows
  165. Advanced SQL - Multiple Count statements in one select
  166. how to get the complete list of child tables and their child tables and so on...
  167. DB2CODEPAGE related query
  168. CLI0109E String Data Right Truncation SQLSTATE=22001
  169. Perl DBD::DB2 Connection Error
  170. Cannot connect to database
  171. Database Roles problem
  172. Problem with CLOBS
  173. DB2 Backup failed-Disk was full
  174. Predicate equivalence: concat vs. AND
  175. Begginer problem in DB2 + Microsoft Visual C++ .NET
  176. question: db2 LUW V8 UNION ALL with table function month() have bad query performance
  177. Book recall
  178. Need Dump for exam 000-7001
  179. An error during CICS precompilation
  180. Fast Track Courses on Automation and QTP Basics and Advanced, and Quality Center
  181. XML... DB2 v8.2
  182. ALTER BUFFERPOOL with no DB connect
  183. DB2 doubt
  184. Need help
  185. DB2 connect gw on zLinux TCP/IP problem after DB2 server IP change
  186. UDF with AIX API
  187. Altering the type of a VARCHAR column to be VARCHAR FOR BIT DATA
  188. Recursive UDF
  189. StaleConnectionException: com.ibm.db2.jcc.b.DisconnectException
  190. Advanced SQL - Extracting values by months
  191. Migrating from Berkeley DB to DB2 Express-C
  192. DB2 (v9fp2/linux) has 4G limit for DEVICE containers ?!
  193. Migrate from BIG5 to UTF8
  194. URL of info centre download for v9
  195. Update table + select on same table
  196. Updating a large table
  197. Begin Tran??
  198. Why is my program taking so long to run?? Please Help...
  199. Multiple Temp Tables
  200. Restoring selected tables / table data
  201. update with random eight digit number
  202. Return status from a stored pros in a OS script
  203. sql query for displaying only column names
  204. Range Partitioning
  205. Restore between Platforms
  206. Tivolli ldap migration
  207. DDL
  208. db2 dba needed
  209. Maximun number of schema per Db
  210. What's the meaning of DISK
  211. Db2 connectivity with lotus domino using odbc connection
  212. SQL Query - modifying return values
  213. SQL1092N "" does not have the authority to perform the requested
  214. Cannot load driver while using jdbc in eclipse plugin
  215. how to select a table that has most columns using syscat?
  216. MDC vs optimizer
  217. [question] db2 v8, how to force applications which status in "Federated request pending"
  218. Problem Dropping Members from a Replication Set db2v8 AIX 5.2
  219. RAID 5 DISKS
  220. finding multiple keywords in aparticular string
  221. Do calculation in Char filed
  222. Please, help me with use db2 function in PreparedStatement
  223. Please help with installing db2 V9 on debian
  224. Invalid pointer when accessing DB2 using python scripts
  225. Invalid pointer when accessing DB2 using python scripts
  226. Command to bind all the packages
  227. Share nothing cluster architecture
  228. 9.1 Problem changing logging to circular
  229. Sqlstate: 22007
  230. case insensitive ??
  231. SQL1131N DARI (Stored Procedure) process has been terminated abnormally
  232. JOB POSTING: Looking for a senior database manager /department head/ architecture
  233. DB2 connectivity with JSp
  234. Migrating from DB2 on z/OS
  235. OS X and DB2
  236. wat difference b/w rdbms and dbms
  237. DDM TCP/IP communications error occurred on recv() - MSG_PEEK
  238. DDM TCP/IP communications error occurred on recv() - MSG_PEEK
  239. SQL compiler and buffer pool
  240. Case-insensitive Custom Collating Sequence
  241. Compare two idetical tables and update the table
  242. SQL4401C The DB2 Administration Server encountered an error during startup
  243. DB2 export to flat file
  244. Software testing tools
  245. how to find the sizo of perticular table in DB2
  246. how to transfer data from DB2 to SqlServer
  247. Dynamic insert via stored procesdure
  248. can not drop table but can not find dependence either
  249. capture-schema
  250. DOS Scripts and/or Task Center Help
  251. GROUPING IS INCONSISTENT error message
  252. To get the number of rows affected by a cursor open
  253. Sqlstate=58004?
  254. check pending state
  255. how to access db2 tables on aix from db2/390
  256. Temporary Tables and Cursors to read them
  257. pureXML support in DPF
  258. JDBC Connection to Universe 10 with Web / no Web
  259. Governor Set limit to user Help
  260. Create a table using triggers
  261. Database connection through SP
  262. DB2 and ODBC - Function sequence error
  263. calling a Websphere application out of a Stored Procedure
  264. Problems calling proc from MSVC via ODBC
  265. db2pd locking
  266. Estimate tablespace size
  267. Table size
  268. Migrating IBM Universe Database to Oracle 9i database
  269. fail to install db2 net search extender v8.2
  270. db2 udb v9 SQL6031 error on Fedora core 6 linux
  271. How can I determine the last row inserted
  272. Query Select Help
  273. DB2 9 books
  274. Help withDB2 Recover Command
  275. Question about DB2 + RedHat
  276. db2 command not found -tvf - Plink in AIX vs. Linux
  277. How to update txn table into master table ?
  278. DB2 Log files on the mainframe
  279. is there any way to go back to the line that calls a GOTO?
  280. So you think your database is secure!?
  281. Help Needed on REORG inquery
  282. SQL unexpected 'null' error from a User Defined Function
  283. FILTERING LEFT TABLE IN LEFT OUTER JOIN
  284. Is there a way to rename a table creator?
  285. Database Marked Bad
  286. how to insert a blob in cobol ?
  287. Problem in configuring DB2 to access INFORMIX
  288. can db2advis be told a non default schema?
  289. Deleting the data from table having an identity column using DB2 utilities
  290. operation has been cancelled by user
  291. What is the best way in SQL to convet GMT timestamps?
  292. ALTSEQ in logical files
  293. SQL0206N during create trigger...
  294. Recovering from a failed installation
  295. Include date time with VMSTAT
  296. DB2DataAapter.Update() Method error
  297. HADR and Federation
  298. Software Testing Tools
  299. Tagging a table volatile causes performance penalties
  300. Does concat have limits?
  301. Column size for Multibyte data
  302. installing db2 udb v.8 on AIX
  303. sqlp_AsyncLogReadAPI, sqlcode - 2650 rc1
  304. error while startin DB2
  305. why do proC files to be binded to DB2 Database
  306. DB2 Datatype Determination in DB2...
  307. Data type determination in DB2..
  308. Universal JDBC driver for DB2
  309. ADMIN_CMD and EXPORT
  310. Control Center not listing Database
  311. PL/SQL programming in DB2
  312. How to get a list of the db2 subsystems on a S/390 system?
  313. temporary tablespaces requirement size for creating indexes
  314. why DPF?
  315. EXPORT and Delete
  316. z/OS DB2 Administration Server - BPXF024I
  317. columns in index
  318. db2level not giving correct information
  319. db2 tablespace error on multiple logical partition on one aix machine
  320. Offline reorg slowed performance
  321. Must read vast collection of software testing articles
  322. db2move - not downward compatible ?
  323. How do I call a COBOL program from a stored procedure?
  324. db2cos script
  325. Rollforward
  326. Renaming a Database
  327. Which transaction log files are obsoleted by BACKUP ONLINE?
  328. About Image Storage
  329. SqlSpec NFR licenses for community contributors
  330. Funny error message UDB v8.2 linux
  331. odbc connection string not honoring userid
  332. Error: SQL0805N when attempting to drop a package
  333. secondary logs and logarchmeth1
  334. secondary logs and logarchmeth1
  335. Instance vs. Node (Newbie)
  336. HADR and container paths
  337. getting sqlcode -206
  338. Sqlcode -144
  339. Configuration Management
  340. Non-fatal Assertion Failed
  341. determining codepage of a database
  342. Changing AIX hostname - will it upset DB2 ?
  343. db2 transaction log isssue
  344. Function invocation
  345. whats wrong with my cursor?
  346. Error DIA5000C A DRDA as Token "RECOVERABLE" was detected
  347. Consideration in chosing DMS container type
  348. Error Message - 111 "The file name is too long."
  349. HADR and Archived Logs
  350. Primary Key and indexes
  351. DB2 Install in HA environment
  352. Is 704 certification worth ?
  353. BEFORE Insert - Trigger problem
  354. ODBC connection gives Token <END-OF-STATEMENT> was not valid
  355. MERGE statement using PreparedStatement in JAVA
  356. To Knut about DB2 V7 Fixpak FP2_21246
  357. Db2 Load_file
  358. Browsing whole table?
  359. Getting exception in Java application with error code "DB2 SQL error: SQLCODE: -901"
  360. Yellowfin Version 3.2
  361. DB2 Problem with type 4 jdbc driver
  362. WINS(wheatly insurence)
  363. Tivoli Data Warehouse
  364. How to call compound SQLs within a stored procedure
  365. Convert text to number using SPUFI
  366. Need help on DB2 Stored Procedures
  367. Console instalation of DB2 v9
  368. Oracle 9i Database Administration in 10 Minutes
  369. db2 fixpack error for version 9
  370. db2 restore error message
  371. query sql server/oracle table from Db2 or join db2 table with sqlserver table
  372. query sql server/oracle table from Db2 or join db2 table with sqlserver table
  373. DB2 v9 Q Capture failure
  374. Install DB2 on Linux MC/ServiceGuard Cluster does not work
  375. Install DB2 on Linux MC/ServiceGuard Cluster
  376. how to use pam authentication in db2 udb?
  377. SQLCODE -182 (Urgent)
  378. Specified driver could not be loaded due to system error 5.
  379. How to convert ZRC code
  380. Specified driver could not be loaded due to system error. 5(IBM DB2 ODBC)
  381. Sqlcode -182
  382. Select Max Column - Query
  383. DRDA Communication Manager, sqljcReceive, probe:30 MESSAGE : CCI Error:
  384. 2 Questions in rollforward operation
  385. Need Help to Compile Stored Proc in Db2 v 8.1
  386. db2 LUW v8 after inser trigger encounter error sql0348
  387. DB2 driver with Websphere
  388. CMMI Resource
  389. Interesting problem migrating 7.2 ->8.2
  390. Detected the death of an EDU
  391. How to monitor db2 executing trigger activity ?
  392. death knell for Informix
  393. How to monitor db2 executing trigger activity ?
  394. Selecting set of rows from table
  395. UDB 8.2 Fix pack 14 not working on windows 2000 server
  396. DB2 Express - cannot create database!
  397. Hello?
  398. Why relational division is so uncommon?
  399. Select Sub Query in Select Clause giving error
  400. How to monitor db2 executing trigger activity ?
  401. [Question] how to monitor db2 trigger activity ?
  402. select DB2 Query
  403. DB2 SQL Course
  404. Monitoring LUW UDB performance
  405. Trigger to "inhibit" Insert without gving error back to the calling statement?
  406. Create new DB in DB2
  407. default value in db2
  408. Case statement
  409. Selecting one arbitrarily chosen row from each group
  410. DB2 V7 Import/Run Script problem
  411. URGENT. Can't get a cast to work...
  412. UDB Range Partitioning in V8: Using Ranges in Constraints
  413. ASUTIME?
  414. runstatic from my db2 client and it hang on
  415. DB2 LUW database monitoring
  416. Using SQL to Manipulate Timestamps using Quarterly data
  417. DB2 Backup coding page conversion
  418. db2 connection lost from my db2 client on window to aix server after some time
  419. DB2-DB2 migration toolkit
  420. DB2 and ORACLE in XA transaction
  421. FOR READ ONLY clause
  422. Lock debugging by the ordinary user?
  423. Date Arithmatic
  424. HADR and db2 log question
  425. HADR and JBoss
  426. DB2 Connect
  427. Error modifying data in control center
  428. Running SQL PL stored procedure
  429. remote db2 server
  430. Excellent SCM Resource
  431. Question regarding db2 fundamentals 730 exam
  432. Error connecting to V9 remote database
  433. Inserting 99999.99 into a FLOAT 17 16 field results in 5 being added to the end of the number
  434. lowering high water mark on index tablespace?
  435. LOAD trouble
  436. DB2 CODE SECURITY??
  437. CALL SQLEXEC "CONNECT TO ......."
  438. Can't install DB2. It tells me its already installed.
  439. How to select the data which have space end of string one or more
  440. How to remove transaction logs in HADR?
  441. db2adutl query logs showing logs every second
  442. When will DB2 get MVCC?
  443. Unable to Build Stored Procedure
  444. Trigger problem DB2LUW
  445. Statement not protected
  446. How to read ixf file in ascii format
  447. Exporting dbcs character in db2
  448. 2 aliases that mapping to the same tools catalog database!
  449. Netbackup restore failed
  450. nextval for sequence in an insert statement vs nextval in an insert trigger
  451. use "setup /i xx" cannot work while installing DB2 Client FP2
  452. Declaring a Condition handler in DB2 Stored Proc
  453. DB2 Load utility and Commit function
  454. Can you use "with hold" with a prepare statement?
  455. How to collect DB2 Database size Version Lesser than 8.2
  456. ha_db2stop or db2stop?
  457. Simple Query Questions
  458. Need help with a performance of a query.
  459. DB2 V 9.1: JDBC driver: How to set default schema
  460. Copy ADMIN_CMD stored procedure between servers
  461. Getting values from db2 procedure in a shell script
  462. left outer join with subselect
  463. DECODE in DB2 8.1?
  464. DB2 UDB & C runtime environment components
  465. DB2 Stored Proc help -- Urgent please
  466. db2exfmt - Earlyout, Fetchmax, Iscan Operator
  467. db2exfmt - Earlyout, Fetchmax, Iscan Operator
  468. AFTER INSERT ON TRIGGER
  469. Automatic Storage ### How I need to expand the DMS tablespaces manualyy##
  470. Raid 5 or Raid 10?
  471. Yellowfin Argues Embedded Business Intelligence Is The Future.
  472. Instance crash: playing with cursor's holdability
  473. script in makefile problem
  474. Table View SQL statement
  475. VERITAS netbackup failed on AIX DB2
  476. restrict creating table in other existing schema
  477. DB2 SQL PL advice
  478. DB2pgm executed from RUN DSN fails
  479. Possible reason for this message in db2diag.log (II)
  480. Possible reason for these two error messages in db2diag.log
  481. diff
  482. Some Basic DB2-SQL Questions
  483. tablespaces
  484. syscat.package.valid <> 'Y', how to figure out which object thatis related to package?
  485. different lock behaviour with forward only and static cursors in DB2 V9 via ODBC
  486. Who can help me with DB2 synax?
  487. How to set a null for a new column in DB2?
  488. stored procedure compile error
  489. IMPORT incompatible with INSTEAD OF triggers?
  490. stored procedure compile error
  491. unpack fixp14
  492. IBM DB2 Network Stack or packet Structure
  493. Connection Concentrator only support in DRDA environment?
  494. Multiple column updates in a single query
  495. Help with sql script that creates a table if it doesn't exist
  496. Thinking in Sets versus Procedural code
  497. array in db2 using Java
  498. How can i tell which interface the db2 instance is listening on
  499. XA Transcations in DB2
  500. Exporting DB2 Resultset to UNIX shell script
  501. A complaint about online Information Center
  502. Change instance home dir and owner
  503. convert current date to integer as in YYYYMMDD
  504. SQL0954C Not enough storage is available in the application heap to process the statement. SQLSTATE=57011
  505. Creating db in 2 partitions out of 8
  506. Optimizer questions
  507. large Union and Access path.
  508. DB2 and REXX
  509. translate SQL Server query to DB2
  510. how to db2cmd commands for udb
  511. Downgrading DB2 8.2 --> DB2 7.1
  512. SQL puzzle
  513. Strange query
  514. DB2 UDB User Exits
  515. ant and db2cmd help please
  516. Urgent :: Problem with Environment variable ??
  517. Inserting same data into a DB2 table every every week/until a condition is met
  518. enable automatic storage management or not?
  519. Database and server setup question
  520. Drop all objects in one schema
  521. Performance parameters in db2
  522. db2 command line help for UDB v8.2 Linux
  523. Interrupt handlers in DB2 ??
  524. is there any password criteria for DB2 administration server user?
  525. Migrating an old OS/2 server
  526. TSM Keep a Specific Backup with db2adutl
  527. Web Service call from DB2 stored procedure
  528. Hash join overflows
  529. DB2 command question
  530. Problem setting up new instance.
  531. unused indexes at database level
  532. Migrating Mainframe Database to UDB in Linux
  533. Installation DB2 using command line
  534. doubt in a query
  535. Rowlock in insert query
  536. Rowlock in insert query
  537. Unable to find the Parent table name if the child table is known also
  538. DB2 COBOL stored procedure to UDB SQL stored procedure
  539. how to update syscat.tabconst?
  540. federation and functions
  541. Cobol /db2 Blob Retrieval
  542. Error -0911
  543. Subquery with DB2
  544. bad timestamp / sqlcode - 180
  545. Linux and ODBC
  546. db2/sql error codes
  547. Connection Pooling
  548. Backup Of Atable In Db2
  549. Non-Admin DB2 Usage
  550. "WITH REPLACE ON COMMIT PRESERVE ROWS NOT LOGGED IN"