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. Is DB2 8.2 ESE compatible with W2K3 Terminal Services?
  2. Problem with MERGE statement: SQL0969N Error Code: -788
  3. DB2 Environment Setup
  4. Provider cannot be found - Using current MDAC and Jet
  5. Restore DB2 System Tray
  6. DB2 Image Extenders
  7. INTRA_PARALLEL
  8. Pb load command JDBC driver
  9. db2 memory
  10. db2 memory
  11. db2 memory
  12. Number of simultaneous connection
  13. Long compiling of SQL statements
  14. How to combine fields by SQL
  15. DBHEAP usage during backup
  16. fenced vs unfenced in DB2 UDB
  17. Performance problem after replication
  18. Learning DB2 for Mainframe - how "hard" is it? How do you do it ?
  19. Which SQL's are executing and what are they waiting on?
  20. QMF for Windows and Updateable Views
  21. Load utility vs reorg
  22. Explain history
  23. Views and privileges
  24. calculate size of table with BLOB
  25. Cause of excessive paging
  26. install studio 2005 addins
  27. DB2 Migration
  28. DB2 and LDAP
  29. Accuired eServer i5 570 - Enterprise Edition; questions..
  30. SQL30081N after RESET DATABASE CONFIGURATION
  31. import sql dump
  32. db2exsrv
  33. Tablescan - why?
  34. A few questions: LOAD/IMPORT/CLP stderr
  35. DB2 Select
  36. DB2 v8 used LDAP User Id/Password on Connect
  37. IBM JDBC driver behaves differently on Linux than on Solaris
  38. db2 zos v8
  39. CLP option not working as expected?
  40. SQL0444N Routine "db2spcat" (specific name "SQL060216094049640")... Error
  41. request the next value for a sequence
  42. 2 default database paths have been used - how do I not screw up?
  43. Bug (?) in SQL: Global temporary table gets truncated on failed insert.
  44. How to see the client type?
  45. More messages in db2diag.log
  46. db2diag.log
  47. Using Federated Objects
  48. Simple Insert using Case statement
  49. LOB Conversion from Windows to AIX Problem - HELP!
  50. truncate in db2
  51. converting oracle script to db2 (hr_main.sql)
  52. multiple insertions through jdbc
  53. Question on data placement re Raid10
  54. FP10 upgrade issues - AIX (v5 32 bit) DPF data warehouse environment
  55. Using multiple database contexts
  56. how to find the base table of an ALIAS ?
  57. Inapplicable message? DB2 UDB v8.1.9 Linux
  58. DB2 Type 4 JDBC Driver
  59. IBMSNAP_CAPENQ lock issue with CAPTURE_STORAGEMGMT_INFO
  60. Package "NULLID.SYSLH203 0X5359534C564C3031" was not found
  61. Strange S1010 function sequence error problem with DB2 V8 and Windows app
  62. blank text columns
  63. configure automatic maintenance from command line
  64. Deadlock
  65. Question for SQL gurus
  66. v8.1 (win2K) database files into v8.2
  67. strange behaviour with temporary tables
  68. Backup with maintenance plan
  69. v7.1 group by and SQL0134N
  70. Locks on table.
  71. ALTER TABLE ERROR
  72. reorg and reorgchk
  73. Segmenting tables
  74. DBMS maintained views
  75. the problem about load from cursor
  76. SQL1220N
  77. Urgent problem - hanging primary key constraint
  78. DB2 UDB Help
  79. sqloPdbRecvBuffer errno=104 Any ideas?
  80. Linux: How does db2iauto work?
  81. Stored Procedure Issue:Call Vs Loop
  82. Passing variable parameters to stored procedures
  83. Select Range Query
  84. Range Select query
  85. jdbc date format error
  86. Backup/Restore/Copy Schema
  87. LPAD Decimal value
  88. DB2 ldap catalog traversal api documentation
  89. BINDFILE vs PACKAGE
  90. Many applications in Compiling status
  91. Decimal Formating issue
  92. Converting cics screens to java/.net
  93. Current and Estimate Table Data Size and Index Size for DB2
  94. How to find out which of the record that has been updated after an appliction runs.
  95. ibm db2 lock (row/table) status/indication
  96. geting SQL0668N on file load, please help
  97. Avoiding SQLCODE -746 when calling procedures from triggers
  98. Second join based on the lack of success of the first
  99. IBM DB2 Universal driver (JCC) not found
  100. question on index usage
  101. Connect to DB2 V7 and V8 in Java
  102. Problem with Information Integrator/Federated Datase - Oracle
  103. How to Alter size of an existing Blob Column?
  104. DB2 and Apple(Mac)
  105. DB is already in use by another instance, after system crash
  106. Great Job Board
  107. DB2 Memory leak
  108. DB2 UDB WE 6.1 -> UDB 8.2 Express - Is migration possible ?
  109. myDBA - web-based business intelligence
  110. db2 7.1 fixpack 12 backup error
  111. Problem creating a new database
  112. DB2 Programing help
  113. HL7 and XML
  114. Performance question DB2 UDB v8.1.9 Linux
  115. Run time error 3231
  116. Identity Column slow down the insert
  117. Question on determining heavy hit tables.
  118. Export data as well as the corresponding column names?
  119. " select * from sysibm.sysdummy1 where; ". Hmm...
  120. DB2 Type 4 JDBC Driver - Support for passwords with "|"
  121. Month question
  122. Month question
  123. How can I add an identity column to an existing table?
  124. Need help creating Instance
  125. Executing procedure
  126. Connection hang with HADR takeover by force and old primary server is down
  127. How can i use a trigger in DB2 to call a webservices in .NEt please i new in db2
  128. Generating CREATE TABLE statements for a table
  129. Using a PROCEDURE to EXECUTE other PROCEDUREs
  130. Weird Error Message
  131. Newer to DB2 - How can I do this?
  132. SQL0072 ?
  133. simple SELECT sets exclusive locks on table
  134. Developing a Wrapper
  135. Import delimited hexadecimal or binary data to "varchar for bit data" columns
  136. How to get multiple child rows from different tables into one resultset
  137. updating the code of a query
  138. internal plan lock and internal sequence lock
  139. DMS tablespace size error
  140. Can I run the client CC on Mac OS 10? Just java, yes?
  141. Disable error message descriptions in Command Center
  142. restrict record deletions between tables.
  143. FP11 available
  144. Does DB2 UDB v8 come with a compare tool?
  145. Error in diag.log(-444)
  146. How to find partitioning key of a table
  147. Preferred Export Format
  148. Help- DB2 DBAs Needed in Midwest U.S.
  149. UDB date query
  150. Table queue overflows
  151. DB2 .Net Provider vrs OLE DB
  152. Rows read from statement event monitor
  153. db2 server monitor
  154. Parsing errors in db2diag log
  155. Failover of DB2 Tools Catalog on MSCS
  156. [db2clpex] How to pass the content of a clp-file as a parameter
  157. stale connections
  158. db2unit (DB2 Unit Testing Framework)
  159. hundred thousands BLOBs in database
  160. SQL scripts and Result set
  161. runstats sampling oddities
  162. Need DB2 DBA
  163. How to create a table, and make it undropable to the creator?
  164. Help with diaglog message
  165. How to find Execution time of Select, Insert and Update in stored procedures
  166. SQL Error "SQL3040N" when execute DB2import under DB2 version 7.2
  167. How to determine ALTER TABLE time?
  168. SQL statement for generating rows of intermediate dates
  169. Stored Procedures
  170. SQL0444N Reason Code 4 SQLSTATE=42724
  171. Determine Invalid Index
  172. String vs Numeric Type (2)
  173. How Db2 trigger call .Net web service ?
  174. regarding Date function
  175. Connecting to AS400 running on IBM with MS Access
  176. SELECT NULL VALUES AS ZERO
  177. Couple of HADR questions
  178. Couple of HADR questions
  179. update from V8.1 Fixpak 8 to Fixpak 9
  180. upgrade from FixPak 8 to FixPak 9
  181. Can not initialize a full refresh (SQL replication) on the apply side
  182. Identity column issue-SQL3526n
  183. Is DB2 multi-threaded?
  184. case insensitive select
  185. UDF Performance Question
  186. Failover problems
  187. Using Virtual IP addresses with HADR in addtion to automatic client reroute
  188. HADR split brain question
  189. Activation Key - DB2 UDB
  190. please how to synchronise mssql database from db2/400 ?
  191. CLI without ODBC
  192. How can a CLI client get the return value after calling a stored proc
  193. Development Center
  194. DB2 Upgrade crash Domino 6.0.2CF2
  195. Updating IMS data from DB2 v7 Stored procedure (Z/OS)
  196. Error inserting into iSeries DB2 table with long name via SQL Server 2000 linked Server
  197. DB2 UDB Version 8 Workgroup Edition 64 bits, sources ????
  198. does DB2 support SELECT - INTO statement with ORDER BY clause?
  199. OS Command scripts never terminate in Task Center
  200. How to view date using sql
  201. QSYS type *LIB not found
  202. Query sysibm for record counts
  203. Windows Server 2003 SP1 and DB2 UDB
  204. User Defined Functions in Mainframe Enviornment
  205. Partition groups in DB2 8.2 on Linux
  206. Upgrading and FP 11
  207. Getting English Day Name
  208. memory usage in db2
  209. DB2 Connection String Problem while DB2 connection OPEN
  210. Low SQL cost and high execution time
  211. with UR is not recognised in DB2
  212. Auto delete rows older than a month
  213. Update Duplicate rows
  214. Update Duplicate rows
  215. Regarding DAYOFWEEK function
  216. query tuning
  217. SQL select Crashes DB2 8.2?
  218. DB2 Connectivity problem from a wndows client to DB2 AS/390 server
  219. Equivalent of Sybase's @@transtate in DB2
  220. Table scan <--> Index scan, Version dependent ?
  221. Size of DB2 Incremental Backup
  222. Date Format problem
  223. Time is Running out to Submit your Presentation for IDUG 2006 - Europe
  224. Can I write an application with no server ?
  225. How to query the DB2 z/OS V7 dictionary for indexes?
  226. Removing Punctuations
  227. MERGE performance help DB2 UDB v8.1.9
  228. Right Align the character field Value
  229. a trouble of modifying procedure
  230. Retrieving Object ID's
  231. DB2 Authentication problem
  232. Stored procedure
  233. changing directory for data file
  234. containers in the same FS
  235. SQL statement parsing
  236. Store Procedures
  237. Impossible Relationship? Referential Integrity on tables with on From Date and To Date
  238. Dopping a schema DB2 UDB v8.1.9
  239. Load Flatfile in UDB (Server) from z/OS-Mainframe
  240. Load Flatfile in UDB (Server) from z/OS-Mainframe
  241. interface
  242. Pre-set default schema for new user
  243. Difference in response between Net Drive and App Drive
  244. A handy trick DB2 UDB v8.1.9
  245. Fedora Core 4
  246. How to get the current DB2 Version on v8 and higher.
  247. get_dbsize_info
  248. Timestamp problem after upgrade DB2 ODBC Client from 7.x to 8.x
  249. db2 8.2 client and vb6 ado refresh problem
  250. How can I drop a Column from a table?
  251. Clarification needed for HADR documentation
  252. Question about database migration from UDB 7.1 to 8.2 (FP3) on HP-UX
  253. Online Backup versus Offline Backup ?? What's the point ??
  254. Query optimizing problem
  255. current date minus date
  256. Performance impact of materialized views
  257. Questions on a 'shadow catalog' and ODBC
  258. Can't Install
  259. How to compare two columns in DB2 -Please HELP!
  260. Redirected restore - SQL2038N A database system error "127" occurred during processing
  261. Multi-Row Inserts on DB2 for zOS
  262. DB2 on zOS and Win XP Client
  263. client instance and server instance
  264. Displaying a CHAR FOR BIT DATA in C#
  265. Question about DB2 UDB 8.2 and 32-bit and 64-bit instances
  266. Grouping data by week?
  267. Load global temporary table
  268. DBD::DB2 not finding .so file on system startup
  269. Admin API reference for 8.2
  270. Important Information Regarding IDUG 2006 - Europe
  271. NFS problem
  272. convert application id which starts with "/"
  273. JDBC: Encoding Not Supported when connecting to Big5 database
  274. DB2 Client Upgrade Question
  275. DB2 Development Add-Ins for Visual Studio 2003
  276. DB2 vs Kernel Preemption
  277. Client-Server Conenctivity
  278. Reg:Migrate VSAM files to SQL server 2000
  279. very very slow query with parameters
  280. IBM DB2 Content Manager Vs IBM Content Manager OnDemand
  281. DB2 Performance issue
  282. Which predicates are stage 1 and indexable?
  283. throughput between application-db2
  284. Problem with package not found
  285. comparision between DB2 Connect and Shadow Direct
  286. type-2 index causing performance hit
  287. JDBC: problems using FETCH FIRST and FOR UPDATE clause at the same time.
  288. Equivalence for Sybase Functions in DB2
  289. Attaching a CLI-Connection to the static SQL connection
  290. SetConnectAttr ODBC
  291. Query problem: sales volume comparision with previous year
  292. Automatic Backup/Reorg/Runstats Evaluation - How do you force a new evaluation cycle?
  293. Help
  294. Querying the Task Manager database
  295. Table Space size and Bufferpool page size
  296. Droping an index
  297. GRANT DROP on TABLE
  298. Stored Procedure Options: Modifies SQL Data and Results Set
  299. TCP/IP Error, rc1=22
  300. Crash when execute quiesce
  301. Migrate Sybase outer join query to UDB DB2 8.2
  302. Help-Sybase to DB2 migration
  303. DB2 books?
  304. need to restore old database (database server 4.01 AIX)
  305. There is no available conversion for the source code page "1252" to the target code page "0". Reason Code "1". SQLSTATE=57017
  306. Restrict Access by Application
  307. DB2 subselect problem
  308. Can XML data type be passed as parameter for procedure?
  309. Deleting data from table
  310. Log mining
  311. FCM_NUM_BUFFERS
  312. Calculate Shared Memory Usage
  313. Instance Creation Query - "db2iexec"
  314. insert into DB2 from SQL Server
  315. Transaction isolation level for stored procedures.
  316. Content Manager 8.3
  317. query to determine the Instance Name?
  318. DB2 JDBC addBatch truncates DECIMAL fields during inserts, if the last row has null values
  319. Connecting DB2/400 through iSeries Access drivers or DB2 Connect, which's more efficent?
  320. SQL0723N sequence + union all
  321. ESE -> WSE?
  322. Console disapears:Error in <EXE NAME="javaw.exe".. in DB2 8.1.8, Win Server 2003
  323. Dropping tables
  324. An internal error occurred. Report the following error code : "0xFFFF8544".
  325. An internal error occurred. Report the following error code : "0xFFFF8544".
  326. Fixpack 11 for DB2 V8?
  327. Db2 Stored Procedures and File handling
  328. DB2 UDB v7 for z/OS TEMPLATE not creating GDG base for absolute generations
  329. [Urgent] validating Date field and saving into DB?
  330. commit and terminate
  331. DB2 join challenge
  332. Unique sequence object for each row returned from select statement
  333. Do anyone still have V8 FixPak 4 (U488486, not 4a) for AIX5?
  334. Error with Automatic Maintenance
  335. DB2 8.1.8, Win 2003: Steuerzentrale schmiert ab
  336. DB2 8.1.8, Win 2003: Steuerzentrale schmiert ab
  337. Any function in DB2 to help
  338. Equivalent to CREATE DEFAULT in Sybase
  339. Manually Add a Row to a Resultset
  340. VB8, Fixpak 10
  341. Migration of DB2 V6.1 to Windows 2000
  342. EXTEND USING option of CREATE INDEX command
  343. db2 connect problem
  344. How to elide leading zeros
  345. CHAR vs CAST DB2 UDB v8.1.9 Linux
  346. Help with 64bit Solaris 10 ...
  347. Stored Procedure - Aliases problem
  348. Requirement of Java/Oracle& All Skills with Valid H-1 B Visas --USA Opening
  349. SAP/DB2 Space optimised snapshot backup
  350. CSV file with Headers
  351. DB2 UDB 8.2 installation on HP-UX 11i fails
  352. Online or offline backup?
  353. how to determine the NUM_IOCLEANERS?
  354. Protocol specific error code(s): "10065", "*", "*". SQLSTATE=08001
  355. DBM Event Monitors
  356. Column Concatenation Function?
  357. Trouble with .NET Data Provider on DB2 8.1 Fixpack 6
  358. Error logging with Merge statemet
  359. multiple files for Backup
  360. Nested Case Statements
  361. Media controller -- Disk full encountered
  362. IBM JDBC help
  363. What is viper?
  364. SQL2048
  365. validation testing -- use TPC-C? (or what?)
  366. Some nonexistent tables in ASN.IBMSNAP_REGISTER
  367. Deploying the .Net Application with DB2 DataBase
  368. ORDERING by a FUNCTION() with simple-integer
  369. Show Related->Tables Spaces causes "CLI0611E Invalid column name."
  370. Installing DB2 on Solaris 10
  371. SQL22223N La instancia "DB2" no existe en el sistema principal
  372. DB2 Express
  373. split function in DB2
  374. Configuration parameters
  375. Performance issue: Need to force Optimizer use a specific Index
  376. Opening for IBM/DB2 Content Manager with 2yrs of Exp In Chennai
  377. Help- Migrating timestamp from Sybase to DB2
  378. Regarding MTK
  379. Can DB2 run on a SUN Ultrasparc T1
  380. RETURNS TABLE in DB2
  381. missing functions
  382. Views and Deadlocks
  383. Certification question
  384. Triggers using Uncommitted Read
  385. db2fm
  386. ResultSet cursor is forward_only from remote SQL/PL procedure ?
  387. Combine column multiple rows into one row
  388. DB2 Net Search Extender truncation
  389. HPU 2.2 Fixpack 3 on AIX
  390. db2start gives an error after DB2 installation
  391. Difference in between TIMEs
  392. SQL procedure permissions
  393. same query giving different out
  394. Suse Linux 64-bit ppc describe table issue
  395. Unable to Debug Java SP in Stored Procedure Builder
  396. Migrating from Teradata to DB2 EEE.
  397. One stop shop revoke tool
  398. Data of table not sorted by primary index in Control Center
  399. Safe cast from string to integer
  400. code page error
  401. maximum tablespace size
  402. Need Data Migration Points(Sybase to DB2)
  403. SOS - how to uninstall DB2 Express 8.1. on Windows Server 2000
  404. DB2 backup question
  405. Errors in diag log
  406. Compiled stored procedures in DB2
  407. JDBC Driver Failure
  408. reduce % of used DMS tablespace
  409. ccsid for db2
  410. Calculating Days/Months
  411. cluster
  412. No Privileges for User groups
  413. Restore 8.2
  414. Nullable Vs Not Nullable Column for Partitioning a Union ALL View
  415. the first connection to the database takes a long time....
  416. Calling a COBOL Subroutine from COBOL/DB2 Stored Procedure
  417. Retrieving timestamp with the Universal Driver
  418. identity column & import - need help
  419. how to make undeleted record
  420. Trigger fails when stored procedure is called two times in a row
  421. how to change the data type
  422. DB2XML.Content fails to export into file
  423. Changin Hostname ...
  424. SQL Problem with date ranges
  425. understanding health monitor output
  426. query bailing out after one row returned?
  427. query bailing out after one row returned?
  428. Calling a COBOL Subroutine from COBOL/DB2 Stored Procedure
  429. DB2 on Windows to DB2 On Mainframe
  430. Synchronize Outlook data with db2
  431. Failure of odbc_num_rows sometimes
  432. "db2ilist" and "profiles.reg" Question
  433. Regarding Migration to DB2
  434. Recursive programming in DB2 UDB v8.2 Stored Procedure
  435. Create a DB2 UDB database Manually using script(s)
  436. Getting SQL0901N error with SQL State: 58004 on running explain plans
  437. Mysterious error
  438. Performance Problem
  439. Conversion of 'FOR BIT DATA' string to normal string in DB2 V7
  440. direct SYSADM authority ??
  441. HADR and C Storred Prcedures
  442. CLI0119E from "call sqlj_install_jar()" in PHP
  443. SQL1031N connecting to remote database
  444. automated Install of DB2 connect
  445. Opening for DB2 UDB DBA - MNC,Bangalore,India
  446. Can't rollforward due to large bufferpool size
  447. Can I install DB2 UDB V8.1 on RHEL 4?
  448. column rename on z/OS using object comparison
  449. Migration of DB/400 to UDB on ISeries
  450. Executing UDF from SQL Stored Procedure
  451. CLI0005W from query with join in PHP script
  452. Error defining table function
  453. Beginner question: a lock without exceptions?
  454. Synchronizing/Replication between MS SQL & DB2
  455. Using Net Search Extender on Typed Tables
  456. db2 load with named pipe gives sql3025n error
  457. Problem while copying BLOB from one table to another.
  458. Full path in EXTERNAL NAME on Windows?
  459. Summary Table - Optimizer not using if ORDER BY in query
  460. Geodetic Extender?
  461. SYSPROC.SNAPSHOT_APPL_INFO Permissions ?
  462. Precision of results
  463. Design Consideration?
  464. Java UDF: Checking if anything in scratchpad
  465. Client reroute with DB2 JDBC driver
  466. Validation of user logins
  467. SQL1131N after installing a new shared library.
  468. Drop Database Error
  469. invoking external function with the definer privileges
  470. JDBC: DatabaseMetaData
  471. Smple java UDF not working: SQL4306N
  472. DB2 list application hang
  473. DB2 problem when accessing via a web page
  474. SQL0902C A system error (reason code = 9") ocurred
  475. Pushing content of a file into a varchar field?
  476. DB2 for Z/os version 8 DBA certification Guide
  477. Inserting into federated DB from trigger
  478. Inserting in federated db from trigger
  479. User-defined aggregate function
  480. Text index error!
  481. Negative value in the tablespace's percentage used field
  482. db2admin start error
  483. db2advis from Client
  484. Stored Proc' Offending Line Number in error message?
  485. What's wrong with this simple SQL UDF?
  486. connecting to SQL server table
  487. SQL-PL Reference Materials
  488. time stamp of DML
  489. How test for all digits
  490. how to reinstall db2 after hard drive crash
  491. Using "*" in subquery
  492. Query on tables from different DBs
  493. SELECT INTO - ADO.NET
  494. sqm.gen_dlconn_events Probe:10
  495. Does DB2 UDB support IPv6
  496. DSN creation to DB2
  497. Regarding Exam 701
  498. fp10
  499. Converting Windows databases to Linux
  500. String vs Numeric Type
  501. ESE 8.1 install on Linux
  502. blobs question
  503. problems with sqlcode -1225 in AIX 5.2 + UDB DPF (parallel) environment
  504. Index space requirements
  505. drop instance?
  506. Row or object SEKVENCE in EXTLOG001 type *FILE in use
  507. DB2 Blob
  508. Creating Tables and Populating via Script
  509. SPs in VB6
  510. Errors in DB2DIAG.LOG
  511. how to know how many tables i created in the database
  512. Automating exports of some files
  513. DB2 setup problem
  514. DB2 setup problem
  515. Data Warehouse Center Question
  516. EII (Composite) evaluation
  517. Invalid state transition while dropping a tablespace
  518. jdbc: FETCH FIRST ? ROWS ONLY
  519. Tablespace in Offline State...
  520. Insert into temp tables not working
  521. The cursor specified in a FETCH or CLOSE statement is not open SQL Excep
  522. SQLException
  523. Want to write a standard user defined function in the db2
  524. DB/DBM configuration in DB2 on Z/OS, OS/390 or AS/400
  525. SQL6030N reason code "13"
  526. Striping the time of the timestamp
  527. Problems with INSTEAD OF Triggers
  528. Creating a temp table.
  529. Creating a temp table.
  530. Get Version Level in cpp
  531. Doubt with MAX function
  532. Index question
  533. DB2 DBA professionals needed for CMM Level 5
  534. how to specify the number of records to fetch
  535. Declaring a variable in SQL DB2
  536. Concatenation
  537. two-phase-commit with nicknames on 8.2.2 linux SQL/PL procedure?
  538. about configure automatic maintenance window
  539. Table Inactive Error
  540. uninstall db2 NSE
  541. SQL0181N on nickname for union-all-view
  542. Help with a trigger
  543. Writing User defined function in the db2 database.
  544. TOAD tool for DB2
  545. Domain Authentication Problem
  546. ERD ---> Relational Mapping
  547. MQT Query Rewrite Puzzling
  548. fixpak enhancements
  549. Static SQL SELECT FROM SYSTABLES with CREATOR and NAME = *doesn't*use index?
  550. Static SQL SELECT FROM SYSTABLES with CREATOR and NAME = *doesn't*use index?