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. open source DB2 Monitoring Console on sourcefoorge
  2. XA oddness....
  3. Rollforward
  4. migrating a database between machines
  5. Sybase to DB2 Migration..
  6. checksum validation
  7. Resultset returns null while calling a DB2 stored procedure using hibernate
  8. unexpected error external database driver (9221) ???
  9. DB2 services won't start - Help!
  10. Sinking Feeling
  11. SQL2001N
  12. A security issue
  13. Connect ASP.net(2.0) to AS400 Iseries w/ DB2
  14. How to see/get the contents ina CLOB field
  15. Flushing Dynamic sql cache
  16. Bad container path. SQLSTATE=428B2
  17. How to create an index fast?
  18. q: BIT OPERATIONS and their usefullness..
  19. problem exporting data from mainframe using db2 connect connectingfrom db2 on linux
  20. Query Performance question
  21. DSNT207I
  22. Deleting rows - what's most efficient?
  23. Yellowfin Business Intelligence Version 3.3 release
  24. How to create a trigger that detects updates to columns (includingNULLs)
  25. Converting timestamp to int?
  26. DB2 Error Codes
  27. Migration from MVS to Oracle 10
  28. DBA Requirements
  29. Package cache hit ratio,
  30. RAID vs isolated spindles
  31. SQL8002N
  32. Problem with Delete
  33. Automatic client reroute
  34. IMPORT or LOAD commands in ASP
  35. How to create a cobol subroutine(sub PGM) as DB2 interface
  36. Lock Escalation
  37. HADR question
  38. Structured Types
  39. Additional Certification Questions
  40. Load Utility
  41. Urgent HELP on Converting columns to rows
  42. Parsing resultset from procedure to procedure to caller
  43. Large Volume Transaction Load
  44. Graphic data and graphic functions not supported for DB2
  45. Can't find stored procedure - help!
  46. How to run Runstats and Load in stored procedure
  47. SQL for counting number of times a varchar repeated in a table
  48. programmatically updating table statistics
  49. With .. Select structure
  50. Updating dbm cfg parameters from Application Program
  51. Select MAX, 2nd highest, etc.
  52. Displaying columns not in Group By or SELECT
  53. error regarding importing IXF data
  54. Get multiple resultsets from multiple tables
  55. getting a (-911)deadlock error while dropping a procedure
  56. Need to extract numbers from a varchar column
  57. How to give the DB2 access for the local users on zLinux
  58. SQL PL
  59. Finding top x percent of data
  60. Use of MONTH() function
  61. Database Migration - log full error
  62. Predicate evaluation across federation
  63. V9 Compression & Log Use
  64. How to recover database
  65. Problem creating Event monitor
  66. mysql dump into DB2 os400 database
  67. attach tablespace to user
  68. Looking for the GET_DB_CFG function
  69. how to extract first business date of each month
  70. Another Security Question for DB2 V8
  71. Error starting database after converting DB2 instance to 64 bit
  72. Security Question re DB2 V8
  73. A simple question:whether deadlcok will occur if db only select andthers is no lock for reading
  74. drop tablespace
  75. DB2Connect - Cursor issue
  76. DB2 Using LOAD Command with ASP.NET
  77. deadlock or timeout (very urgent)
  78. IBM JDBC Driver (Type4) connection Windows Vs Z\OS
  79. Facing Problem while querying larger tables
  80. Netbackup for DB2 Redirected restore
  81. forcing an application, unable to force, create index statement justgot stuck
  82. DB2Express-C 9.5
  83. SQL Query x Multiple table Scans
  84. How to search with Accent Insensitive and Case Insensitive
  85. SQL0659N Maximum size of a table object has been exceeded
  86. When does a DB2 database become inconsistent?
  87. Runstats Required for Static SQL ?
  88. Matching SQLCODES to SQL Statements
  89. Integrity rules XML schema
  90. How do I Unload from DB2 Z/OS(Mainframe) for load into DB2 UDB Windows and Linux?
  91. load command
  92. Question on using rebind with auto-runstats/auto-reorg
  93. How to compare the values from a table with a cursor in DB2
  94. DB2 vse and DB2 UDB
  95. WBI Monitor
  96. Volatile status of tables
  97. Executing stored procs directly on mainframe
  98. Restore DB2 backup to an old system date
  99. Db2 DBA requirement
  100. add storage
  101. inserting clob data in db2 database
  102. Suggestions on best performance for query...
  103. Question on health indicator
  104. VB6 fat client using Crystal Reports 10
  105. Deleting a table: Why isn't db2 taking an obvious shortcut?
  106. Want to download AS400 files through FTP automatically.
  107. UDB LUW 9.5 + Net Search Extender
  108. Order by based on input / DECLARE cursor clause based on parameter
  109. Instance Question
  110. Split mirror of HADR Standby Database
  111. How is called DB2 SQL Dialect?
  112. How can the data type be changed from BigInt to Integer
  113. How to find which SQL is causing the Lock
  114. Another DB2 Certification Question
  115. DB2 Certification
  116. Mixing code levels
  117. Problems with DB2 after Fikpax update (SQL30080N)
  118. How to tell if a table is in REORG PENDING state
  119. No update possible at the begining of online incremental backup
  120. Recovering Database from files [DB2 Express-C]
  121. search
  122. Need to insert blank/empty value in not null column
  123. How to pass the date parameter in the DB2 stored Procedure
  124. Creating database from a catalogeed node
  125. Authentication client security exposure?
  126. pattern matching
  127. cryptic error in after the Column involved in PK was dropped
  128. Critical table
  129. Static and Dynamic table
  130. VARCHAR field memory storage
  131. Convert Alphanumeric Data Into Binary Format
  132. To Date function
  133. Description of error codes for SQL2025N
  134. Anyone using 9.5 yet?
  135. Error backing up DB2 database on Linux to NFS system
  136. Date formatting with DB2 type 4 JDBC Driver
  137. Equivalence of join and exists
  138. marking fmp as unstable (+hexdumps of the error)
  139. explain Plan
  140. SQL question!!
  141. Date issue on interger field
  142. dynamic compound statement
  143. performance of db2 7 on mainframe
  144. db2 udb on windows - db2mtrk
  145. db2event => db2detaildeadlock, useless entry every 8 seconds fills mydatabase creating errors
  146. how to insert a null value in a db2 datetime column ?
  147. value added activities done by DB2 DBA
  148. DB2 - Problem with using LIKE predicate
  149. Retrieving programid & jobname on SQL TRIGGER iSeries
  150. IDTHTOIN Alternatives DB2 v7 z/OS
  151. Load terminate error; SQL0104N
  152. DB2 - Select ... Output Option....
  153. Is it possible to connect to DB29.1 with a .vbs script?
  154. Suggest a Book for beginner
  155. Updating dbm cfg parameters from Application Program
  156. Updating dbm cfg parameters from Application Program
  157. DB2 delete performance
  158. DB2 UDB V9.5 Windows ENCRYPT
  159. How to setup the IBM Ruby and Python drivers for DB2 on Linux (32/64bit)
  160. VB.NET create/insert/select From Temp table
  161. DB2 Stress Testing
  162. strange problem while reorganizing the table, cannot do anything
  163. db2ntclp
  164. backup compress in viper 2
  165. Pagination in DB2
  166. Binding db2updv9.bnd failed with sqlcode = -31
  167. Load failure; SQL0104N
  168. Cannot Connect in DB2 Control Center
  169. UPDATE sql
  170. IBM DB2 JDBC Driver CallableStatement update count
  171. rownum in DB2?
  172. DB2 cutting logs frequently
  173. MDC Design question
  174. ODBC DSN Connection Error
  175. Count Unicode characters in DB2 8
  176. Encryption and key management best practices
  177. Export from DB2 causes file to be created with permissions of 640
  178. Cursor variables
  179. Special Characters
  180. about the special characters
  181. load failure - SQL0104N Db2 version 9
  182. DB2 High Performance Unload + remove unwanted data
  183. Newbie question : SQL search problem with substituted characters
  184. UDB XA coordinated transactions with MQ
  185. Performance Tuning for DB2 DB.
  186. Questions about number of connection and components to check for the status of DB2
  187. create / connect hanging on V9.1 FP3a
  188. Serge: How are those ...
  189. Minimum unit of I/O
  190. sql optimization
  191. Is creating indexes on date cols fo MAX /MIN aggregate functions good?
  192. cofused about SQL Optimization
  193. cofusing about sql optimization
  194. Db2 Create Tablespace Performance Impact
  195. Insert performance into DB2 using informatica
  196. DSNREXX and RXD2 from BMC mainview - coding difference
  197. Important about Novell Certifications
  198. select in select and concatenate strings
  199. Pattern Matching using LIKE predicate on a DB2 column using INDEX
  200. DB2 Session variables (or equivalent)
  201. Lock Manager Heap
  202. Question on Error Return Code SQL0902 Reson Code 18
  203. db2fm -D ; Error: failed to find the default instance. Environment variable not set
  204. "The statement is too long or too complex".for a simple Alter table statement from CLP
  205. Where is performance for IBM websites ?
  206. Converting from char to date/time
  207. load with cursor VS. Pipe
  208. db2chgpath msgs logged on db2 V9 client install on linux
  209. Undo handler across federated system
  210. Storing Table
  211. table design
  212. Tracking a Delete
  213. MS Query Issue
  214. db2look option with table create statements only
  215. help with SP
  216. Error Evaluating CHECK constraint.
  217. Stored Procedure - Help Needed
  218. problem in Refreshing Table
  219. Export function fails on DB2 v7.1
  220. Federated DB Bad Query performance
  221. DB2 9 FP3 - Linux vs Windows engines with AIO or a Db2 universal jdbc driver performanc?
  222. DB2v8.2 LUW. Unable to drop Foreign Key constraints...
  223. SQL3107W There is at least one warning message in the message file.
  224. IF EXISTS in db2
  225. Hi
  226. multiple cloumns in single row
  227. IBM Db2 Certification 700 Exam
  228. data warehouse center
  229. purexml
  230. SQL0440N No authorized routine named error
  231. Detecting RI datatype mismatches
  232. reduce large container to small container with same size
  233. Problem with a user defined function
  234. How to get aggregate statistics
  235. Package "NULLID.SYSLN31E 0X5359534C564C3031" was not found
  236. SYSIBM.SQLSTATISTICS
  237. How to determine if the Client Install on AIX is Runtime or Admin???
  238. Revoked System Privlege / Some Object Privlege remains for Public...... Does Public still have any access ?
  239. Please help me save this query
  240. CPUSPEED
  241. Updating across databases
  242. Does DB2 support Array and Object oriented types like what's in Oracle?
  243. REORG
  244. Import Dump file.
  245. DB2_PARALLEL_IO
  246. DATA_ENCRYPTION problem
  247. Online backup fails with sql0911
  248. Split data to different DB2 subsystems
  249. archiving log files for no reason
  250. Error -2147217900 [IBM][Controlador ODBC de iSeries Access][DB2 UDB]SQL0104
  251. DB2 as a Web service consumer using SOAPHTTPV
  252. Weird - Uncommanded schema change in mid script
  253. db2 biggner
  254. Anonymous Block in DB2
  255. Comparing data in two different DB2 tables.
  256. Restore problem, unknown version of DB2 created the backup
  257. Get db2 backup size from TSM in Windows environment
  258. Urgent: some special error in db2diag.log
  259. ossSetAssertionCallback while install Linux Client
  260. What's wrong with the following set of commands and why
  261. Subquery Performance
  262. Please help to optimize the SQL Query
  263. CTE in function
  264. Running long statements with Java/C++/CLP
  265. start hadr as standby fails with SQL1768N rc=7
  266. Need help on Joins..
  267. Unable to connect to the DB visualizer with my tool
  268. SQL on Fire - Mass Deleting Data.
  269. How can I connect to a DB without typing my userid and password
  270. ASNCLP create apply control tables error.
  271. Corba, Msp
  272. How to compute storage utilization per schema
  273. Fixpak for Client running on AIX
  274. How to compute storage utilization per schema
  275. Using IBM Rational Build Forge with DB2 Express v9.1
  276. Yellowfin Release 3.3
  277. Modifying DB2 Profiles/Config files
  278. Restore DB problem
  279. how to use db2 connect server as a gateway to connect to mainframe db2 database
  280. Updating Java routines UDF on db2 UDB V8 FP10
  281. Updating Java routines
  282. Altering column's default in db2 V8
  283. Altering columns in DB2 V8
  284. Cursor load giving SQL0668 error
  285. Problem with SQL Query
  286. DB2GOV and DB2QP
  287. v7.2 client talking to a v9.1 database
  288. What is the min container size for DMS?
  289. Needed SQL
  290. DB2 Installation Failure (RC=1618) - Windows XP
  291. DB2 date display and formatting
  292. Sqlcode -430
  293. Logical Reads = CPU Consumption ???
  294. deleting large amounts of records
  295. Slow, hanging when deleting large number of records.
  296. trying to get the functions dependent on a table
  297. Problem comparing dates with VARCHAR type
  298. Excessive physical space usage, DB2 9 on Linux
  299. REORG Table and UTIL_IMPACT_PRIORITY
  300. Question paper for db2 exam 730
  301. User abend U1551
  302. how to express a recursive CTE that returns a balanced hierarchy
  303. Problem in inserting row
  304. Duplicate cursor names
  305. Bash Scripting db2move and db2look
  306. Reorg Tablespace
  307. date issue
  308. Problem logging on to DB2 v9 with non-admin rights
  309. updating a large table
  310. SQL30020 on extended ascii characters
  311. What are the data types available in the IBM DB2 database
  312. What are the data types available in the IBM DB2 database
  313. db2 governor failing with connection refused
  314. Forcing an HJOIN
  315. db2audit autostart
  316. Calling AIX shell script from a trigger
  317. Get unlimited visitors to your website
  318. Db2 query taking more execution time
  319. Perforamcne of Dual Logging in DB2 LUW
  320. Usage of subqueries
  321. db2 loader problem
  322. Bind SQL Error PLAN NOT APPLICABLE
  323. SQL0902C with reason code="32"
  324. SQL1092N "" does not have the authority
  325. Can a flat dataset from a DSN1COPY run be used to Load a DB2 table? and other questions...
  326. 2nd try (renamed): NOT LOGGED DGTTs and the transacgtion log
  327. IBM DB2 UDB 2005 Reporting Services
  328. SCD-2
  329. Merge statement for type 2 dimension
  330. Sample DB2 Log File
  331. how to append to the update statement.
  332. Visual Explain Error (SQL0104N) on Query Rewrite
  333. small sample web site to test db2 db connectivity
  334. for update statement
  335. URGENT : procedure to import data from excel sheet
  336. Does DB2 allow the user name to contain DBCS/Unicode characters?
  337. BOM QUERY IN TRIGGER
  338. DB2 Database 9 and licensing?? -> Connection trouble
  339. getting very cryptic error while inserting the records
  340. "update command options using m on" doesn't work
  341. Trying to install V9fp3
  342. no Info Integrator, so Linked Server in SQLServer2005...
  343. Urgent request: Db2 on Z/OS - How can a recovered tocopy tablespace be empty?
  344. Urgent request: How can a recovered tocopy tablespace be empty?
  345. How can I resolve a SQL1326N restore problem?
  346. How can I resolve a "SQL1326N: The file or directory cannot be accessed" restore problem?
  347. Dynamic Cursor in DB2
  348. How to return byte array in UDF?
  349. DB2 Stored Procedure: Setting up a cursor from Java as input parameter
  350. Defining transactions with DB2 procedural language
  351. DOS Batch file to run a Stored Procedure
  352. DB2 Cursor Issue
  353. V8.2 doesnot support this? SQL20165N An SQL data change statement within a FROM clause is
  354. AIX and HP-UX db2 v9 ese fixpacks and Control Center
  355. Help me on DB2 INSERT question
  356. what is the following error msg means,help me..
  357. DB2 error -804 Reason Code 06 and 07
  358. DB2 OLE Driver and Transactions
  359. DB2 Stored Procedure
  360. a communication error has occurred
  361. How to get timestamp to output in format?
  362. DB2 on NFS mounted install
  363. DB2 prep bind needed everytime?
  364. Connecting to DB2 v8 on z/OS from RAD v7 on XP
  365. Error in Roll-Forward due to corruption in Log Files!!
  366. Db 2
  367. DB2 User Monitor. Is it possible?
  368. DB2 IS (Intent Share) Locks
  369. "show explained statements history" doesn't work
  370. Search table with any one or more fields using static sql
  371. EXPLAIN SQL against DGTTs
  372. [ HELP ] How to audit select statement on specify table for db2 LUW v8 or v9
  373. deadlock on a table
  374. merge statement - why it is failing
  375. alternate approach to this sql
  376. DB2 Stored Procedure from SQL Server 2005
  377. DB2 Memory Usage
  378. New to DB2: Create table if exists? How?
  379. Use of Cursor in Trigger?
  380. Automatic database activation
  381. How to split the contents of a column
  382. Copying database 'data' to 'test' on the same instance?
  383. SQL - Update statement
  384. Function ffi_db2date
  385. Starting DB2 UDBv9 Express-C in a Linux environment
  386. Starting DB2 UDBv9 Express-C in a Linux environment
  387. Starting DB2 UDBv9 Express-C in a Linux environment
  388. What are the steps of creating a Cronjob in a Linux environment?
  389. Problem string with literals
  390. Improving DELETE performance for a large number of rows
  391. pricing of Workgroup and ESE
  392. Too many audit events in Event Viewer
  393. ADM10502W attention message from Health Center: Automated backup failed
  394. The database is currently in use.
  395. Which table should I use to get table entry
  396. A Killer Email Message - How to Write Killer Email Promos that Get Results
  397. View the Trigger Source
  398. How to print from AS/400 IPDS to barcode printer?
  399. Sequence as column name in DB2 V8 on MVS
  400. db2Backup API and DB2BACKUP_INCLUDE_LOGS
  401. IBM Iseries Rumba
  402. Data Types in Embedded C queries - problems
  403. ADM5571W
  404. Embedded SQL Select Statement using CICS
  405. db2 Incremental backup
  406. Unable to connect DB2 via db2cc
  407. DB2 instance
  408. o check spaces in db2
  409. db2 COLUMN DEFINITION
  410. DB2 fixpacks
  411. recall MQT definitions
  412. how to execute runstats in stored procedure
  413. Scheduling a DB2 command to run
  414. Execute runstats in a stored procedure
  415. XML storing and management
  416. count on aggregate function
  417. restore problem
  418. getting prevoius day's date in a query?
  419. How to set application name using sqleseti api call
  420. DB2 Snapshot log details
  421. What is wrong with this Redirected restore command - UDBv8.2 fp14 on Linux
  422. DB2 Tools/tuning to help performance over high network latency sites?
  423. i can see database in directory, but couldn't connect to it SQL1031N
  424. DB2 Export error
  425. How do you kick off a DB2 Script in AIX ?
  426. Cursor Load
  427. can space be provided as a value in the column (of database) ?
  428. To add line breaks in DB2.
  429. BIRT + Yellowfin + ANN mashup make Advanced Business Intelligence
  430. URGENT : How to Launch DB2 AS 400 program from PHP trough ODBC ?
  431. Does count(sum()) function work in ibm iseries navigator ?
  432. SQL0906N while opening cursor
  433. db2fmcd in /var/adm/wtmpx
  434. URGENT: sample WAS application on DB2 SAMPLE
  435. Connecting to DB2 server from Client machine for Business Objects
  436. Trigger in DB2
  437. List if default user ids with default passwords
  438. Remote database access within MB flow
  439. About Date & Graphic format
  440. list of db2 installed products
  441. if db2 udb can create hash index?
  442. performance implications of calling PREPARE more than once
  443. How to revoke the grant option from a user/group
  444. Default value for pool hit ratio
  445. DB2 Index on Physical Table Member
  446. Deep integration w/ DB2 9 in Altova Version 2008
  447. copying data from one table to another in a single SQL statement
  448. Need to extract schema only from db2 on old version of AIX
  449. Calling a cobol sub program from DB2 stored procedure.
  450. Ask for help about a problem of DB2 health monitor usage
  451. UDF has schema issues
  452. Renaming Windows DB2 Server Machine
  453. Error in java while getting connected to DB2
  454. DB2 Failover
  455. 32 & 64 bit Instance on the Same AIX Box
  456. Blob column from not logged to logged
  457. AIX doesn't know DB2 is installed
  458. SQL select not working when starting program is a stored procedure.
  459. Using .NET to access to a IBM DB2 database
  460. Encryption of transmissions
  461. Moving DB from DB2/Oz to DB2 UDB on soloris
  462. Does DB2 support schema acquirement automatically
  463. Good Questions for db2/400
  464. Error ADM1832E
  465. sql1042C error when I tried to activate a DB
  466. How to clear Secondary log files
  467. monitoring
  468. getting error while calling ADMIN.BACKUPSCHEMA
  469. Bufferppol size...-1
  470. getting error while calling ADMIN.COPYSCHEMA
  471. The setup routines for the iseries Access ODBC Driver could not be found.
  472. Suggest me Beginners Tutorials for DB2
  473. stored procedure lock question
  474. Cursor SQLCURSOR000000491 not open
  475. Grant on Proc not working
  476. Why OR extremely slows down the query?
  477. DB2 & MSCS Node Problem
  478. Error on DELETE -- whats wrong????
  479. How to recover the db2diag.log file
  480. sas9 Z/OS WORK space allocations
  481. Error in calling remote nested SP
  482. Arts and entertainment
  483. Cannot Reorganise any table in the tablespace
  484. want a code for e-ticketing
  485. Minimum Req for DB2 Installation
  486. Can changes done by the trigger be replicated back?
  487. How to identify the specific DB2 version installed in a system and restore a db to that.
  488. db2 cursor
  489. Compatibility of DB2 Express C V9.0 backup to be restored on DB2 ExpressEdition 8.2
  490. Does anyone use TestBase
  491. Adding procedures to triggers...
  492. ORA schema in DB2 r5.1
  493. DB2 Load Identity Column
  494. Loading Identity Columns
  495. db2 luw load chardel
  496. Stored Procedure
  497. How to retrieve the field heading
  498. db2 select & group by
  499. DB2 V9 Compatibility
  500. What is wrong with this Script? Problem with DECLARE etc, etc
  501. Using DFSMS Copy
  502. SQL Replace Function Problems
  503. Comparison problems
  504. Arabic Codepage conversion problem from WIN to Z/OS
  505. On what parameter does Database Capacity depend
  506. ADO users
  507. Arithmetic overflow or other arithmetic exception occurred
  508. Set maximum number of rows on a table?
  509. Warning message from notification log
  510. load a table from an IMS File
  511. DB2 and PostgreSQL federation
  512. How many extents are allocated when a table is created
  513. Can't update admin cfg
  514. problem in connecting to DB2 V8.1 and WAS V6
  515. revoking Privilege from One Admin User On Table Owned by Another Admin User
  516. Can Triggers work in different databases ?
  517. Index - DB2 tables
  518. client licensing question
  519. Error reading recordset from DB2/AS400
  520. I need help.....Loading from XML to DB2 table
  521. some help with ODBC or OleDB please
  522. Need help with some weird date manipulations
  523. How to run stored procedure in Command Line Processor
  524. size of the database
  525. Hi... Insertion in to Global temporary tables in db2
  526. Dynamic SQL
  527. trigger with check integer column
  528. Sqlcode -927
  529. cpytoimpf failing on V5R4
  530. Db2 701 Exam
  531. What is wrong with this SQL? Problem with Long Varchar column at create Table
  532. Vexing Problem with DB2 UDB Design Advisor? Any Suggestion, please!
  533. How can REORGCHK and REORG be used together in a Script to select DB2 UDB objects to Reorg?
  534. If you really want lauf, cklick down on the link:
  535. DB2ConnectionCorrelator: NF000001.F3C6.070908215236
  536. VB6 ADO and OUT PARAMETERS
  537. please help me
  538. Need Help Urgently! DB2 8.2 on Linux - suddenly unable to connect to any DB
  539. DB2 V8 FP12 - Merge Statement - Plan Question
  540. db2 standard backup practices
  541. Copy Table shows target databases wrong in Control Center
  542. db2 UDB backup using COMPRESS option
  543. Clob exception in DB2 CLP
  544. View Tables of DB2 Database using JDBC
  545. how to connect to db2 database
  546. -811 SQLCODE Behaviour !!!
  547. DB2 database IDE
  548. instance creation problem
  549. Can I access DB2 DB with Toad Client
  550. IOs in DB2