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