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