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. Passing parms to a C Stored Proc
  2. Deadlocks even with SELECT FOR UPDATE
  3. An error on search table.
  4. TIps on Delete Cascade performance
  5. Table definition for Storing a PDF page
  6. Call for speakers: IBM Information On Demand 2006
  7. Error on adding DISTINCT to a SELECT DB2 UDB v8.1.9 Linux
  8. Sort memory
  9. Sort memory
  10. Errors in stored procedure in db2
  11. Problems with performing db2updv8 on database in db2
  12. automated-access-plan comparisons on LUW (db2 v8.2.2)
  13. SET integrity fails despite of for exception...
  14. DB2CMD in XP - DOS batch file
  15. Overflows in tablesnapshot
  16. SQL0954C -- Not enough storage is available in the application heap to process the statement.
  17. Creating a simple UDF
  18. set variables to be used in creation of result set.
  19. DB2 forum???
  20. Slow execution of Delete Statements
  21. Controlbreak flag in result?
  22. DB2 UDB Stored Procedure help
  23. creating pivot tables
  24. Index Naming Standards
  25. optimize DB2 query
  26. database backup -linux to windows
  27. Retrieving most current entry?
  28. EEE - Nodes utilization question
  29. Two tempspaces on database
  30. PLZ help me out
  31. Perl and DB2
  32. DB2 Queries
  33. Installation mess
  34. Create a table with a structured UDT (user-defined type) as a column
  35. Tasks not found in version 8.2
  36. can i use load terminate with cursor for select * from table name?
  37. Passed DB2 UDB 701 test, how can I prepare for 704 test (Advanced DBA)?
  38. Problem with DBD::DB2 and UTF8.
  39. FYI: FP11 and error -925
  40. Running multiple SQL scripts in the background ... no longer possible?
  41. column "generated always as" generated from multiple columns
  42. How to locate the static SQL fired by an application in DB2
  43. The HighValues plague returns....
  44. problem with procedure call
  45. View DB2 Table definitions in QMF
  46. backup question
  47. partioned table or partioned index
  48. DB2 Experts To Contribute To 85K Newsletter
  49. identity-alteration RESTART option
  50. DB2 version 8 DBA (Houston, TX.)
  51. DB2 Connect returning data in HEX?
  52. SQL Cross join
  53. Language Issues
  54. redistribute nodegroup
  55. Rename a database?
  56. Install IBM DB2 on Fedora Core 5 (Bordeaux)
  57. Sudden excessive access time to DB2 via ODBC?
  58. Accessing DB2 on an AIX server via ODBC from MS Excel
  59. SQL stmt to find if table is in load pending state?
  60. IGNORE NULLS possible fro CREATE INDEX? DB2 UDB v8.1.9 Linux
  61. Syntax question DB2 UDB v8.1.9 Linux
  62. Storing Japanese characters in UTF-8 database
  63. Naming ...
  64. Naming ...
  65. GENERAL SQL Question
  66. Help performace question DB2 UDB v 8.1.9 Linux
  67. Truncate Table
  68. column functions
  69. How to recover db2 instance user's privilege?
  70. remove spaces from field contents in DB2 database...
  71. DB2 Backup
  72. Privileges on SP??
  73. I need help
  74. HADR and failed tablespace creation
  75. Multiple SQL SPs accessed from one SP
  76. how to create a DB2 system dsn in linux fedora core 4
  77. Writing file from procedure
  78. Replication using asnload
  79. can someone help me figure out what caused the rollback?
  80. DB2e_Shadow
  81. DB2 Version 8 - libeay32.dll problem
  82. SQL0298N Bad container path Error
  83. Log Full
  84. Duplicate rows from a SELECT DISTINCT DB2 UDB v8.1.9 Linux
  85. Open LDAP Plug-In Anyone?
  86. Multiple Temp Tablespaces
  87. z/OS to AIX connection - authentication/authorization
  88. Viper and VisualBasic
  89. Calling SYSPROC.DB2LOAD within SQL stored procedure
  90. Moving db2 to a dedicated partion
  91. Should db2 summarize or home grow a build app in C
  92. problem with long object name
  93. FETCH FIRST ROW ONLY
  94. plz help me out
  95. delete from table where in, problem
  96. top-down-top query approach
  97. MERGE in V8.2 FP4 (on condition returns multiple rows from target)
  98. Differences between UDB V7.2 and V8.2 for federated connections?
  99. Uninstalling v7.1 on Solaris
  100. re-configuring db2 server for client operation? [comparison to oracle]
  101. Compiling stored UDFs
  102. Parameter Markers in SQL queries and ADO.NET
  103. Lock escalation in SYSCOLDIST
  104. help me out
  105. How do I do this in DB2
  106. DB2 Viper Testdrive
  107. SQL0902C - SQLSTATE=58005 - Reason Code = "14"
  108. Seek newbee Java UDF installation tip
  109. Blocking Agent ID for Locks in SNAPSHOT_*
  110. Multiple temp tablespaces with same page size
  111. Multiple temp tablespaces with same page size
  112. ADO.NET - strange behavior
  113. About automatic database maintenance
  114. db2pfchr processes and high CPU
  115. Catalog Database
  116. Problem with Global Temporary Table
  117. About Multiple Cursor from Stored Procedure
  118. db2cmd.....
  119. SQL issue? Can this be done?
  120. Reading an explain Plan
  121. Functionally equivalent exception Join
  122. Command Editor problem?
  123. Extended optimization messages
  124. Is "One view per table in DW" really a good practice?
  125. locks and related
  126. Confused on how to get a percentage of total using OLAP functions
  127. slow download-insconsistent latency
  128. DB2NTMEMSIZE
  129. db2diag.log error
  130. Need ROLLUP expert advice!
  131. Is there a way to find the record causing SET INTEGRITY command to fail?
  132. Problem inserting spanish characters in DB2 UDB
  133. Problem with Backup/Restore with Vendore Products
  134. How to Drop data from table quickly
  135. db2_evaluncommitted
  136. Parameter.Add need help - not understanding
  137. DB2_FMP_COMM_HEAPSZ - need help!
  138. Sequences in db2 8.1.0.36.
  139. Grouping SQL statements
  140. SQL6024E Table or index "tab_name" is not defined on node "0".
  141. SQL Server co-existance
  142. how to rollforward without userexit - SQL1268N
  143. db2 File system caching ..DIO or CIO??
  144. db2 File system caching ..DIO or CIO??
  145. db2 File system caching ..
  146. Control Center Error
  147. Alter Column
  148. Illegal Immigration, the Non-Issue of the Week??????????????
  149. How to obtain the schema from a JDBC Connection ?
  150. 2-nd edition of Celko Puzzle book in the works
  151. Truss output - semget analysis
  152. Inserting data into a DBCLOB column
  153. Passing a parameter to IN predicate of DB2 udf
  154. LOWER() and UPPER() functions not found.
  155. limiting number of rows returned by resultset
  156. Control Center doesn't find backup files
  157. Issues with loading 124 million records
  158. Set level acestor report; DB2 UDB 8.1.9 Linux
  159. Restore not finished
  160. Query performance
  161. jdbc and list of all databases
  162. Is db2uext2 archiving directly to tape?
  163. DB2 Application Development Client
  164. creating a database using DB2
  165. Mixed Case in table and column names.
  166. T-SQL to DB2 UDB SQL-PL conversion...
  167. SQL construct conversion...
  168. Can't get table out of check pending state after load.
  169. Group Authentication
  170. DB2 V8 z/OS
  171. What's wrong: SQLCODE -30082 password missing (on windows)
  172. SQLCODE -1024
  173. Computing the product of a column groupped by...
  174. Triggers crashing database ?
  175. Migrate DB2
  176. SQL1224N - A database agent could not be started to service a request
  177. jpg file to mainframe
  178. Mixing SQL and traditional I-O in an ILE COBOL program
  179. Query Performance
  180. DB2 Control Center crashes
  181. insert data into graphic column
  182. Shell Script eroor while using db2 export
  183. Locking issue
  184. regd data migration from DB2 v7.2 to SQL server 2000
  185. i can not create db2 sample
  186. Transaction Log full.
  187. # of Agents -> db2 list applications
  188. Tablespace on NFS (Netapp filers)
  189. deadlock related
  190. [IBM][JDBC Driver] CLI0622E Error accessing JDBC administration service extensions.
  191. Authorization/Privilege Issue
  192. SQL/PL Stored Procedures and SYSIBM.SYSDUMMY1
  193. Case Sensitivity in DB2 on linux
  194. alter query
  195. DB2 Query problem
  196. DB2 UDB Detective - Ace Ventura
  197. NULLID.SYSSN300
  198. Logging
  199. odbc connect string and library list
  200. SQL help
  201. Is LOAD really this brain damaged?
  202. Sequence number for a Batch
  203. Help me to Create Database
  204. DB2 Redirected Restore
  205. About Encryption Function in Db2
  206. iSeries: JDBC problem v5r3
  207. multi-file multi-table import
  208. table identifier for db2ReadLog
  209. Simple Query
  210. to fetch first record
  211. DB2 exception handling in triggers
  212. DB2 error handling in triggers
  213. How to get generated key back in php/db2 v8.1.9 Linux
  214. How to do more things in DB2
  215. Is this the right way to go about ranking things?
  216. Backup a suspended database with SMS tablespaces possible
  217. nonrecoverable load during backup
  218. User Defined Function in DB2 Urgent Help please
  219. Exporting current system timestamp to unix server
  220. Timestamp equivalent in DB2
  221. SQL0818N after V7 -> V8 migration.
  222. IXF LOADing w/ different column orders
  223. Sql help
  224. DB2 SQL error: SQLCODE: -805, NULLID.SYSLH20A 0X5359534C564C3031
  225. DB2 CF and Visual Studio 2005
  226. How to load a cursor from a stored procedure in DB2
  227. Strange error:An unexpected token ")" was found...Expected tokens may include: ")"
  228. 2 version of admin client on same PC?
  229. about high security field
  230. DB2 Incremental BackUP / Restore problem from one machine to another
  231. Checksum for Duplicacy check
  232. Catalog-view to get tablespace-state?
  233. Places to schedule database backup in DB2 UDB V7
  234. Cursor Load fails with SQL0964C error
  235. Merge Alternative
  236. Upgrade my db2 8.1 fixpak 6 to last release
  237. V8.2 Express Edition XP Home
  238. task center error 22207
  239. size of db2 udb database
  240. Ink
  241. Just for laughs..
  242. Migrating DB2 UDB 8.2 dbs from windows platform to Linux
  243. Building Simple SQL Stored Procedure
  244. Ink
  245. HELP! reading syscat from php in db2 udb v8.1.9 Linux
  246. Recover IBM DB2 Data (Urgent)
  247. Senior Mainframe Cobol CICS DB2 Programmer Needed in Alabama
  248. Stored Proc Performance Improvement
  249. Stored Procedures / UDF
  250. DB2 program to read log files ... incorrect function identifier
  251. Data Replication DB2 VM to UDB with DPROP
  252. Data Replication DB2 VM to UDB with DPROP
  253. DB2 Backup into 3590 tape drives
  254. Difference between Collection ID and qualifier
  255. problem with Group By
  256. Comparing dollar amounts stored in a varchar
  257. Adding user data to the system metadata tables Db2 UDB v8.1.9 Linux
  258. DB2 and embedded SQL
  259. Expected Impact of Changing Logging Type
  260. get a list of all users in db2
  261. Query performance - Please help
  262. extracting db2 table records to csv
  263. How can i connect to tables created in a schema with a username different from the schema name?
  264. Drop Table
  265. Optimizer not using MQT ?
  266. load data into varchar column
  267. Relocate DB2 databases part 2
  268. How to convert DB2 data type P to SQL
  269. How do i ensure 'insensitive' (ie static) cursors that are only forward readable (in DB2 for mainframe)??
  270. What is the connected database?
  271. Select the 2nd of a sequence of rows in a table
  272. SQL to get the max or min record which one is better?!
  273. What's incorrect with this function?
  274. Relocate DB2 databases
  275. DB2 Rollforward DB query status
  276. DB2 + shell script
  277. Is there a way to import tab delimited files into a db2 table?
  278. DB2 Table Editor Search Conditions
  279. load from cursor
  280. load from cursor
  281. UNIX shell script and DB2 Queries
  282. Sort after index scan
  283. OS/2 (yes) backup to XP Excel
  284. Inserting into temp table using Cursor
  285. Changing an index controlled partitioned table to table controlled.
  286. Alert notification time
  287. MDC + Partitioning Key
  288. SQL Query to concatenate columns
  289. Statement Isolation Level
  290. Concatenating rows ?
  291. generated columns for z/os
  292. Uregent finding difference between count of two coulumns
  293. How to get instance's server port?
  294. Selecting only letter and number characters
  295. SQL1031N error help
  296. UDB sort sequence problem
  297. report issue
  298. How do I prune db2rhist.bak and db2rhist.asc?
  299. Generating SQL Scripts from SPUFI
  300. How to find out the Java Version in DB2 personal edition 8
  301. select count(*) - Full table scan
  302. Convert DECIMAL to DATE
  303. Restore to new node using TSM fails
  304. Error while running sdl scripts
  305. Parallel Database
  306. WPAI on iSeries DB - Problem
  307. CLI Wrapper for .NET Platform
  308. DB2 UDB Error Handling
  309. Bulk Load BLOB using DB2 CLI
  310. Easy Group By Question (I think/hope)
  311. Puzzled
  312. How to do...well...anything...in DB2 SQL
  313. DB2 - Decode Compiled SQL Statements
  314. Exception Handling in DB2 UDB
  315. Exception Handling in DB2 UDB
  316. Restore into DB2 replication database
  317. Isolation Level inside C++ routines / Slow performance.
  318. Database metrics
  319. DB2_LARGE_PAGE_MEM
  320. db2exfmt - client
  321. Product license ? Run time client ?
  322. Preserving comments when creating SP's from Command Editor
  323. Comments in Selects DB2 v8,1.9 UDB Lunix
  324. Lookig for a copy of "The ABCs of Plans and Packages" by Nicola Nur
  325. Trouble connecting to DB2 in Visual Studio 2003
  326. DBA cert
  327. Urgett !! redirected restore of a tablespace
  328. How to kill idle connections or sessions
  329. Max Connections
  330. Packages, Bind, Prepare and Execute
  331. Max Connections
  332. How to get my current connection id in SQL
  333. benefits of 64-bit db2 apart from addressability
  334. creating a Report
  335. have some fun and forget the problems
  336. CLP Execution
  337. db2 and the strip function
  338. DB2/COBOL Store Procedure Parmeter List (Reply)
  339. CPU Time (User / System) & Actual Elapsed Time for SQL
  340. DB2 8.2 32bit to 64 bit conversion
  341. Running a batch of sql queries?
  342. Running a batch of sql queries?
  343. DB2/COBOL Stored Procedure Parameter list
  344. Multiplatforms?
  345. Could you clarify IY63894 ?
  346. More than one CURRENT TIMESTAMP in a PROCEDURE
  347. Is it possible to move the ICMNLSDB database from one drive to another?
  348. how ADM1822W could happen?
  349. DB2 RT Client silent install
  350. refresh view ?
  351. federation
  352. Import Problem Urgent
  353. JDBC Type 4 Universal Driver SQL Error Code = -99999
  354. Data Warehouse Cube View Control Center
  355. Package cache hit ratio
  356. DB2 Connect Ver. 7.2 Client Assistant Export problem in Windows 2000
  357. DB2 Connect Ver. 7.2 Client Assistant Export problem in Windows 2000
  358. delete statement after a RETURN CURSOR in SP ?
  359. Convert TimeStamp
  360. give me idea for this procedure
  361. give me idea for this problem
  362. Federated database and host privileges on SYSIBM tables
  363. Query regarding Index
  364. Debugging SQL stored procedure using developement center
  365. Debugging SQL stored procedure using developement center
  366. DB design
  367. DB2 Sample Test Question? Which is the correct answer?
  368. Basic SQL prcoedure question
  369. Problem using db2sql92 on host db2 (Langlevel or missing package)
  370. DB2 Altering an integer to character type
  371. How to connect to the DB2 on a REMOTE machine from a C++ application on Linux?
  372. Connectting to as400 from DB2 ESE running on Windows XP
  373. Online Tablespace restore from incremental backups
  374. SQL0901N Error.
  375. Export af Tasks from Task Center
  376. DB2 ESE add Partition fail
  377. estimated execution plan
  378. FW: SR 603066805 : FW - Firewall in transparent mode with excessive packet drops
  379. Hast Du das schon gewußt?
  380. Special considerations to backup using ntbackup
  381. Report formating
  382. websphere vs sharepoint
  383. Aggregating strings
  384. Test database connection using C++
  385. memeory usage
  386. Licensing Issue
  387. my db2 routine deleting records with commit count ,any advice ?
  388. DB2 Replication Centre Issue
  389. online monitoring of sql statements
  390. Cannot Execute Create Server
  391. modelling tool
  392. Strange Errors in db2diag.log
  393. DB2 Certification exam 700 and 701 Question papers
  394. UDB: Backup Image Size & Used Pages Size
  395. problem with ibm db2 8.1 fixpak11
  396. urgent - Formating issue
  397. "SQL1024N A database connection does not exist" when using db2GetSnapshotSizeData and db2gGetSnapshot
  398. Import invoked from stored procedure
  399. external table function in DB2 LUW
  400. DB2/400
  401. Is DB2 8.2 ESE compatible with W2K3 Terminal Services?
  402. Problem with MERGE statement: SQL0969N Error Code: -788
  403. DB2 Environment Setup
  404. Provider cannot be found - Using current MDAC and Jet
  405. Restore DB2 System Tray
  406. DB2 Image Extenders
  407. INTRA_PARALLEL
  408. Pb load command JDBC driver
  409. db2 memory
  410. db2 memory
  411. db2 memory
  412. Number of simultaneous connection
  413. How to combine fields by SQL
  414. Long compiling of SQL statements
  415. DBHEAP usage during backup
  416. fenced vs unfenced in DB2 UDB
  417. Performance problem after replication
  418. Learning DB2 for Mainframe - how "hard" is it? How do you do it ?
  419. Which SQL's are executing and what are they waiting on?
  420. QMF for Windows and Updateable Views
  421. Load utility vs reorg
  422. Explain history
  423. Views and privileges
  424. calculate size of table with BLOB
  425. Cause of excessive paging
  426. install studio 2005 addins
  427. DB2 Migration
  428. DB2 and LDAP
  429. Accuired eServer i5 570 - Enterprise Edition; questions..
  430. SQL30081N after RESET DATABASE CONFIGURATION
  431. import sql dump
  432. db2exsrv
  433. Tablescan - why?
  434. A few questions: LOAD/IMPORT/CLP stderr
  435. DB2 Select
  436. DB2 v8 used LDAP User Id/Password on Connect
  437. IBM JDBC driver behaves differently on Linux than on Solaris
  438. db2 zos v8
  439. CLP option not working as expected?
  440. SQL0444N Routine "db2spcat" (specific name "SQL060216094049640")... Error
  441. request the next value for a sequence
  442. 2 default database paths have been used - how do I not screw up?
  443. Bug (?) in SQL: Global temporary table gets truncated on failed insert.
  444. How to see the client type?
  445. More messages in db2diag.log
  446. db2diag.log
  447. Using Federated Objects
  448. Simple Insert using Case statement
  449. LOB Conversion from Windows to AIX Problem - HELP!
  450. truncate in db2
  451. converting oracle script to db2 (hr_main.sql)
  452. multiple insertions through jdbc
  453. Question on data placement re Raid10
  454. FP10 upgrade issues - AIX (v5 32 bit) DPF data warehouse environment
  455. Using multiple database contexts
  456. how to find the base table of an ALIAS ?
  457. Inapplicable message? DB2 UDB v8.1.9 Linux
  458. DB2 Type 4 JDBC Driver
  459. IBMSNAP_CAPENQ lock issue with CAPTURE_STORAGEMGMT_INFO
  460. Package "NULLID.SYSLH203 0X5359534C564C3031" was not found
  461. Strange S1010 function sequence error problem with DB2 V8 and Windows app
  462. blank text columns
  463. configure automatic maintenance from command line
  464. Deadlock
  465. Question for SQL gurus
  466. v8.1 (win2K) database files into v8.2
  467. strange behaviour with temporary tables
  468. Backup with maintenance plan
  469. v7.1 group by and SQL0134N
  470. Locks on table.
  471. ALTER TABLE ERROR
  472. Segmenting tables
  473. reorg and reorgchk
  474. DBMS maintained views
  475. the problem about load from cursor
  476. SQL1220N
  477. Urgent problem - hanging primary key constraint
  478. DB2 UDB Help
  479. sqloPdbRecvBuffer errno=104 Any ideas?
  480. Linux: How does db2iauto work?
  481. Stored Procedure Issue:Call Vs Loop
  482. Passing variable parameters to stored procedures
  483. Select Range Query
  484. Range Select query
  485. jdbc date format error
  486. Backup/Restore/Copy Schema
  487. LPAD Decimal value
  488. DB2 ldap catalog traversal api documentation
  489. BINDFILE vs PACKAGE
  490. Many applications in Compiling status
  491. Decimal Formating issue
  492. Converting cics screens to java/.net
  493. Current and Estimate Table Data Size and Index Size for DB2
  494. How to find out which of the record that has been updated after an appliction runs.
  495. ibm db2 lock (row/table) status/indication
  496. geting SQL0668N on file load, please help
  497. Avoiding SQLCODE -746 when calling procedures from triggers
  498. Second join based on the lack of success of the first
  499. IBM DB2 Universal driver (JCC) not found
  500. question on index usage
  501. Connect to DB2 V7 and V8 in Java
  502. Problem with Information Integrator/Federated Datase - Oracle
  503. How to Alter size of an existing Blob Column?
  504. DB2 and Apple(Mac)
  505. DB is already in use by another instance, after system crash
  506. Great Job Board
  507. DB2 Memory leak
  508. DB2 UDB WE 6.1 -> UDB 8.2 Express - Is migration possible ?
  509. myDBA - web-based business intelligence
  510. db2 7.1 fixpack 12 backup error
  511. Problem creating a new database
  512. DB2 Programing help
  513. HL7 and XML
  514. Performance question DB2 UDB v8.1.9 Linux
  515. Run time error 3231
  516. Identity Column slow down the insert
  517. Question on determining heavy hit tables.
  518. Export data as well as the corresponding column names?
  519. " select * from sysibm.sysdummy1 where; ". Hmm...
  520. DB2 Type 4 JDBC Driver - Support for passwords with "|"
  521. Month question
  522. Month question
  523. How can I add an identity column to an existing table?
  524. Need help creating Instance
  525. Executing procedure
  526. Connection hang with HADR takeover by force and old primary server is down
  527. How can i use a trigger in DB2 to call a webservices in .NEt please i new in db2
  528. Generating CREATE TABLE statements for a table
  529. Using a PROCEDURE to EXECUTE other PROCEDUREs
  530. Weird Error Message
  531. Newer to DB2 - How can I do this?
  532. SQL0072 ?
  533. simple SELECT sets exclusive locks on table
  534. Developing a Wrapper
  535. Import delimited hexadecimal or binary data to "varchar for bit data" columns
  536. How to get multiple child rows from different tables into one resultset
  537. updating the code of a query
  538. internal plan lock and internal sequence lock
  539. DMS tablespace size error
  540. Can I run the client CC on Mac OS 10? Just java, yes?
  541. Disable error message descriptions in Command Center
  542. restrict record deletions between tables.
  543. FP11 available
  544. Does DB2 UDB v8 come with a compare tool?
  545. Error in diag.log(-444)
  546. How to find partitioning key of a table
  547. Preferred Export Format
  548. Help- DB2 DBAs Needed in Midwest U.S.
  549. UDB date query
  550. Table queue overflows