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. Upgrade IBM DB2 7.2 to 8.2 - Issues with Autocommit
  2. DB2 Scheduler on Windows stops scheduling.
  3. error logging functionality
  4. Developing application for DB2 Mainframe
  5. DB2 fixpak quite install
  6. db2 version 8.1 client fails on Windows 2000 server - help?
  7. Using WHERE condition in UNLOAD or LOAD
  8. Configuring Database
  9. switchover cluster
  10. I can't put a subquery into a coalesce in Z/OS DB2
  11. Testing for a Connection
  12. MQ Listener - anyone using this in a production and/or mission critical fashion
  13. db2ckbkp with leagto
  14. hl7 xml schema register problem with xerces library of DB2 Express-C v9
  15. DB2ADVIS Error: SQL0444N Routine "*IZE_INFO" (specific name "GET_DBSIZE_INFO")
  16. install UDB / DB2 on CentOs
  17. Determinining which PRODCEDUREs need to be REBINDed after a TABLE DROP/CREATE
  18. Choosing a good ibm db2 replication product
  19. db2admin server doesn't start, SQL1042C on AIX
  20. db2 8.1.5 how obtain machine name
  21. Migrating a Windows DB2 8.1 to DB2 8.1 database system on AIX 5.3
  22. Unable to grant execute privilege (Urgent)
  23. Returning rows after select for update and update current of
  24. db2audit - AUD00003N, I/O Error
  25. Divide the registers of table among process with Java and Stored Procedures
  26. jdbc statement.setQueryTimeout
  27. tablespace / container info from a backup image
  28. input indicator variables
  29. DB2 7.1 encryption Urgent Help
  30. DB2 v7.1 on ZOS 1.6 encrytion
  31. Can't query or drop a table
  32. How to create a query in a .bat file
  33. Migration from udb v7.x to db2 v9: a stupid simple question
  34. db2 CASE or CAST problem
  35. delphi -> db2 xpress 9
  36. determining which rows fall in which partition
  37. Accepting user inputs in DB2 UDB? (Oracle & syntax)
  38. Call stored proc inside another stored proc
  39. IBM DB2 question - Update 2 different tables based on IF THEN ELSE criteria
  40. Configuring Extent Size
  41. SQL Dynamic Table Count Select Assistance
  42. Difference between DB2 9 client and DB2 9 runtime client
  43. DB2 UDB LUW DB2 LOG API : Table descriptor record (how to compose the )
  44. javaw error, 28132
  45. DB2 governor, is setlimit clause measured across one SQL,UOW,connection?
  46. Any Links for information on db2 parameters
  47. Regarding DB2 EEE
  48. Regarding DB2 EEE
  49. MS-Access and IBM DB2 ODBC driver
  50. DB2 iSeries/AS400 vs. DB2 ESE Windows/Linux
  51. How to force the join order ?
  52. Local database requiring userid/password
  53. Health Monitor memory problems.
  54. What is the API to call terminate
  55. db2start fails after attempting to catalog node
  56. getGeneratedKeys() problem
  57. SP returns resultset in Control Center, but empty resultset from command line
  58. Trigger problems in DB2
  59. DB2 Z/OS - Cross Region Alias Not Working v8 Clients ?
  60. user exit problem
  61. LOG files not in a readable format
  62. significance of SQL state?
  63. UCASE really slows queries down
  64. set integrity command
  65. DB2 CLI Performance Probelm
  66. querying backup process
  67. Newb Query About Reconnecting aplications to DB2 Server
  68. Online Reorgs and logging
  69. Relationship between recv_hist_retentn and archive log files
  70. Export Command - How to generate a row with column headers
  71. Maximum Number of Connections has been removed (JR18223)
  72. What's the meaning of the error code
  73. transaction-log memory mapped on AIX ?
  74. Waiting for remote node - Why?
  75. cygwin - db2 v9 on windows
  76. DB2 - Beyond case statements
  77. Software Testing Portal
  78. DPF failure to connect
  79. ADO.Net Application compatibility between fix pack lvl on build PC and fix pack lvl on deploy target
  80. Export Command SQL with carriage return
  81. Not getting sqlcode 100 at end of fetch
  82. drop 'Not Null' constraint
  83. DB2 deadlock while accessing plan?
  84. DB2 stored procedures
  85. How to find table modification time?
  86. Packaging DB2 jdbc driver with an application? Why not?
  87. db2 client traces
  88. T-SQL FROM SQL to DB2
  89. Creating a DB on a partition environment
  90. SQL0902C : Subsequent SQL statements cannot be processed
  91. OLAP windowing legerdemain
  92. IllegalAccessError since db2 9 and java 1.5
  93. Recovering tables from DB2 V2
  94. ibm preps ?
  95. Insert Into Select - I need each row Selected to be dependent on orecords previously inserted
  97. HELP! Create Database problem
  98. invoking db2diag tool on win32 (UDB 8.1 version)
  99. self_tuning_mem on
  100. Selecting Next Value Only...
  101. Unable to configure PHP with DB2
  102. SQL1326N The file or directory cannot be accessed
  103. If I have a license for DB2 V9 ESE for the appropriate number of CPU's
  104. query question...
  105. warning message along with result set
  106. DB2 JDBC Applet Server service terminated unexpectedly (db2jds)
  107. Drop all foreign keys
  108. Commit during insert
  109. SQL Locks
  110. DB2 license for Range Partitioning with DB2 V9 ESE
  111. question about "select * from new table (update ...)"
  112. An SQL error "-911" occurred during processing
  113. Could someone please say something on my issue?
  114. DB2 Clustering
  115. db2javit rc : 9505
  116. "MESSAGE : DPS not initialized for this application" - what is it
  117. stale statistics or whats the difference?
  118. handling DB2 warnings
  119. DB2 post FP13 crash
  120. Artificial Mind - Part One - Basic Architecture and Cognitive Structure is now available
  121. fixed length host variables for VARCHAR fields
  122. Sql Trigger or Key Constraint or Check Constraint
  123. SQL2036N when backing up to CIFS
  124. Password too short?
  125. Password too short?
  126. An interesting issue with DB2SystemMonitor
  127. Error: SQLCODE: -805, SQLSTATE: 51002, SQLERRMC: NULLID.SYSLH205 0X5359534C564C3031
  128. Sorting UNICODE as EBCDIC
  129. Display table structure graphically
  130. Getting SQL30082N resaon 19 on DB2 9
  131. DB2 700 exam
  132. Query help
  133. 'list applications' privilege??
  134. How do I clear event monitor files?
  135. Domestic Alternative To Offshore Outsourcing
  136. STMTHEAP Issue
  137. Type 4 JDBC driver Bug Check thrown
  138. UNLOAD utility (mainframes) - UNICODE to EBCDIC
  139. Stored Procedure/ UDF not available in DB2 Express Edition ?
  140. load from cursor vs delete/insert
  141. _ in LIKE
  142. DB2 temporary tables help
  143. "WITH UR" in a UDF
  144. Scheduler in db2 v8.1.12 Linus
  145. DB2 LUW Trigger using sqlstate
  146. db2updv8 problem
  147. Declare variables and assigning in SP's
  148. XML, ETL tool and db2 Version 8.2 FP13 on AIX
  149. Db2 backup
  150. DB2 Restore V8.2 Express
  151. DB2 auth problem
  152. Disabling the behavior of RESTRICT
  153. DB2 V8.2 Data Import
  154. Transaction effect PHP+DB2 v 8.1.12 Linux
  155. DPF related info
  156. How to read tables from DB2 and write them in txt file using JAVA Code?
  157. I need lock a row on DB2 Iseries
  158. tablespace query
  159. need a query...
  160. Db2 Min Value with Char field.
  161. Access plan question
  162. Client side alternate server
  163. Just Upgraded - Problems...
  164. How to Find which SQL Statement is executing
  165. DB2 - Move data from an AS400 to an AIX system
  166. COBOL User Groups Newsletters - Call for Articles
  167. query help
  168. query help
  169. Using application data in query
  170. Compilation for different fixpaks
  171. Slow prepare times for inserts
  172. how to set idle time out
  173. JDEdwards date
  174. Has anybody worked on Q replication trouble starting the capture
  175. JDBC Timezone conversion
  177. High Water mark in db2
  178. Easy & safe deletion of inconsistent rows
  179. Question of DB2 Connect gateway
  180. FYI, DB2 FP13 (or should I say 11) instructions are incorrect
  181. Avoid data conversion in DB2
  182. Confused about the archive parameters
  183. Password Security Policy in DB2
  184. Setting up a linked server in MS SQL using IBM OLE DB PRovider for DB2
  185. Need to know which indexes need to be rebuilt and command to do so.
  186. Queries against a table
  187. Insert statement taking a long time to complete.
  188. (CORRECTION!) DB2 XQUERY can't serialize unicode string??? STATE 2200W
  190. DB2 XQUERY can't serialize unicode string??? STATE 2200W
  191. DB2 SQL1822 error code 408
  192. AIX queue_depth for SAN hdisks for DB2 file-dms containers
  193. Assistance with DB2 Query
  194. New to Db2 Stored Proc
  195. Using as in a cursor
  196. LOAD with UPDATE
  197. SQL0901N on CONNECT
  198. DELETE causing performance issues
  199. Time is running out to register for IDUG 2006 - Europe
  201. DB2 authentication
  202. Domestic Alternative To Offshore Outsourcing (Mainframe)
  203. Update with join statement not working in DB2
  204. configure PHP with IBM-DB2
  205. Visual Explain - Estimated Processing Time: Not Available - how come????
  206. how to get the last generated value of an identity column for a given table ?
  207. When execute dynamic generated multiple OPENQUERY statements (which linkes to DB2) in SQLServer, I always got SQL1040N The maximum number of applications is already connected to the database. SQLSTATE=57030.
  208. db2load remote database
  209. isolation level
  210. Lock mode converting from NS to X, when will this happen?
  211. Is this legal db2 sql ???
  212. dynamic cursor name?
  213. Session tables in triggers. Is it planned?
  214. Index not used only on a particular environment
  215. cursor in procedure
  216. Default Allowed Access for RUNSTATS?
  217. db2 connect server fixpack 13 on Microsoft Cluster
  218. Restore utility ignores USER clause?
  219. Restore utility ignores USER clause?
  220. Authentication Question
  221. Difference between DB2 UDB V8 Fix Pak 7 and V8 UDB Fix Pak 12
  222. DB2 ODBC Connection Expiration
  223. DB2 HADR software
  224. Problem relating to running Stored Procedures
  225. Db2 Hadr ???
  226. Question regarding CLI array Insert
  227. 9.1 db2look against 8.2 database
  228. DB2 arithemtic division
  229. Regarding Replication DB2 UDB
  230. Cannot uninstall DB2 in UBUNTU
  231. DB2 Audio extender start fail
  232. db2audit fails to create audit.log
  233. DB2 with MQ(XML) Functions, MQ Listener
  234. currency format
  235. A question of DB2 authentication
  236. When will LOAD utility check consistaint
  237. Which storage should be using for Enterprise Applications?
  238. DB2 - XML and Spatial data in same column - can't alter table once created - PLEASE HELP
  239. error mapping file SQL0966N SQLSTATE=57013
  240. DB2 SQL Query export to flat files as a function of data on each record
  241. code
  242. Very slow INSERTs - URGENT
  243. Yellowfin Reporting Release 3 OLAP Connectivity
  244. How to call the C stored procedure in SQL stored procedure in DB2
  245. Regarding db2 udb Replication
  246. Regarding Replication in DB2 UDB
  247. connect db2 with tomcat 5.0
  248. LOAD utility followup
  249. MDC+partitioning+compression
  250. column types in DB2 vs. other DBMS
  251. select from table function where argument is a result set
  252. db2app.dll and AIX
  253. AS400/DB2 table view compatibility
  254. db2 database returns ebcdic
  255. How do I get DDL for a UDF?
  256. Where could I get the fixpack for DB2 on EM64T?
  257. Exam 703
  258. DB2 on NetApp Filer
  259. db2 load performance
  260. OT : Carriage return
  261. JDBC Driver Versions
  262. MS Accesss 2003 ODBC to DB2 - BIGINT doesn't work ?
  263. Visual Explain for DB2, no access plan
  264. DB2 per ODBC ansprechen
  265. Help regarding INDEX
  266. plz help urgent
  267. Help W/ Auditing Unix Db2
  268. Locks held from snapshot on db and on locks is totally different
  269. Instance Crash
  270. Install Application Development Client for DB2 V7 in AIX 4.3
  271. Locks maintained on Command Editor (DB2UDB V8) despite autocommit on
  273. Reduce High water mark
  274. dynamic sql snapshot vs static sql snapshot
  275. How to give database drop privelege to a user/group on Windows?
  276. How to give database creation privelege to a user on Windows?
  277. Make group an owner of db2 objects
  278. GRANT statement gives authorization id not valid error
  279. DB2 UDF as module (was:DB2 UDF timeout)
  280. z/OS UDB 8.1 and Functions vs Stored Procedures
  281. DB2 backup and connection timeout
  282. Regarding Replication in DB2 UDB
  283. Retrieving table SQL text
  284. DB2 Foreign Key Indices
  285. question on lock list
  286. IDUG 2006 - Europe DB2 Conference: Early registration savings end 14 September!
  287. DB2 UDF timeout
  288. urgent : stored procedure not accepting data string more than 1024 bytes
  289. DB2 SQL Procedure Multi User Env.
  290. I have no blog
  291. db2 trigger and foreign key constraint perfomace issue
  292. DB2 Export file type
  293. Does DB2 v 8.1 need UPDATE to get a pessimistic lock?
  294. db2_mmap vs create tablespace no file system cache option (concurrent i/o)
  295. error for eplain
  296. Nested ResultSets : Invalid operation: result set closed
  297. Cannot restore after Veritas Netbackup restores
  298. Subselect Row Restrictions
  299. DWB and Views
  300. Upgrading SQL replication from v8 to v9
  301. Why is SYSCAT.TABLES.TABLEID not unique?
  302. begin atomic for call in while fetching rows from cursor
  303. How I can delete rows in one table with foreign keys
  305. SQL0101N The statement is too long or too complex.
  306. create nickname
  307. How long to restore a sime large DB?
  308. Problem with dynamic sql in the procedure
  309. db2updv8: Fail to create routine SYSPROC.DB2LK_DEP_OF
  310. Choosing primary key / Unique Index
  311. snapshot_dyn_sql
  312. DB2 SQL1084C grief
  313. DB2 cross-platform RESTORE, tools for backup transformation?
  314. Oracle PRAGMA AUTONOUMOUS_TRANSACTION equivalent in DB2?
  315. Question about prefetchsize, containers and extensize
  316. Block comments in DB2 Command center
  317. stored procedure not accepting data string more than 1024 bytes
  318. Update with foreing key and primary key
  319. Seemingly Successful Inplace Reorg returns -1 Completion Status
  320. Perl DBD DB2
  321. MAX(SUM(SAL))not working
  322. Can we issue the "force applications" command from within a sql call?
  323. Clients Unable to access Server
  324. SELECT statement from within a Stored Procedure without INTO
  325. how to do sorting of double byte Japanese characters in db2
  326. UDB V8.2 : Append value to a column while loading using Method L
  327. Navigator Slow on ALTER
  328. Stolen Agent Question
  329. DWB and compare
  330. DWB and SQL Stored Procedures
  331. Adding new column to a table
  332. New White paper on DWB developers Work Bench V8 & V9 universal rdbms client
  333. db2start and db2stop commands giving problems
  334. Unable to debug a DB2 Procedure
  335. db2fmp
  337. backup to samba network drive fails the second time but not the first !
  338. How do I get the help
  339. What are good questions for a DBA?
  340. how to capture rows affected via merge command?
  341. Storage usage for Enterprise Applications
  342. Cursor - how does it behave
  343. Domino DECS-DB2-ODBC vers AS 400 - Saisie mot de passe obligatoire
  344. Before Trigger and UDFs (table)
  345. Unique Index or PK ?
  346. Creating Tablespaces : Best Practices
  347. Error SQLCODE "-811", SQLSTATE "21000"
  348. DDL statements of Tablespaces and Bufferpools
  349. DDL statements of Tablespaces and Bufferpools
  350. new DB2 data type
  351. CREATE FUNCTION with COBOL doesn't work!!
  352. Need to export table to an Excel file
  353. db2 version 9 license
  354. Accidentally Remove Transaction Log
  355. shredded XML into DB2
  356. a strange sql
  357. Can't run Visual Explain
  358. DB2 v9.1 jdbc xml sample
  359. Insert Query
  360. Tablespace in RESTORE PENDING state
  361. Reg:Last committed transaction
  362. i want to know how to send an email notification from db2
  363. XMLfile transform to DB2
  364. Question rgarding the Column encription
  365. What is this referring to in the Administration Guide: Performance
  366. DB2 Length Script
  367. Finding Duplicate Records
  368. list schemas
  369. DB2 Java stored procedure call
  370. SQL0980C A disk error occurred SQLState=58005
  371. Date Check in DB2 UDB urgent
  372. Regarding DB2 700 exam.
  373. Cant get DECLARE to work for sproc
  374. Can DB2 run on z/OS without DRDA access?
  375. Can DB2 can exist/run on z/OS without DRDA available for clients?
  376. I can't run strored procedure in Command Editor DB2
  377. Trigger Usage?
  378. Using MERGE to change a field value when there is no match
  379. create procedure problem - db2 8.2.3 (DPF) on AIX - help?
  380. very different costs for select and update - why?
  381. Writing data into a text file using Stored Procedure
  382. db2 8.1 for solaris 64 bit for AMD
  383. initialize both DB2 and Microsoft Visual Studio environments with asingle command
  384. Updating Eclipse components on DWB : should I ?
  385. DWB Not Starting on Linux (OpenSUSE 10.1)
  386. Default Date format using CAST in Stored Proc
  387. HA for DB2
  388. HA for DB2
  389. problem wih get routine statement
  390. Problems when run one procedure in DB2
  391. Growing SYSCATSPACE
  392. DDL Triggers
  393. CREATE TRIGGER -> writing to file???
  394. [DB2 AIV Extenders] Concurrent products?
  395. Create Database privilege at an instance for user/group
  396. SQL3525N on import/export in stored procedure
  397. DDL Triggers
  398. Conversion Julian date to Gregorian date on DB2 load
  399. db2 resources
  400. SQL4301 RC=0
  401. How update one row with timestamp diferent
  402. IBM DB2 LUW online reorg
  403. Password lost - how to change it.
  404. auto increment primary key val into XML attribute
  405. Importing an Access DB
  406. function workingdays problem
  407. How to determine which database a db2fmp process is running against?
  408. QUERY: grouping history of cash dispensers
  409. can I connect to DB2 using windows authentication?
  410. Insert CLOB data (XML file)
  411. DB2 exam 701 practise questions
  412. DB2 UDB SQL Stored Procedure.
  413. Update tables with primary key
  415. Size of a Backup in DB2 UDB v8
  416. Primary Key Vs Unique Index in DB2
  417. Is it necessary to rebind JDBC Type 4 packages when installing a new Fix Pack
  418. Replication performance - how to measure it ?
  419. How to install ibm db2 icc
  420. programming code for Make your wish
  421. BP: blocked vs non-blocked
  422. Costly UPDATE to MQT base table
  423. JDBC batch inserts seem very slow.
  424. Backup with logs included
  425. Howto: Emergency SHUTOFF all monitoring & stats collections?!
  426. db2 incremental backup
  427. Is Java 1.3.1 compatible with DB2 v8.1 ?
  428. Toad for DB2
  429. IBMDBDB2 OLEDB provider does not appear to like case
  431. Getting SQLERRMC into DB2 for LUW Stored Procedure
  432. recovery time is bigger than current time
  433. interesting index design question.
  434. TABLE function, OUTER JOINS, and SQL0206N
  435. low overhead select to determine current server load
  436. Any Perl / DB2 knowledgeable people out there?
  437. Where does DB2 get it's CLASSPATH in a UNIX install?
  438. Calling a Stored Procedure from a BEFORE UPDATE Trigger
  439. Large partitioned table issue
  440. Bufferpool Hit Ratio
  441. connect to db2 server with odbc
  442. How-to create indexes on temporary tables in DB2? Very Urgent.
  443. SQL1337N The service "db2inst1" was not found.
  444. lock with force
  445. delete lock problem
  446. SQL DTS to DB2
  447. Entry point sqlouerr in DB2SYS.dll not found
  448. Error while updating Instance
  449. BUG DB2 V8 FP12 Stored Proc Parameters - NULL value is case sensitive
  450. about multiple fact tables and star schema
  451. Seeking DB/2 professionals in the Columbus, Ohio area
  452. Transition to DB2ExpressC Edition
  453. Search capability in the DB2 V8.2 Information Center has been improved.
  454. Urgent Help :Query
  455. What is ONLINE BACKUP intended for ? Is it fake feature ?
  456. How to find out ?
  457. Transferring files from PC to AIX-DB2
  458. UDB 8.1 Win Fixpak 12
  459. UDB 8.1 Win Fixpak 12
  460. Online backup to restore onto another system (or for disaster recovery): how to?
  461. Restore V8 Fixpack 12 To Version 9
  462. Can't browse stored procedure in Navigator
  463. db2 store procedures Question
  464. Reliable timeron and Query Patroller
  465. DB2 AS400 Snapshot
  466. Simple SQL question
  467. Changing the Data Type of a Column(From SmallInt to Decmial)
  468. Reading ASC files in DB2 UDB - Urgent
  469. DB2 error using the command with USERID/PASSWORD
  470. Log file full problem.
  471. plz help urgent
  472. What's the DB2 connection string wihout DSN when use IBM DB2 OLE PROVIDER in windows environment?
  473. dropping a column in DB2
  474. About Reading ASC files - Urgent
  475. Strange Behaviour of SP due to GET DIAGNOSTICS position
  476. Expressions in an outer join
  477. DBLink to a SQL server
  478. Increasing SMS filesystem - AIX 5.3 running DB2 V8.1
  479. Increasing SMS filesystem - AIX 5.3 running DB2 V8.1
  480. Software Testing & Quality Assurance FAQ
  481. Invalid statement
  482. Clob as parameter in Java UDF
  483. catalogging remote databases
  484. SqlException Network IO
  485. DB2 Dynamic SQL Table Name in Field Value
  486. Moving sequence objects?
  487. Connecting to Stored Procedure from Crystal
  488. Error While Compiling UserExit program
  489. Reducing Pages HIGHWATER mark
  490. seek trick to insert a clob value from the command line
  491. DB2DIAG.log Error
  492. Decimal precision
  493. Size of a DB2 database
  494. Stored procedure for IMPORT
  495. Moving a database from v8.2 to v9
  496. about interrupt port and firewall
  497. Query access path question
  498. Help on a UPDATE query
  500. quiesce tablespaces for table use?
  501. Token SQL was not valid.
  502. Query regarding Backup
  503. Quert tunning help....
  504. Query help
  505. Query help
  506. Package SQLABD01 missing
  507. "... WHERE (a, b) != (1,2) AND (a,b) != (1,3) ..."
  508. Check varchar field numeric using SQL
  509. Index/Key length > 1100 chars
  510. Strange sort result on DB2 LUW v8.1.9
  511. Huge db2diag.log file
  512. Searching the Information Center
  513. Spilled sorts
  514. Collocation of Left Outer Joins
  515. 32-bit instance on AIX DB2 V9 ?
  516. DB2 Precompiler Problems !?
  517. how to tell if database is activated?
  518. Intra-partition parallelism on AIX
  519. CLI Driver CLI0111E Value out of range SQLSTATE=22003
  520. How does a bufferpool run out of pages.
  521. Db2 Express C db2diag.log error
  522. problem with a trigger
  523. Authentication in Windows XP Pro
  525. SQL0338N
  526. SQLSTATE 38553
  527. db2advis error
  528. UNION ALL not returning expected results
  529. largest value for INTEGER 4
  530. reorgs taking a long time
  531. Monitoring DB2 Performances
  532. Logon errors for local account appear on DC
  533. Best way to insure four columns are notthe same pair wise in thepresence of NULLS
  534. New to Db2 - installation question
  535. Store Questions in DB2
  536. db cfg setup and SYSLH packages
  537. db cfg setup and SYSLH packages
  538. DB2 v7 FP14 on Windows2000 crashing
  539. DAS Problem
  540. Logging dynamic SQL with query params
  541. Report layout design in Alphablox
  542. sql standards
  543. Problem with SPUFI
  544. Delphi UDF's
  545. DB2 content manager versus Lotus domino doc server
  546. optimize this?
  547. Snapshot Statement Monitor Decode
  548. execute COBOL via iDB2Command -- With Dynamic Parameters
  549. Query help
  550. REORG problems with LONGLOBSDATA and PAGESIZE