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