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