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