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