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