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