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