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. Data loads: Offline performance with online benefits
  2. simple sortheap question
  3. Stored Procedure problem in DB2 for OS/390 V6
  4. Cyrillic characters from Oracle-nickname
  5. every java sp gets error:sql4301N java interpreter startup or com failed. reason 0
  6. exportXML with multiple records
  7. DBA HELP: Performane Tune SELECT, SUM, & CASE
  8. db2advis giving errors - not able to INSERT into ADVISE_INSTANCE table
  9. DTD to XSD
  10. Connecting to Different Physical Node on Partitioned Database on DB2 8.1.6
  11. Error Executing Assembler Program from a Stored Procedure
  12. hand-rollforward on a standby for windows
  13. update with join of multiple tables
  14. Replace DB2 7.1 CD-ROM
  15. Subquery returning a column value
  16. Testing db2 imp and load
  17. Type-2 index question
  18. Manual Instance removal on XP
  19. select statement -format longer record result set!! HELP PLEASE!!
  20. Error 5005C after Migration from UDB7 to UDB8 (AIX)
  21. Memory used - what is "Other memory"?
  22. db2 CLP and PS output on AIX
  23. Stored Procedures in OS/390 V6
  24. does eXadas really work???
  25. Snaphot_table function gives unexpected result
  26. DB 7.2 Replication And DR
  27. Logging And Performance
  28. SECQTY Maxiumum Value for Z/os version 7.2
  29. access plan with sequence in params
  30. EXECUTE SQL-string from StoredProc
  31. Accessing DB2 UDB on Linux from within a DB2 VM Cobol program
  32. Washington Area IBM-Informix/DB2 User Group meeting - June 7,2005
  33. Myths
  34. View Error : Iseries Navigator
  35. Newbee - Schema concept question
  36. Newbee question - why no create user in DB2 ?
  37. ERWin data modeler, iSeries DB2 reverse engineering error
  38. insert/select question
  39. Java on DB2 for OS/390
  40. Creating Crosstab with drilldown
  41. Help with JDBC Driver
  42. Insert bulk data into table & temporarily disable log
  43. DB2 8.2 Performance drop on Query compared to 7.1
  44. MQ Functions on DB2 for LUW V8.2
  45. Deferring constraints in DB2
  46. Can 8.1 package be bound to 7.2?
  47. standby db on windows
  48. Snapshot_LockWait table function question
  51. DB2 for z/OS problem - empty tablespace growing in size
  52. DB2 for z/OS Visual Explain: Fail to load JDBC driver
  53. DB2 Flush Dynamic SQL Cache and E70081 z/OS V7.1
  54. How many tcp ports does DB2 use?
  55. DB2 Flush Dynamic SQL Cache and E70081 z/OS V7.1
  56. check unique
  57. drop table conditionally
  58. Error in sql REPLACE
  59. indexes
  60. Coverting decimal field to db2 date?
  61. A little question on PREFETCH / MDC
  62. Create Function or Create Procedure
  63. Create Function or Create Procedure
  64. Suggestion for DB2 Improvement
  65. What is the best way to change Extent Size
  66. help request
  67. Recursive queries in SQL3 and graph transitive closure
  68. DB2 Load into multiple tables using control centre
  69. DB2 Replication Error - Oracle 10g to DB2 8.2 (8.1.8)
  70. Cursor Script in CLP please...
  71. Query
  72. Using the SMTP that Task center Uses.
  73. Comparative between DB2, Informix and Oracle
  74. Isolation level ignored when DTC is used
  75. access plan when view has rank()
  76. REPEAT --> Simple Question on Statement Size
  77. How to join with a subquery conditional DB2 UDB 8.1.5 Linux
  78. Graphic columns not allowed
  79. post test
  80. Where can I find the source of structured type?
  81. afficher 2 count de de tables
  82. Logging And Performance
  83. UDB 8.2 FixPak 9 for LUW
  84. Use of variables
  85. Revalidating all inoperative packages from SQL (not CLP!)
  86. Schemas in SQL Stored Procs for WSE 8.2 on Linux
  87. Sort Order
  88. Have you ever met worse case than this?
  89. quiesce disconnects but restart doesn't???
  90. where not exists
  91. Sybase to DB2
  92. plz send the ans
  93. Redirected Restores & Set tablespace container
  94. Too Simple Question: Statement Size
  95. Info Integrator configuration options
  96. BLOB Field Size Limit And Logging
  97. W2K to W2K3: Cross Platform Restore Error?
  98. Create function error DB2 UDB v8.1.5 Linux
  99. dynamic SQL in stored procedure. Need Help
  100. db2look
  101. Oops, dropped an rlv that was in use... Need to recover...
  102. DIA9999E with error code 0x4 during create server
  103. ODBC from DB2 connect does not allow outer joins
  104. TCPIP Error
  105. Automated snapshot data
  106. DDL question WRT adding NOT NULL constraints
  107. Insert LOGS
  108. Dat File Database Format??
  109. show explain plan
  110. Trying to prep .SQC files in Visual C++
  111. call of sqls
  112. Linux and DB2
  113. Is the DB2 Command Center = the Control Center?
  114. Recursion not allowed for common table expressions error
  115. Recursion not allowed for common table expressions error
  116. Recursion not allowed for common table expressions error
  117. Recursion not allowed for common table expressions error
  118. unable to load dll db2app.dll . Error using DB2 in ASP.NET application.
  119. Remove database aliases
  120. DIA9999E with error code -32
  121. DB2 Qualified Table Name Problem with ODBC.NET
  122. Grant global select/insert/update/delete to all users
  123. SQL1131N DARI (Stored Procedure) problem
  124. Column order of an Index
  125. UDF functions interdependency.
  126. DB2Connect V.8
  127. Enter Default Values for all columns in all tables except Primary Keys
  128. fixpak install but only on one instance
  129. Who knows the answer?
  130. Tools db process foiling backups
  131. DB2 UDB Enterprise Edition V7.1 License Question
  132. ignorant DB2 dilletante question: what's the syntax for a procedure...
  133. SQL22201N - I am unable to Proceed further
  134. chnage use identity column to sequence
  135. Creating a database and filling data using scripts
  136. db2look in V8.2
  137. Version 7 Compatibility
  138. UDB Migration from LUW - Mainframe DB2
  139. Concept Question re UDTs in UDFs
  140. Error on data type Number(X, Y) with DB2 Connect v 7.01
  141. SELECT outer join
  142. ODBC error
  143. DB2 & AIX or OpenPower 64-bit Platforms ?
  144. sql help
  145. Need help missing log file
  146. Who to Import PostGRESQL 7.2.2 database into Db2 7.2
  147. Remote DB2 administration
  148. No experiences with UDB 8.2 on Linux Suse
  149. QADBXREF authority - aliases creation
  150. V8.2 SQL stored procedures implementation
  151. 7.2 client slower when connecting to 8.2
  152. IMPORT with REPLACE piveleges needed
  153. showing actual values in sql statement event monitor
  154. what is rowcount from UPDATE called in db2 cobol pgm?
  155. Putting Auto Commit Off on the Server
  156. C# and db2app.dll
  157. functional dependencies from column correlation
  158. hospedagem de sites - planos de hospedagem - hospedagem 22727
  159. Compile problems
  160. Keeping DDL's in sync
  161. sqlj Command Doesn't Work
  162. Which tool to use when creating/compiling procedures?
  163. How to automate creating a database, tables, index, procedures...?
  164. DB2 V7.1 DRDA environment TCPIP and DIST address space CPU usage high
  165. Qucik Question in DB2 2 way Replication (Update Anyware)
  166. Strange error in UDF
  167. MS SQL Profiler equivalent in DB2 8.2?
  168. How to display dependencies for a view (source tables)
  169. Oracle Migration - LAG function equivalent.
  170. Chasing down dormant user accounts
  171. ADO.NET Isolation Level
  172. Can I pass a parameter from a stored procedure to a table function that is joining on other tables?
  173. More HADR thoughts
  174. HELP NEEDED for Internal error 0xFFFFF707 which cause DB to go Crash Recovery
  175. Need help generating SQL select statement
  176. hospedagem de sites - planos de hospedagem - hospedagem 52225
  177. getting LIST APPLICATIONS to run...
  178. SQL0104N on insert of consecutive NULLs
  179. Sr. SAP resource - Fixed Assets / SME
  180. Limit on Items Using "IN" Function
  181. DB2 Governer - db2gov: GOV1062N Unable to start governor at node "0". rc = "53".
  182. CALL Procedure with OUTPUT parameters
  183. Create an SP that references a non existant SP
  184. Latin -- English
  185. Hadr, Congestion, Recover-Pending
  186. How to do a commit after each insert inside an SPL ?
  187. SQL2072N Unable to bind the shared library "". Reason code: "".
  188. Archiving data from 2 db2 tables...........
  189. DB2 v8.2 Installation Problem
  191. More on the design advisor
  192. Copy "related" tables data from MVS to UDB on NT
  193. db2updv8 lead to strange error
  194. DB2 Questions
  195. c# and udb 8.2
  196. Redistribution of V8.2 data warehouse
  197. DB2 v8.2 Installation Problem
  199. generate UI from constraints
  200. Difference between runstats and reorgchk ?
  201. Java UDF Question
  202. Help needed for 'sqloopenp' errors in db2diag.log
  203. table udf's and java
  204. DB2 Configuration Assistant and ODBC System DSN
  205. DB2 Authentication
  206. How to convert MS SQL SPs to IBM DB2?
  207. db2licm -l
  208. DPROP / SQL Replicator
  209. db2jcc with GCJ
  210. db2 unix man page
  211. Best way to transfert high volume data between AS400/DB2 to Unix-Sybase
  212. looping on db2 get snapshot for locks on <db>
  213. Urgent - security issue with SQL SP and UDF
  215. pi()
  216. Temp tables and UDFs and multiple subsystems
  217. [IBM][CLI Driver] CLI0109E String data right truncation. SQLSTATE=22001
  218. db2 version 8 load
  219. DB2 WSE 8.1 Authentication
  220. Query Question - Multiple Tables
  221. as400 join sqlserver...
  222. Filling ksh array with db2 returns..
  223. CASE syntax in check constraint
  224. update taking forever
  225. Java UDF Questions re scratchpads
  226. Problem Installing DB2 Connect Personal Edition Version 8.1 for Windows
  227. Table size and index size
  228. Replications "Tables"
  229. Switch Tablespace Type During directed restore
  230. Question on the design advisor
  231. Performance Issue: BI Reporting tool: DB2:Query
  232. Moving CLOB data from OS/390 DB2 to UDB V 8.2
  233. SQL question: Matrix creation
  234. Multiple DB2 versions on AIX
  235. Message i db2diag.log from 'oper system services sqloPostIPCWaitPost'
  236. Federated database
  237. UDB 8.1 - Case Insensitive (shared-weight)
  238. merge error (udb db2 v8.1.5 linux)
  239. Db2iprune location
  240. DB2 Developer Works - RSS Feed?
  241. Why are 2 ports required for a HADR Pair?
  242. SQL1031N Error while creating database
  243. SQL Server 2005 - Still not upto it
  244. no suitable driver db2 tomcat 4.0.6 linux redhat
  245. MERGE commit count
  246. Is there some application can help export only the changed data from DB2 ?
  247. sqlj code
  248. db2look question
  249. can not start database
  250. Cursor
  251. IBM and Ascential
  252. ADO dates and '0001-01-01'
  253. Reliabilty of DB2 Connect / ODBC / AS400
  254. simple select question
  255. Unable to update a Created Global Temporary table.
  256. How to build database to support user-specified attributes?
  257. Multiple INSERT
  258. DB2 on Solaris 5.8 linking with PAM module
  259. Help installing IBM Content Manager 8
  260. Using Purify with db2 CLI application
  261. calling Philip Morris, errrrrr, Mr. Adamanche
  262. Why is this happening in `Enable Query Optimization`
  263. UNInstall db2 code on Win2K
  264. odbc driver for db2 in OS/390 ?
  265. ORACLE MIGRATION - CASE Statements.
  266. How to pass variable in dynamic SQL?
  267. Development Center refuses to work at all
  268. default base
  269. Zugriffstatistiken
  270. DB2 Packages
  271. top ten guidelines ...
  272. Development Center build
  273. Schema query
  274. DB2 Fast Load and Unload
  275. export utility - does anyone have any benchmark numbers
  276. More CPU???
  278. Getting SQL0526N error when updating a Global Temporary table.
  279. V8.2 FP1 automatic startup
  280. DB2 Load Abend
  281. DB2 command slow after Migrate to AIX5.2 ( RS/6000 H50)
  282. Looking for a good book
  283. db2iprune
  284. how to ignore in an insert statment
  285. unable to obtain solaris fixpak for DB2 8.1
  286. federation between MF subsystems
  287. Any equivalent to setSQLstate and setSQLmessage in DB2JAVA UDFs?
  288. Installing InfoCenter on local drive
  289. How to assign a DB2-Instance to a unique IP-Address (and Port - of course)
  290. simple, segmented, or partitioned tablespaces
  291. SQL30082N, Reason 19
  292. Error in DB2ICRT on Fedora Core 3 running x86_64
  293. plug-ins for Stored Proc Builder (Dev Center)
  294. Re-install Development Center
  295. Bitmap indexes
  296. CLI0125E Function Sequence Error. SQL STATE=HY010
  297. Fetch first
  298. Replicate
  299. Migration Problems - SQL1039C
  300. Migration Problems - SQL0535/SQL1088W
  301. db2 v8 fp7 on hp-ux11i
  302. DB2 UDB V8.2 and DB2 V8 on Z/OS
  304. Move a Storage management view
  305. Import of csv-File
  306. Load using VB6
  307. Install problems re DB2 V8 (FP8)
  308. Take a bow IBM with your HADR implementation
  309. Need help with V8.2 install
  310. check constraint performance on zos/v7
  312. SQL 2000, AS400 and Client Access
  313. a non-edu child crashed
  314. Expiry Date of license?
  315. HOW-TO: recreate a big set of interdependent UDFs...
  316. STRIP: Expected tokens may include: "<strip_spec>"
  317. Removal of old entries in Journal or old storage snapshots
  318. DBAINTRN: SQL22206N
  319. Constraints
  320. DB21034E
  321. Container Operations Through a Roll Forward.
  322. DB2 UDB or Oracle (who's got better support)
  323. DB2 User Group Italy - next meetings March 2005
  324. DB2 Connect with MDAC
  325. How to setup lobsinfile when importing LOBs to a table?
  326. UDF Design Question
  327. Need help with an automated backup process problem.
  328. SQL0104N when using STRIP UDF
  329. Retrieving get_db_config information in SQL statement.
  330. Connection port not listening
  331. Help in gathering deadlock information
  332. Speed up backup
  333. Migrating DB2 v7 to v8 on z/OS
  334. DB2 Licensing/Update Questions
  335. Multiple DB2 versions on Windows?
  336. Replication with UDB v8
  337. db2cmnclp
  338. Health Monitor / SMTP Server
  339. SQL30083N Attempt to change password for user id "17"
  340. import & internal commit
  341. Replication with v8 UDB
  342. Local config vs. LDAP, weirdness connecting
  343. UDF Driver?
  344. Help needed.....
  345. update db2 version 6.1 (Sun Solaris 7)
  346. update db2 version 6.1 (Sun Solaris)
  347. Design advice
  348. How to interpret db2diag
  349. Big Endian / Little Endian bind variable problem
  350. Can you rename a DB2 instance?
  351. How to retrieve register values?
  352. Question on a table reorg with clustering index.
  353. US- MN - Functional Oracle Consultants
  354. Need help with SQL - connect to multiple data source in DB2 AIX
  355. Very basic performance question
  356. Static cursors in DB2
  357. How to I delete a column from a table in DB2 on AIX or Window Environment
  358. IBM Websphere Information Integrator - distributed transactions
  359. Automatic Runstats
  360. SYSADM privileges? How to assign?
  361. UDB 8.x FP8 Windows (XP-SP2)
  362. db2_all with muliple commands
  363. questions on HADR on tables with "not logged initially"
  364. How to auto start DB2 service on Linux Suse 9
  365. Federated connection issues
  366. Problem with EXPORT HIERARCHY
  367. DB2 Memory usage
  368. Connect to DB2 database through PHP WITHOUT ODBC ?
  369. Plano, TX -- C++, CORBA, UNIX
  370. Bloomington IL -- Technical Analyst / Security (Oblix)
  371. Meaning of lock_mode values in SNAPSHOT_LOCK function
  372. DB2 UDB LUW 8.2:clp 32 bit connect to 64 bit engine
  373. How to reterive the last 5 records in a table?
  374. "FIND" command is narrowed
  375. Schema mapper
  376. Sample package
  377. Fenced User
  378. Easiest/fastest way of storing a schema and default data in source control?
  379. how to extract one row from each range data
  380. DBMS_JOB equivalent?
  381. uninstalling a fixpak
  382. DB2 v5r3 FULL Join?
  383. 8.x FP8: concurrent database activation with AWE-Memory cause the instance to crash
  384. Installation error with DB@ Personal Edition v8.1
  385. db2diag.log code ffff 8528
  386. Connected, Unable to Work
  387. Semistructured data in DB2
  388. Archiving data on very large tables
  389. db2move
  390. does Not logged initally affect rolling forward recover?
  391. Creditwrench
  392. Load command on table, field timestamp primary key
  393. Escaping semicolon embedded in string values in db2sql92
  394. Require : Dumps and guides for Test 700/701
  395. TO_CHAR(date-value, 'HH24') returns error: type, length or valueof arg is incorrect (42815)
  396. Left Outer Join Using Views
  397. Error SQLSTATE=42703
  398. Field created from case statement / SQL0312
  399. How to perform bitwise operations
  400. Cool File Encryption Software Released.
  401. RID
  402. loading a timestamp
  403. DSN1COPY
  404. numdb reset???
  405. 32-bit vs. 64-bit ??
  406. Page Cleaning of Buffer Pools
  407. migration of postgre to db2
  408. userid disabled or restricted in DB2 8.2
  409. DB2 Image Copy & Restore..
  410. SQL/400 and "TOP x" function
  411. How do I make a VIEW read-only?
  412. do i need to exclude transaction log while replicate
  413. Problems with db2 log archive
  414. Difference between inbound_comm_address and corr_token
  415. Problem with MONTH() function
  416. Problems with archiving logs.
  417. DB2 Universal JDBC Driver and {fn CURDATE()}
  418. Federated setup - additional column
  419. Deleting Rows from DB2 table that Contain LOBs
  421. How to analysis the Performance of DB2 UDB 8.1?
  422. federation windows-aix
  423. What are security risks with running DB2 services using local system account?
  424. Federation of DB2 Instances Across LPAR's
  425. force in a join the election of a table as the most important
  426. What is the difference in the update statements?
  427. trigger logic
  428. Swap space usage
  429. Mark Townsend, Oracle Product Manager, on posting in DB2 newsgroup
  430. IBM.Data.DB2.iSeries database access problem
  431. What is node migration ?
  432. How to analyse poor performance of the database
  433. db2 size and performance
  434. reorg & data corruption
  435. db2eva help.....
  436. Seeking some planning info for DB2 UDB LUW REORG
  437. force rollforward pending state
  438. reorg performance and online reorg
  439. DB2 8.2 on linux x86_64 - authentication options
  440. win98
  441. DB2 UDB DBA needed
  442. Fault monitor question
  443. Question on db2licd command for applying FP6
  444. Updating Partition Key with Before Trigger
  445. Running DB2 Stored Procedures from Microsoft SQL Server 2000
  446. type2 vs type 4 drivers
  447. DB2 V8.2 HADR Questions
  448. AWE Bufferpool: instance crashing with DB2 8.x ESE FP8
  449. proble database
  450. recover tables db2
  451. What is wrong in this statement?
  452. DB2 CLP - formatting text columns
  453. Cross-platform DB2 UDB restores with Linux on POWER5
  454. Stored Procedures error SQL0440N on db2 8.1 fp5
  455. Moving data from UDB 7.1 to UDB 8.1
  456. Wrong values for dft_,mon_table in 8.1 FP 8 in db2diaglog, if chaning it ?
  457. Restoring a Tablespace level backup to another database
  458. V8.2: "Attempt to create interval of 0-dimensions"
  459. DB2 Exam 700
  460. Diffence between Quantified Predicates: IN , ANY, and SOME?
  461. Equivilant of Oracle's DB Links in DB2
  462. Preloading data/table in memory?
  463. num_poolagents doesn't add up
  465. v8 Dynamic Scrollable Cursors
  466. ODBC Issues - SQL0443 SQLSTATE=38553
  467. calling stored procedures via oracle odbc
  468. SQL0443N Routine "ALTOBJ"
  469. HOW To get Monitoring VALUES in sqlmon.h
  471. help with db2image extender 8.2
  472. help with db2image extender 8.2
  473. Prometric Test centers in Chennai(India)
  474. Is it possible to Hexadecimal or Binary Value as the input to WHERE clause in query?
  475. Message in db2diag.log after returning to version 7.2
  476. Websphere Compliance Auditing Tool (DB2 Based)
  477. UDF with dynamic SQL and result
  478. The best tool to analyze and document.
  479. Cannot connect to remote db via 'Federated Database Objects'
  480. Install problem on Windows XP - VerifyPrereqsCA
  481. JDBC Support by DB2 Fixpak
  482. DB2 installation on Mandrake 10.1
  483. task center
  484. Reorg table/index questions
  485. DB2 numerical data type on HOST instead of bigint
  486. What is the difference between Alias and Nickname?
  487. What am I missing?
  488. specify package names for sql stored procedures how?
  489. DB2Connection.typeMaxVarChar=254??
  490. Primary key and Unique indexes in UDB Vs Oracle....
  491. SQL error 204 when we try to access tables via alias
  492. DB2 SQLCode Connection lost.
  493. DB2, SQL Server, Oracle
  495. Replace JAR failed in DB2 Development Center on AIX
  496. DB2 Technical Support
  497. db2 store procedure build failed.(aix 64bit server)
  498. setDB2ClientUser ?? example
  499. .NET and UDB2 Transaction Manager
  500. ZLES 9 Suse Linux and UDB 8
  501. ZLES 9 Suse Linux and UDB 8
  502. DB2 UDB v8.2 - SMTP Server Configuration
  503. Temporary index is not taking in the Stored procedure
  504. AS400 JOB - Sydney CL, Cobol etc.
  505. before trigger on 390/V7
  506. 64-bit instance on Aix 32 bit kernel / 64 bit hardware
  507. DBI1124E Instance inst1 cannot be migrated.
  508. How to reset/restart/modify the IDENTITY counter?
  509. Performance-related Issues on a Restored DB
  510. application program - question
  511. Error using Fast Path DB2 course from IBM
  512. What does this mean?
  513. Accessing a remote DB2 server
  514. single table query multiple indexes
  515. DB2 Client Access Licensing Question
  516. DB2 UDB 7.x BufferPool change
  517. Client Access ODBC driver problem
  518. Exporting and Importing tasks to Task Center
  519. sql0199 error
  520. Obtaining a list of databases within an instance using only the CLI commands
  521. db2 udb 7.2 config question
  522. Install DB2 CAE v5.2 using a response file.
  523. How to find routinename associated with a particular package??
  524. Merging a data mess
  525. export and dateformat to produce CSV file
  526. DB2 Run time client setup on XP won't install TCP/IP
  527. Fun installing db2 8.1 in a suse linux box
  528. HELP --- unirpc no port avail
  529. OnDemand TSM
  530. How can I terminate locks manually?
  531. DB2 & jdbc
  532. Steps on db2 trace
  533. db2 and stored procedure
  534. Identity values in dynamic SQL
  535. Which DB2 for Intel Xeon with EM64T Extensions on Linux
  536. Tips and tricks for fast SQL procedures
  537. Backup of DB2 on Windows 2003 using open file option
  538. reduce size of log files?
  539. reduce size of log files?
  540. reduce size of log files?
  541. Retrieving database record with the lowest value in field aaa?
  542. autonomic feature DB2 V8.2 question
  543. db2fm questions
  544. Date conversion
  545. Explanation/help with DB2 memory Usage on Linux?
  546. DB2 Command Center not working properly .....
  547. Converting NUMBER, DATE and VARCHAR2 database fields from Resultset to variables?
  548. Getting MetaData for JDBC tables with getTables() does not work?
  549. IDUG 2005 - Europe: Call for Presentations
  550. Some thoughts on netiquette