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