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