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. Please help. How to create Detail table using Summary
  2. composite keys and delete performance
  3. Unable to consume Web Service from DB2: DB2XML.SOAPHTTPV error in "\db2soapudf"
  4. cursor with hold
  5. containers info
  6. Database Partitioning Feature( DPF for EEE) concepts
  7. clarity on UTIL_IMPACT_LIM and UTIL_IMPACT_PRIORITY
  8. DB2 UDB Recovery after Total Media Failure or Server Loss due to Extreme Disaster
  9. How to translate string with data have integer + character and null data
  10. Windows Admin Rights for IBM DB2 Client?
  11. Exit/Continue handler for any errors
  12. connections to a node
  13. CLI0111E Numeric value out of range. SQLSTATE=22003
  14. ibm db2 000-700 dump
  15. table changes since last runstats?
  16. Environmental Variables
  17. DB2 equivalent for Oracle's PMON?
  18. DB2 equivalent for Oracle's PMON??
  19. timestamp subtraction
  20. SQL10007N 99999 on z/OS stored proc call
  21. SQL from Java - PREPARE (with parameter markers) vs. Dynamic
  22. Schema Read privilage
  23. db2 java application of 32-bit and 64-bit DB2 insatnce
  24. delete rows from two tables using one sql statement
  25. move a tablespace (sms containers) to different location
  26. ROWNUM functionality DB2 Ver 5
  27. hex function doesn't return what I expect
  28. db gets deadlocked while trying to delete records
  29. MS Access vs Shareware SQL query software
  30. howDB2 has a lot files under /proc on aix
  31. Regarding fee structure of DB2 certification
  32. Backup online error
  33. 64 bit SO + 32 bit Media + Db2 V8
  34. Find Active Queries in real-time
  35. Syntax Error-Help!!
  36. DB2 Health Monitor v9 fixpack 4 still can be a BIG PROBLEM
  37. how to stop all database manager processes even after db2stop
  38. DB2 8.2 on AIX 6
  39. db2 print message within procedure
  40. modify query to use ndexspace
  41. db2 performance issue (cli and db2batch)
  42. DB2 Bulk Load
  43. Federated access to Excel from DB2 9.1.1 on Linux
  44. SQLSTATE=42724 on z/OS stored procedure call
  45. Inline UDF returning a computed string
  46. Need help with Stored Procedure
  47. UDB JDBC procedure call causes S04E in DB2
  48. SQl Syntax Check
  49. computer trade shows
  50. HWM on Reorg Questioned
  51. Large Table Index Rebuild Problem
  52. Transport database to another system
  53. DB2 z/OS Unload question
  54. Recursive query - Help needed...
  55. select * view and alter table
  56. Backup-Restore problem
  57. how to adjust the column width for a result set?
  58. Global temporary Table
  59. datastage
  60. db2 error ( Agent not allocated, sqlcode = -1225 )
  61. Insert to table question
  62. Limits to statement size in ISERIES
  63. Similar LPAD function in DB2
  64. how to handle utf-8 char in db2 export
  65. trigger exceptions
  66. DB2 on z/OS
  67. Are you face any problem with processor....no problem study the fulldetails here...
  68. how to set priority
  69. moving objects from db2 on windows to linux
  70. Error Occurred in SQL Call Level Interface CPYTOIMPF
  71. variable for table name in stored procedure
  72. which Unix UDB Version 8 fixpack level equals 9 , 9.1 & 9.5
  73. how to convert bytes[] to blob
  74. Remote database
  75. Don't want to rollforward
  76. MESSAGE : Unable to find donor to satisfy minSize constraint
  77. Question on DB2 LUW auto-reorg
  78. DB2 and Windows Server 2008
  79. Inline UDF returning a computed string
  80. Is there a way to remove / clear / drop statistics for a singletable?
  81. New to db2
  82. Linking error
  83. SQL0803N duplicates and problems inserting
  84. winsql CASE statement
  85. restrict privileges
  86. disconnect all
  87. Transaction labeling
  88. Library of V5R2M0 iseries access for windows
  89. LOAD question
  90. Views & performance
  91. information on databases
  92. help for operation with date
  93. need help with UDF
  94. Execute Immediate in UDF
  95. Encryption algorithm & key length in DB2 UDB v8 & v9
  96. DB2 ALTER date
  97. encryption & unicode
  98. Problem with LIKE in cursor
  99. DB2 AWE configuration Error.
  100. JDBC driver fro DB2?
  101. Why DB2 developers could not make it possible to change statementtermination character dynamically?
  102. Insert into .. (select count(*),sum(xx
  103. Problem in creating stored procedure in db2
  104. ibm_db2 php module
  105. Does DB2 8.2 client support DB2 9.5 Server
  106. JDBC DB2 and CLOB
  107. Procedure variable scope?
  108. intra_parallel throttling
  109. db2look not showing not null characterstics for columns in hierarchy tables definitio
  110. DB2 Load (Replace vs Insert)
  111. SQL to determine RI constraints hierarchy
  112. Error while accessing User-defined function ( SQL0444N and SQLSTATE=42724 )
  113. SQL1139N The total size of the table space is too big.
  114. SQL1220N after Installation 9.5
  115. Can DB2 V8.2.9 address more memory when /3G flag is enabled on32-bit Windows?
  116. DB2 9.5 global variables
  117. Updating day portion od date field
  118. How to use the SET TERMINATOR directive to change the delimiter to newline?
  119. .NET assembly dll for connecting to DB2
  120. Please read me first
  121. how to get into..?
  122. DB2 does a tablescan even with an index present
  123. DB2 Stored Procedure Select
  124. White paper or source for Materialized tables?
  125. Restrict on drop and table is inaccessible
  126. Need Help with setting up a new db2 database v9 wse!!
  127. Excessive z-lock time with LOAD command?
  128. Table Create Question
  129. DB2 9.1 and 8.2 co-existence on UNIX
  130. AS/400 DB2 SQL optimizer issue?
  131. Function for adding 1 to a hex column
  132. db2pgixt.exe
  133. SQL Capture/Replay tool for db2 luw
  134. Execute immediate error
  135. Replicating data between IBM DB2 on OS/390 and MS SQL SERVER
  136. db2pd API
  137. QUESTION: Does db2 8.2 for z/OS support ALLOW REVERSE SCAN onindexes?
  138. DB2 HADR and ACR problem V9.5 on Redhat
  139. Problems with Import of UTF-8 files - Differences between LOAD andIMPORT
  140. Issue Reagrding Structure type array variable in SQC code.
  141. How to seed or increment NEWID() value
  142. Select the data with '
  143. Relational data base
  144. regarding BACKUP/RESTORE
  145. DB2 migration
  146. timstampadd function
  147. Making db2 use syslog
  148. Generating and running SQL on the fly
  149. QUESTION: Select <PK> from <TABLE> - index scan or table scan??
  150. getting sql0818n on db2advis
  151. need advise to create web based database directory
  152. Set integrity after load
  153. Deleting a Global Temporary table datas
  154. Enable encryption of Server authentication
  155. Informix SDS Functionality in UDB?
  156. AMD 2 Opteron servers, which Linux OS - CentOS or OpenSuse
  157. Db2 in cobol
  158. Columns Affected by UPDATE STATEMENT
  159. Division error on float data type in DB2
  160. ADM6017E error, but no obvious limit reached
  161. Db2
  162. Transaction Log full
  163. DB2CC - is it available for Apple Mac OSX
  164. ERROR:SQL1220N
  165. backup & filesystem snapshot question
  166. DB2 Store Procedure Using Fetch Cursor
  167. Doubts about the "For Read Only" clause
  168. DB2 Database Administrator Certification Path for v9
  169. Convert timestamp to yyyy-mm-dd format
  170. Changes with DB2 version 9 and automatic tablespaces / restore / listutilities
  171. capturing the result from Execute Immediate
  172. Wartning! Ubuntu- Users: db2exc updater currently broken!
  173. DB2 Execute Immediate
  174. how to maintain the cursor open in a procedure?
  175. Large Objects and Java
  176. Help with understanding : select stmt from sysibm.syspackstmt
  177. NFS / file system requirements for DB2 v9.1 on O.S. as RHEL (Very Very urgent)
  178. How do you display the Current SQLSTATE or SQLCODE
  179. Flush package cache for one sql
  180. db2 backup image file is having strange changes of sizes
  181. Using Group By with a scalar function or to find shorter way of coding this query
  182. MQT and too small transaction log size
  183. Export 50,00,000 records from a table into CSV file
  184. Insert from table in DB A to table in DB B
  185. SQL function for HEX input
  186. What's hash partitioning syntax on DB2 UDB v 9.1?
  187. Help needed writing an SQL statement with parsing
  188. Question on DPF implementation
  189. Mainframe software pricing, DB2, RACF, security/audit
  190. DB2 RECOVER Utility in Mainframe - Urgent
  191. i5 515 and console problem
  192. I don't understand what SQL20148N error is telling me. Can someone explain?
  193. How to get Databases Name in DB2
  194. DB2V9.1 UDFScalar error during build. Any tool to convert T-SQL to DB2 SQL?
  195. DB2 via IBM JDBC problem
  196. DB2 JDBC driver problem
  197. problem in result may be because GTT with threading in java
  198. db2 restore database TSM
  199. Database Crash : Need some urgent help
  200. Using SYSPROC.ADMIN_CMD to terminate load
  201. Sorting issues
  202. declare global temp table and package cache conciderations
  203. Linux DB2 Client Hangs when Connecting to Remote Host
  204. db2 prep and exec sql include
  205. Running concurrent reorg / runstats on DB2 ESE for Aix V8.2
  206. How to create Oracle dblink to DB2 ?
  207. IMS to DB2 Migrations
  208. Fluctuating size of db2 backup, also db2 backup dates have problems
  209. multirow fetch with embedded SQL
  210. "list history" command - How to remove entries?
  211. A question about setting logsecond to -1
  212. SQL limits
  213. Table size in bytes
  214. db2look throws 1427N
  215. Query using a different index than expected
  216. Help with db2Load API (COPY= YES USE TSM)
  217. How To Call Procdure From Function In DB2
  218. Looking for syntax help with ALTER TABLESPACE
  219. DB2 DATA TYPE BLOB INTO VARCHAR
  220. sysproc.snapshot_tbreorg
  221. I am getting this error
  222. Rollback
  223. How can I upload a BLOB/CLOB into a DB2 UDB Column?
  224. Getting started with
  225. Control Center - how to add a system...
  226. CLOB data is getting truncated on SELECT
  227. Proble with DB2 load with column declared as Generated always
  228. code set& territory
  229. Need help in REPLACE function in DB2
  230. Help ... Rollback Transaction
  231. Exception Handling
  232. HOW TO COMMENT OUT BLOCKS OF CODE IN IBM DB2 Control Center console
  233. Anyone with example of DB2 UDB UDF calling Java/C++ routine for Double Metaphone Keys
  234. Timestamps in a Windows Environment
  235. db2 stored procedure not returning value with select into
  236. How can I export the data with del but don't wanna put "" ouside the character data?
  237. How to identify installed DB2 version?
  238. problem with SQL replication with SQL1476 with slqcode "-430"
  239. timestamp issue
  240. Anyone have good experience leaving the HEALTH_MON on ?
  241. Trying to View DB/2 File on NT from AS/400 with SQL
  242. DB2 Query !!
  243. Do you need to recompile user exit
  244. Export DB2 file with correct date
  245. Using sum in nested select
  246. Connection Concentrator Counting of Agents
  247. I need a lot of help with a DB2 query
  248. retrieving stored procedure result sets with embedded SQL
  249. DB2 temporary BP override
  250. Specifying the Isolation Level as UR for all Select Queries Only
  251. Can we use temporary tablespace with reorg indexes all in V8 FP12?
  252. Question on get db cfg
  253. Generating the Insert Scripts for Table in DB2
  254. DB2 certification
  255. Rowset string concatenation
  256. what is this error ?
  257. db2 to oracle migration
  258. Zombie database
  259. DB2 Data Replication Issue
  260. Db2 administrators
  261. On File/aid DB2, refrential integrety
  262. DB2 metadata expoitation
  263. Question About Merge
  264. Regarding DB2 Developers
  265. importing data with date format
  266. DB2 8 - Collect statistics
  267. TRANSLATE function
  268. oracle to db2 export
  269. How to track the execution of procedures in the database
  270. MS ACCESS to Query Data on an IBM iSeries DB2
  271. Regarding SQL Replication
  272. What are the best options to Copy data from one database to a different database with
  273. Cursors, Host Variables in Stored Procedure
  274. create stored proc
  275. Decompressing a compressed backup image
  276. TSM Backup Images
  277. Cannot load program db2licm
  278. DB2 Linux db connect issue
  279. -922 in COBOL CICS DB2 program
  280. choosing a server codeset
  281. Editing DB2-Tables with QMF table editor
  282. count distinct subquery
  283. count distinct subquery
  284. Disable Automatic Storage
  285. Any function can find out the similar numeric string?
  286. DB2 Modified by Clause Problems
  287. Copy DB2 Sequence number from Production to Test
  288. SQL2038N A database system error "-1062" occurred during processing
  289. db2 Subsystem Sharing
  290. Automatic Runstats
  291. AIX DB2 Version
  292. double rounding in gui tools
  293. Vertical data to Horizontal data
  294. Reorg index not using tempspace?
  295. Good ETL tool for MySQL->DB2
  296. Product / license for z/OS Universal Driver on clients
  297. Isolation Level on DB2 UDB 9.1.1
  298. Stupid delete logical question
  299. which sql is better on perfomance in DB2 and how conditional where clause works?
  300. Question Marks in Event Monitor
  301. Can I alter (increase) a column size with the data type as blob
  302. load text files to DB2 dbase
  303. load data with admin_cmd()
  304. Deleting LOB values taking very long time !!
  305. Just installed DB/2 9.1 on AIX, no db2cc?
  306. price of db2 certification?
  307. Force isolation level for a user
  308. Help with returning output of FOR loop in a DB2 function
  309. UNLOAD utilitiy on DB2V8 for ZOS
  310. DB2XML.SOAPHTTV - Could not allocate memory.
  311. Help with stored procedure
  312. DB2 Nicknames and Indexes
  313. how to diable table in Db2
  314. Update across 2 tables
  315. db2_evaluncommitted , db2_skipinserted and db2_skipdeleted
  316. db2fmp EACCES errors in 9.5 while trying to access tablespacecontainers
  317. SQL/XML nested child problem
  318. Problem with DB2 connectivity using Java
  319. Can i find process id in UNIX/AIX corresponding to a particular AgentId
  320. Batch Spufi - Db2
  321. Array data type in Triggers
  322. INTERNALP_LOCK, INTERNALC_LOCK, INTERNALV_LOCK on queryingSYSIBMADM.SNAPLOCK
  323. Any body could help me out on DB2 stored procedure on Z/OS
  324. Experiences with database extensibility
  325. Using Array content in IN expression
  326. DB2 8.x in Z/OS - rownumber() over not working
  327. Question on Replication
  328. DB2 RExx example
  329. External Stored Procedures Limitations?
  330. Dropped Tablespace
  331. Dyanamic Sequence name in User defined SQL function
  332. How to get only dupliacate rows from the table through COBOL-DB2 program?
  333. problem with MQT
  334. Export DB2
  335. The column name as com.ibm.db2.jcc.b.dc@1d5b3a
  336. Try this site
  337. Nees sample Questions for Exam 701
  338. Trigger Updating another table gives SQL0206N
  339. db2 instances
  340. views going invalid
  341. Import data question
  342. can't create nicknames for tables with distinct type
  343. manual performance monitoring query
  344. common table expressions
  345. Two-phase commit with Federated Database (AIX UDB 8.3)
  346. db2fmp high cpu ( DB2 8 + FP 12 )
  347. DB2DIAG Error :DIA8305C Memory allocation failure occurred.
  348. MSSQL2K > DB2Connect > mainframe
  349. MSSQL2K > DB2Connect > mainframe
  350. DB2 V8 32-bits and 64-bits instance
  351. Format of a string
  352. DB2 UDF...need to eliminate IF statement
  353. Tab delimited file with comma seperated column headings.
  354. Replication with Federated DB2UDB Tables
  355. db2 load content from text file
  356. DB2 connect with vse
  357. M'I`5,Persec ution , wh y the s ecurity se rvices?
  358. SMS or DMS
  359. Use of port 523 from Control Center
  360. Thoughts about SMS tablespaces
  361. Reset Sequence Procedure to max value of table.column_name
  362. difference in number of records for select count(*) and select *
  363. Equivalent DB2 Datataypes comapred to PostgreSQL
  364. Out of private memory heap
  365. SQL0469 on DB2 stored procedure CALL
  366. Redirected Restore using Veritas NetBackup
  367. writing the text output to a external flat file from a db2 stored procedure
  368. Need DB2 V9 730 Exam Dump
  369. How to insert csv file into clob column
  370. Transaction Ended- application agentid 0
  371. Question on NORETRIEVE option in ROLLFOWARD
  372. IBM DB2 ODBC Driver
  373. Executing multiple db2 scripts
  374. index fragmentation and explain
  375. DB2 DBA for bangalore/Denmark Openings
  376. db
  377. Sql1035n
  378. The -s option of the db2icrt command
  379. Re-certification for new DB2 Versions
  380. How to Terminate a Load Utility
  381. Date formatting for DB2 load utility
  382. How to pass a value between DB2 SQL scripts in KSH?
  383. Error in db2diag
  384. DATE being returned as math problem
  385. Number of applications only growing
  386. isdigit ?
  387. How to connect to db2 server in Sybase Power Designer?
  388. Problems reading crypted string in DB2 8.2 via JDBC
  389. DB2 Connect 7.1 under Windows
  390. regarding restore
  391. Estimating size of a table with LOB column
  392. SQL2312 versus SQL0973
  393. Strange results, playing with table function
  394. How to restore a DB2 online back up to a Different server
  395. DB2 Database Catalog
  396. Rollforward-1
  397. rebind package
  398. online testing
  399. Removing unneeded logs
  400. open source DB2 Monitoring Console on sourcefoorge
  401. XA oddness....
  402. Rollforward
  403. migrating a database between machines
  404. Sybase to DB2 Migration..
  405. checksum validation
  406. Resultset returns null while calling a DB2 stored procedure using hibernate
  407. unexpected error external database driver (9221) ???
  408. DB2 services won't start - Help!
  409. Sinking Feeling
  410. SQL2001N
  411. A security issue
  412. Connect ASP.net(2.0) to AS400 Iseries w/ DB2
  413. How to see/get the contents ina CLOB field
  414. Flushing Dynamic sql cache
  415. Bad container path. SQLSTATE=428B2
  416. How to create an index fast?
  417. q: BIT OPERATIONS and their usefullness..
  418. problem exporting data from mainframe using db2 connect connectingfrom db2 on linux
  419. Query Performance question
  420. DSNT207I
  421. Deleting rows - what's most efficient?
  422. Yellowfin Business Intelligence Version 3.3 release
  423. How to create a trigger that detects updates to columns (includingNULLs)
  424. Converting timestamp to int?
  425. DB2 Error Codes
  426. Migration from MVS to Oracle 10
  427. DBA Requirements
  428. Package cache hit ratio,
  429. RAID vs isolated spindles
  430. SQL8002N
  431. Problem with Delete
  432. Automatic client reroute
  433. IMPORT or LOAD commands in ASP
  434. How to create a cobol subroutine(sub PGM) as DB2 interface
  435. Lock Escalation
  436. HADR question
  437. Structured Types
  438. Additional Certification Questions
  439. Load Utility
  440. Urgent HELP on Converting columns to rows
  441. Parsing resultset from procedure to procedure to caller
  442. Large Volume Transaction Load
  443. Graphic data and graphic functions not supported for DB2
  444. Can't find stored procedure - help!
  445. How to run Runstats and Load in stored procedure
  446. SQL for counting number of times a varchar repeated in a table
  447. programmatically updating table statistics
  448. With .. Select structure
  449. Updating dbm cfg parameters from Application Program
  450. Select MAX, 2nd highest, etc.
  451. Displaying columns not in Group By or SELECT
  452. error regarding importing IXF data
  453. Get multiple resultsets from multiple tables
  454. getting a (-911)deadlock error while dropping a procedure
  455. Need to extract numbers from a varchar column
  456. How to give the DB2 access for the local users on zLinux
  457. SQL PL
  458. Finding top x percent of data
  459. Use of MONTH() function
  460. Database Migration - log full error
  461. Predicate evaluation across federation
  462. V9 Compression & Log Use
  463. How to recover database
  464. Problem creating Event monitor
  465. mysql dump into DB2 os400 database
  466. attach tablespace to user
  467. Looking for the GET_DB_CFG function
  468. how to extract first business date of each month
  469. Another Security Question for DB2 V8
  470. Error starting database after converting DB2 instance to 64 bit
  471. Security Question re DB2 V8
  472. A simple question:whether deadlcok will occur if db only select andthers is no lock for reading
  473. drop tablespace
  474. DB2Connect - Cursor issue
  475. DB2 Using LOAD Command with ASP.NET
  476. deadlock or timeout (very urgent)
  477. IBM JDBC Driver (Type4) connection Windows Vs Z\OS
  478. Facing Problem while querying larger tables
  479. Netbackup for DB2 Redirected restore
  480. forcing an application, unable to force, create index statement justgot stuck
  481. DB2Express-C 9.5
  482. SQL Query x Multiple table Scans
  483. How to search with Accent Insensitive and Case Insensitive
  484. SQL0659N Maximum size of a table object has been exceeded
  485. When does a DB2 database become inconsistent?
  486. Runstats Required for Static SQL ?
  487. Matching SQLCODES to SQL Statements
  488. Integrity rules XML schema
  489. How do I Unload from DB2 Z/OS(Mainframe) for load into DB2 UDB Windows and Linux?
  490. load command
  491. Question on using rebind with auto-runstats/auto-reorg
  492. How to compare the values from a table with a cursor in DB2
  493. DB2 vse and DB2 UDB
  494. WBI Monitor
  495. Volatile status of tables
  496. Executing stored procs directly on mainframe
  497. Restore DB2 backup to an old system date
  498. Db2 DBA requirement
  499. add storage
  500. inserting clob data in db2 database
  501. Suggestions on best performance for query...
  502. Question on health indicator
  503. VB6 fat client using Crystal Reports 10
  504. Deleting a table: Why isn't db2 taking an obvious shortcut?
  505. Want to download AS400 files through FTP automatically.
  506. UDB LUW 9.5 + Net Search Extender
  507. Order by based on input / DECLARE cursor clause based on parameter
  508. Instance Question
  509. Split mirror of HADR Standby Database
  510. How is called DB2 SQL Dialect?
  511. How can the data type be changed from BigInt to Integer
  512. How to find which SQL is causing the Lock
  513. Another DB2 Certification Question
  514. DB2 Certification
  515. Mixing code levels
  516. Problems with DB2 after Fikpax update (SQL30080N)
  517. How to tell if a table is in REORG PENDING state
  518. No update possible at the begining of online incremental backup
  519. Recovering Database from files [DB2 Express-C]
  520. search
  521. Need to insert blank/empty value in not null column
  522. How to pass the date parameter in the DB2 stored Procedure
  523. Creating database from a catalogeed node
  524. Authentication client security exposure?
  525. pattern matching
  526. cryptic error in after the Column involved in PK was dropped
  527. Critical table
  528. Static and Dynamic table
  529. VARCHAR field memory storage
  530. Convert Alphanumeric Data Into Binary Format
  531. To Date function
  532. Description of error codes for SQL2025N
  533. Anyone using 9.5 yet?
  534. Error backing up DB2 database on Linux to NFS system
  535. Date formatting with DB2 type 4 JDBC Driver
  536. Equivalence of join and exists
  537. marking fmp as unstable (+hexdumps of the error)
  538. explain Plan
  539. SQL question!!
  540. Date issue on interger field
  541. dynamic compound statement
  542. performance of db2 7 on mainframe
  543. db2 udb on windows - db2mtrk
  544. db2event => db2detaildeadlock, useless entry every 8 seconds fills mydatabase creating errors
  545. how to insert a null value in a db2 datetime column ?
  546. value added activities done by DB2 DBA
  547. DB2 - Problem with using LIKE predicate
  548. Retrieving programid & jobname on SQL TRIGGER iSeries
  549. IDTHTOIN Alternatives DB2 v7 z/OS
  550. Load terminate error; SQL0104N