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