View Full Version : answers

Pages : 1 2 3 4 5 6 7 8 9 [10] 11 12 13 14 15 16 17 18 19 20 21
  1. Using Foreign Key To Ref A Unique Index
  2. RESTORE PROBLEM FROM DB2 V8.2 TO V9
  3. db2 listener
  4. Dropping Nicknames
  5. Decompose "leveled" XML to to one single PF ("flattened")
  6. FP12 problem ?
  7. Trees, recursion, and grouping
  8. How to look up a range
  9. Could I use a host variable for replacing the table name in SQC program?
  10. how to increase char(35) to char(100)
  11. DROP TABLE, VIEW, ... only IF EXISTS
  12. SQL30081N
  13. Internal Catalog Cache Lock
  14. Loadrunner, Winrunner and Software Testing Resource Hub !
  15. COMPRESS .. & VALUES COMPRESSION change request: RFC.
  16. Setting env variable in DB2 env
  17. Urgent Positions with an MNC in Noida, for DB2 Admin
  18. The good old quest, - How many disk space the table occupies? - stillinsoluble?
  19. REORG TABLESPACE
  20. LOAD & IMPORT results in different disk space, occupied by a table: why?
  21. Storing documents in db2
  22. ISNUMERIC by TOKUNAGA
  23. clean up old log files
  24. Help with db2move
  25. Table space error : Create Table DDL
  26. [DB2/AS 400] no available conversion for the source code page "819" ...
  27. error upgrading from DB2 7.2 to DB2 8.2
  28. How to drop an index named as "XPKsp_prj_stk_ord_"?
  29. Setting Performance Benchmarks
  30. snapshot tbsp table functions via jdbc
  31. Storing Objects in DB2
  32. db2 V7.2 trap after FP5
  33. Announcing Yellowfin Version 2.5 upgrade release for DB2 based users.
  34. Redirected Restore
  35. Business rules
  36. Reorg Not Reclaiming Anticipated Space
  37. IDUG 2006 - Europe Conference, 2-6 October in Vienna, Austria
  38. How Do You DO This in DB2
  39. remote connection
  40. Connecting to DB2 running on Linux
  41. Locks
  42. Backup/Restore from one tablespace ot another tablespace in the same database
  43. Certificate 700 (DB2 Familly Fundamentals)
  44. Need guidance on DB2
  45. displaying message from triggers
  46. Error while connecting to DB2 Z/OS from DataStage
  47. UDF
  48. db2_all help
  49. DB2 UDB API SQLSetConnectAttr(hdbc,SQL_ATTR_CONNECT_NODE,node, SQL_NTS)
  50. DB2 Latest Fix Pack
  51. How do I format a DOUBLE?
  52. Ulimit setting for a 32Bit DB2 on 64 Bit AIX
  53. db2client + isolation level
  54. Start hadr primary db failed with SQL1768N, reason code 7.
  55. Shell script help
  56. unique constraint and unique index
  57. event monitoring
  58. UDF error
  59. Event ID: 7031
  60. Assign multiple variables from select statement in Procedure
  61. Tablespace containers question?
  62. how to switch back after rerouting to alternative server
  63. Index rebuilt - Time Estimation
  64. Unable to connect to the DB
  65. Initializing Tapes when using multiple tapes
  66. Dynamic SQL within Procedure - String Continuation/Builder
  67. DB2 migration issue from AIX to Linux
  68. DB2 migration issue from AIX to Linux
  69. How to group date periods together ?
  70. BLOB
  71. Optimize UDF speed
  72. SQL30082N with reason "19"
  73. Single Quote
  74. Oracle's SPOOL equivalent
  75. db2sysc consume a lot of memory
  76. DB2 v8.1 Z/OS - What catalog table are SQL Stored Prcedures saved in ?
  77. how to stop new applicaitons from connecting to the databases?
  78. DB Backup to tape on Windows NT Server
  79. Designing tablespaces with a SAN in mind
  80. Can connect to one DB but not another on same server??
  81. DB2 Statement Cache
  82. Slow insert/logging performance
  83. import issue
  84. Remote Detection of IBM DB2 Version?
  85. connecting to a db
  86. CHAR datatype issue
  87. Installing FixPak
  88. diaglog size too big
  89. VARCHAR vs. LONG VARCHAR
  90. DB2 Beginner.
  91. SNAPSHOT_LOCK Errors
  92. Federated Access - DB2 to SQLServer using unixODBC driver
  93. Systables lock during REFRESH TABLE causing issues
  94. DB2 7.2 client and 8.2 server?
  95. Searching View with LIKE predicate
  96. db2 migration problem
  97. What is logged for insert on identity column
  98. Db2 mirror tables
  99. DB2 SQL1224N Error on Windows 2003
  100. db2 & perl
  101. A recasing UDF
  102. COMMIT and DGTTs
  103. Backup and OS Swapping
  104. Backup and OS Swapping
  105. db2look
  106. No remote connections available
  107. Impact of Overflows and Page Reorgs
  108. DB2 EE (or Connect) and iSeries Scrollable cursor problem
  109. Query on indexes for performance tuning
  110. Not Logging
  111. Parameter marker in Select
  112. decomposing/composing XML with only SPs, without code, possible?
  113. SQL query
  114. Variable response time from db2 udb 8.1.9 linux rh 2.3
  115. user list
  116. error when inserting xml into database - string literal too long
  117. error when inserting xml into database - string literal too long
  118. How Can Inclusion/Exclusion of Columns Affect Number Rows Returned?
  119. db2diag.log error
  120. Buffer Pools
  121. WII Federated Data Server on zSeries?
  122. DB2 restores after unrecoverable load in single and mulit-partitioned DB
  123. DB2 restores after unrecoverable load in single and mulit-partitioned DB
  124. multiple db2fm processes and a huge table with a BLOB field?
  125. DB size
  126. table with BLOB impact database performance?
  127. SQL1042C when doing dascrt
  128. DB2 Features: Threads
  129. Online Backup
  130. Usage of TYPE in DB2
  131. Timestamp issue under heavy load
  132. HADR
  133. Command to Display Curernt SQL for a Job
  134. A subtle error in error message parsing db2 udb v8.1.9
  135. Question: Tablespace recovery without logs
  136. Query question
  137. Attach...
  138. Software Testing Resource Hub !
  139. problem with GUI tools
  140. problem with db2iupdt & db2icrt
  141. Null Column on a view
  142. Insert select from SQL table function that modifies sql data
  143. Question on Alias
  144. db2setup on RHEL AS V4 doesn't work
  145. question regarding OR clause with fietch first 1 row only
  146. Java API for tools like db2iList
  147. resolved:DB2 V5.2 on XP SP2
  148. About Discoonection
  149. date/time
  150. Need a 1 min run down of how to log executed SQL statements please
  151. Instance
  152. DB2CLI Crash in multithreading
  153. AS400 and SQL DTS
  154. DB2 Load Utility and Default Values for some columns
  155. db2 load
  156. urgent help me plz
  157. Manually initializing MQT und use Staging table
  158. DB2 Cold backup
  159. Defining additional keys in a joined logical file (DB2/400)
  160. plz help
  161. Strange problem
  162. how to make a chr(0) as the default value of one column?
  163. Quiesce behavior
  164. Rows on the fly and an outer join (use a lateral statement?)
  165. Loading several tables with a single LOAD command
  166. DB2 II for Linux AMD 64 bit
  167. thoughts on regular expression matching
  168. Date function
  169. URGENT :: kill rollng back process? or atleast the status to get the time estimated..
  170. sqlcode 444 sqlstate 42724 while tryint to build a java stoed proc from RAD
  171. OLAP-Functions missing in DB2 Express-C?
  172. event monitor for statements
  173. DB2 DBA: For a CMM 4 An American IT Services Company.
  174. DB2 enabled Datawarehouse Pilot
  175. ADM7508E Database quiesce request has failed. The sqlcode is "-1044"
  176. Current Isolation - Urgent!
  177. upgrade DB2 WSE to ESE
  178. Delete Performance improvement
  179. DB2 control center
  180. DB2 Reporting tools
  181. java.lang.ExceptionInInitializerError: java.lang.ArrayIndexOutOfBoundsException
  182. Error while trying to access db2 mainframe tables
  183. DB2 8 on VMWare problem
  184. How important is KAIO for DB2?
  185. The statement is too long or too complex ?
  186. DB2 support for internal procedures
  187. client userid and odbc
  188. TOOLSDB Missing
  189. DB2 Cube views
  190. Privileges in DB2 v 8.1.9 linux
  191. tools catalog
  192. Help with query
  193. DAS
  194. SP error
  195. Installation probs with DB2 universal Database 8.2
  196. tools catalog
  197. hi
  198. tools catalog
  199. DB2 Scheduler
  200. Question on SUM()
  201. Data Type Comparison
  202. Intelligent miner for data - What's behind ??
  203. DB2 "CONNECT to" or "CONNECT TO"
  204. Federated (information integrator) load from cursor - Oracle date problem
  205. -911 on online incremental or delta backup db2 luw 8.2 on AIX
  206. load utility & identity column -- bug in db2?
  207. Reducing the high water mark for LOB tablespace.
  208. Restore database from v7.2 to v8.2
  209. DB2 Performance problems after REORG
  210. Exam 700 Query--pls help(Urgent)
  211. Run SQL from Windows against AS/400
  212. Becoming URGENT password invalid
  213. problems with concat and parameter markers
  214. Insert taking ages
  215. Access Plan - Operator question
  216. Question on Reorgs
  217. I hope in Serge Rielau
  218. Urgent SQLCODE : 30081 Connection problem
  219. IBM DB2 V9.1 for Linux, UNIX, and Windows delivers hybrid XML/relational data server
  220. V8.2, WINDOWS
  221. CLP Stored Procedure Call differences
  222. password invalid
  223. REORG + INLINE COPY
  224. Drop/Recreate parent table
  225. INSERTIN' INTO TEMPORAL TABLE THE RESULT OF A STORE PROCEDURE
  226. Connecting to Server Problem
  227. Instances
  228. IMPORT ASC
  229. TRIGGERS AND PACKAGES
  230. archive logs regularly for restore on 2. server
  231. Replication on 1 server
  232. CHGQRYA and UDF_TIMEOUT
  233. Shrinking "automatic storage" tablespaces
  234. modifed timestamp of a table
  235. Intelligent miner for data - specific question...
  236. UOW
  237. Help: connecting to db2 udb v8.1.9 linux
  238. 701 DBA certification test - *recommendations*
  239. Star Joins
  240. Impacts on migrating UDB DB2 8.1 to DB2 on Mainframes
  241. sql reason code logging
  242. DIA8533C The system memory limit was reached
  243. alter table in a stored procedure
  244. DB2 TSM backup hung, how to take back control?
  245. plz help
  246. DB2MOVE and generated always columns
  247. UDB 8.1 replication
  248. numeric userids in db2 udb v8.1.9 linux
  249. tablescan instead index scan
  250. Trigger compilation error
  251. sql0901, reason "column number out of range"
  252. SQL challenge in DB2 v8.2 environment
  253. How to convert a stored-proc with one result-set into a table udf
  254. Name too long error when using Load from cursor table
  255. does timerons include the fact of partitioning
  256. Calling Runstats from VBA
  257. Moving from windows to AIX
  258. Authentication
  259. moving tables between schema
  260. hi
  261. Tabelspace Informations
  262. VARBINARY - BINARY
  263. be careful with "application idle time"
  264. Moigration from Oracle 10g to Db2 8.2
  265. DataStage connectivity with DB2 Z/OS
  266. how to grant all tables
  267. make a copy of database to local
  268. Setting a specific Isloation Level at a Database Level
  269. cli load question
  270. xquery error
  271. a strange sql explain
  272. MQT on MQT. Is it possible?
  273. Unable to start HADR reason code 7
  274. translate function
  275. Disabling Constraints in a table
  276. PreparedStatement
  277. Bulk insert from a CSV file to a DB2 file. How?
  278. Stored procedure can't be found
  279. makefile
  280. Wider columns or Deeper Rows?
  281. Spatial Extenders index usage
  282. Install Fixpak 8.1 11 from 8.1 7 connection woes
  283. Parent Child Relationship - System catalog tables
  284. Monthly security Audit Check
  285. DBA Interview Questions
  286. Oracle Server Quick Reference Guide
  287. CREATE TRIGGER ON INSERT
  288. SQLJ.install_jar raises unexpected system error
  289. Problem with executing script under root
  290. Problem with database updation field
  291. 2 Serge Rielau: please, repost bitwise ops implementation (udfbit)
  292. Using a trigger to enforce unique if not null DB2 v8.1.9 linux
  293. cygwin - DB2 on windows
  294. fetching data from db2 using stored procedure
  295. DECLARE/FETCH USING JAVA..(POSITIONED UPDATE)
  296. Issue with executebatch()..Need to know failed records ..not from the exception
  297. CASE AROUND ORDER BY?
  298. VMWare and DB2
  299. Expert tunning Database
  300. Moving Tables from SMS to DMS tablespace
  301. the performance of delete with commitcount routine
  302. seek select statement to fetch rows older than five minutes
  303. select query, return CSV in field
  304. Can I overload stored procedures based on param type?
  305. Can I dynamically reference the table and/or column name in a triggerbody? Special Register?
  306. DB2 AIX: Stored Procedure Dependency Script
  307. Combining rows into a single column
  308. Duplicating a Database using RMAN
  309. SQL0723N, -746 SELECTing from the trigger target
  310. DB2 cursor problems
  311. Unexpected SQL0964C Transaction log full
  312. VIEW and GROUP BY
  313. How to select
  314. Index Utilization at Database level
  315. FETCH operator in SQL plan
  316. Suggest data type
  317. Query Performance / Table Scan.
  318. Does DB2 8.2 Enterprise Edition support IPv6?
  319. problem in creating an instance
  320. What in validates Dynamic SQL Packages in Package Cache ?
  321. DB2 Daily Check Lists
  322. performance issues related to timestamps
  323. Need info about DB2 archiving tools
  324. Need Tech Review of DB2 Backup Chapter for O'Reilly Book
  325. DB2e FIPS 140-2 Compliant????
  326. unable to insert data and time values into table
  327. Online documentation, spelling mistake
  328. SNAPSHOT_TABLE
  329. introduce db2 database
  330. How to get table name from dynamic query ???
  331. About Exit Handler
  332. Running SQL script
  333. Altering a distinct data type
  334. db2look privileges?
  335. Date format
  336. A dream of more functional CLP in v8.3
  337. VB .NET parameters seems to only use order
  338. MF DB2 Stored Procedure Call from SSIS 2005
  339. Bulk Data Transfer
  340. suppressing SQL0100W message
  341. LIKE WITH HOST VARIABLE IN SQL UDF
  342. AS400 to AS400 connection
  343. List applications and Client login ID
  344. Distinct data type
  345. activate not logged initially - bug or feature?
  346. Comparing databases
  347. DB2 Load Varchar for bit data
  348. string data right truncation
  349. Database backup without using 'backup database'
  350. Uncommitted statements?
  351. help needed for displaying a numeric value in a aprticular format..URGENT!!
  352. Application hanging
  353. direct writes
  354. Java Program to list of DBs in DB2 Instance
  355. minpctused
  356. VB .NET parameter has incorrect automatic argument
  357. Unable to start DB2 DAS
  358. Unable to start DB2 DAS
  359. Monitoring Index Reorg
  360. String data right truncation
  361. DB2/CM & SAN
  362. regarding tablespace PIT recovery.
  363. Nodename in catalog?
  364. primary key index?
  365. stored procedure
  366. SQL1042C An unexpected system error occured
  367. DB2 Backup Problem into Samba filesystem
  368. MDC question
  369. MDC Question
  370. Database Status Script
  371. Possible DB2 bug in the stored procedure parameters handling.
  372. Please Help Urgent
  373. Can I create DB2 partitions across multiple flavors of an OS?
  374. Reorgchk Stored Procedure.
  375. restart sequence number
  376. MDC woes
  377. Should I create an index when there's already a composite index?
  378. problem with db2start
  379. V8.2.2 change package-owner without bind?
  380. Multiple session table joins
  381. can i create udf this way ?
  382. List of tables having maximum number of rows
  383. Partition an existing table?
  384. SQLCA error handling in multithreaded environment
  385. Version 9
  386. Comparing tables
  387. Redbook for stored procedures
  388. Client version higher than DB causes error
  389. String Comparison
  390. store strings in different languages (diff. code pages) in one table field
  391. pls help urgent
  392. Definition of a 'Very Large Table'
  393. Design of a table
  394. Can I create an index on a view?
  395. .NET UBB link? (file on web)
  396. Waiting for uncommited rows
  397. What's the best way to move from one DB2 server to another?
  398. Merge problem
  399. IOWAIT/LOCK state when performing Insert into XYZ Select * from XYZ
  400. Guidelines for db server on SAN
  401. runstats within open transaction
  402. Urgent - DB2LOAD API db2LoadInfoIn Struct
  403. working with a stored procedure
  404. Privileges
  405. Can't get primarykey list using ado openschema
  406. listener on port 8888 goes down
  407. Creating Scalar UDF
  408. Connect to IBM DB2 database without installing the DB2 client.
  409. Multiple DB2 Client Versions
  410. Multiple Application Group possible ?
  411. DB2 - OleDb - Unable to use Catalog Library List
  412. list applications only show one connection (catalog/uncatalog database)
  413. Can you tell if a REORG is in 'paused' state?
  414. getting comm errors in db2diag.log instead of sql errors
  415. Can you tell if a REORG is in 'paused' state?
  416. DB2LOAD API
  417. which data type to select
  418. DB2-Mystery with Multithreading and new compiler
  419. adding constraints to a view?
  420. Version 9 and .NET
  421. restore tablespace backup onto another system
  422. Storing some Japanese data.
  423. Traversing Relationship Tree
  424. db2 jdbc
  425. cursor as OUT parameter of a stored procedure
  426. cursor as OUT parameter of a stored procedure
  427. Cascading delete
  428. Path where database is created
  429. Error while connecting to a database
  430. SQL explain plan
  431. DB2 Development Center & COBOL for Z/OS
  432. String matching in LIKE predicate...
  433. Difference between DB2 Client and DB2 Connect
  434. DB2 Backup strange Problem
  435. Calculating percentage in sql db2 with decmial precision
  436. crash when trying to get snapshot size
  437. JDBC error
  438. DB2 Instance Crash
  439. Finding the 'Client login ID' aka 'Execution ID': DB2 AIX
  440. trigger happy
  441. db2 database online copy help?
  442. DB2 Trigger To Track Table Changes
  443. INSERT but ignore duplicates
  444. Sample table structure to store pics in DB2
  445. Thema: DB2 + XML-Funktionen
  446. SQL7962 Error When Selecting From AS400 DB2 Database
  447. Formatting a Timestamp
  448. How to upload a sql file as a member of a data set in db2
  449. How to upload a sql file as a member of a data set in db2
  450. user authentication
  451. Java / JDBC DB2 export
  452. DB2cca problems.
  453. software services
  454. EMC and DB2 on Z/OS
  455. Raw I/O on Linux
  456. DB2 Client run time for linux
  457. DB2 via REXX on Z/OS
  458. DB2 via REXX on Z/OS
  459. how to do DB2 RTCL upgrade on Linux
  460. SQL Tools for AS400/DB2?? What are you using?
  461. SET CURRENT LOCK TIMEOUT has no effect
  462. Regarding install_jar functioning
  463. Convert rows to column
  464. Convert rows to column
  465. GSS security plugin issues
  466. db2 connect required for accessing db2 on z/os?
  467. BEGIN ATOMIC, COMMAND CENTRE SCRIPT
  468. db2 connect required for accessing db2 on z/os?
  469. Naming conventions for datamart columns
  470. MQT
  471. SQLCODE -204 using a jdbc-driver to UDB DB2 v8.2
  472. Regarding install_jar ... Urgent
  473. SYSPROC.DB2LOAD
  474. SQL2038N A database system error "-5130" occurred during processing.
  475. Load Utility
  476. db2advis with stored procedures
  477. Error while running cron job with DB2 in RedhatLinux
  478. Moving tables to new schema
  479. DB2 Content Manager: Is it J2EE Compliant?
  480. DB2 DAILY CHECK LISTS SCRIPT
  481. Query Tools
  482. Utilizing db2mtrk..
  483. Trranslating ORACLE functions to DB2
  484. Help! inserting records and functions
  485. db2 connection error while running script
  486. CSV file with Headers
  487. How to do a sql update based on a join?
  488. Priming the Package Cache ?
  489. Slow stored procedure after upgrade to 8.2
  490. SQL error
  491. How to join those 2 char columns?
  492. Performance of load from a cursor .... federated cursor?
  493. DB2CODEPAGE Variable
  494. Moving cursor in Command Editor results screen results in update of table
  495. Data Conversion in DB2
  496. Parsing arrays parameters in DB2
  497. Multiple Instances and their corresponding entries in the services file
  498. calculation percentages using sql command
  499. DateFirst in SQL Server
  500. very interesting - why two equal calls is different?
  501. changed machine name - unable to work in DB2
  502. Mother Celko's Monday SQL Puzzle #3
  503. createin privilege
  504. Mainframe Developer needed-SC
  505. Bad magic number for shared library: libdb2.so
  506. Bad magic number for shared library: libdb2.so
  507. db2pd -activestatements
  508. UnsatisfiedLinkError in Java UDF
  509. Datatype for creating a range value in db2
  510. -2 option in SQL table function for snapshot does not get global snapshot
  511. About Encrypted Data In DB2 UDB
  512. staring and stoping a database in DB2
  513. Can the notification log (.nfy) be deleted?
  514. Inserting Data using a Stored Procedure
  515. SQL1247
  516. SUM(double_value) is not deterministic?
  517. Query Tuning Help
  518. Index creation status
  519. DB2 Instance Crashing
  520. running utility task on all tables
  521. DB2 v8.1 (UNIX) on tape
  522. Performance problem in db2
  523. Third pary tool for db2 backup and recovery
  524. Using a cursor for Update
  525. Tempspace UDB V8 FP 10
  526. Tempspace UDB V8 FP 10
  527. How do we execute this command through java?
  528. Geographical clustering for DB2
  529. Searching for strings and replacing them
  530. multiple result sets
  531. Create DB2 USERS and Connect
  532. DB2 Instance Status
  533. Execution plans and temporary tables
  534. monitor lockwait
  535. Accessing the data from DB2 servers using C# Application
  536. DotNetNuke help Needed!
  537. FOR READ ONLY cursor a named statement
  538. DB2 performance variables
  539. import utility
  540. how to analyze db2expln results
  541. Obtaining parameter MAX_CONNECTIONS through the API
  542. DB2 Access Slow With MISys Application
  543. multiple outer join
  544. Server Security Plugin Error
  545. Cloudscape - usage of?
  546. DB2 Daily Check Lists
  547. Comments in SELECT via PHP/ODBC DB2 UDB v8.1.9 Linux, PHP 4.4.0
  548. Stored procedure slower than an ad-hoc query ?!
  549. Utilization Statistics during data load
  550. Tool to determine Hardware needs for a DB2 server