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