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